• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Normalisation in a Video Library

Extracts from this document...

Introduction

Stephen Mathieson NORMALISATION A video library operates in a similar way to any normal library, so the first thing to do is to write down a list of attributes for the whole of the system. It would in this case be easy to put the attributes straight into separate tables but in a more complex system this would not do. It is also important not to list to many attributes, only keeping it to the ones that are definitely needed. MEMBER (Membership number, Surname, Forename, Title, Street, Town, Postcode, Date of birth, Tel. No., (Video number, Video title, Category, Cost, Price, Rental price, Date borrowed)) At this stage I have placed all the attributes into the entity MEMBER. I must now go through the normalisation process to determine how many tables are needed and which ones they will be. ...read more.

Middle

VIDEO RENTAL (Membership number, Video number, Video title, Category, Cost, Price, Rental price, Date borrowed) VIDEO (Video number, Video title, Category, Cost price, Rental price) The data is now in 2NF, it needs to be put into 3NF. To do this we have to look and see if any of the attributes are dependent on other non-key attributes. In this case this is none therefore 2NF becomes 3NF and data shown below is fully normalised. MEMBER (Membership number, Surname, Forename, Title, Street, Town, Postcode, Date of birth, Tel. No.,) VIDEO RENTAL (Membership number, Video number, Video title, Category, Cost, Price, Rental price, Date borrowed) VIDEO (Video number, Video title, Category, Cost price, Rental price) DATA DICTIONARIES * DATA DICTIONARY (Member) Field Name Description Data Type Field Size Primary Key Required Validation Membership number This is a number automatically assigned by the computer to a new member Auto ...read more.

Conclusion

the computer to a new member Auto Number 5 Y Y N Video Title The title of the video Text 40 N N N Category This is the category of the video Text 2 N Y Must be either U, PG, 12, 15 or 18 Cost Price This is the price that the video cost to buy. Currency 5 N N N Rental Price This is the cost of what the video costs to rent form the store Currency 5 N Y N * DATA DICTIONARY (Video Rental) Field Name Description Data Type Field Size Primary Key Validation Video Number This is the number of each individual video Number 5 Primary Key Y Membership Number This is the number of each individual member Auto Number 5 Foreign Key Y Date Borrowed This is the date of when the member borrowed the video. Date/Time 7 Foreign Key Y ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Internet section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Internet essays

  1. The Computer and Video Game Environment

    Avid gamers Occasional gamers Social gamers Lapsed gamers % % % % Amazon 33 20 12 10 Play.com 26 15 12 10 eBay 15 13 9 10 Other Internet specialist 8 7 3 3 Game 11 6 3 4 * I would say that online is winning.

  2. Setting up a good video shop.

    The VCR has become almost as much a part of the furniture in this country as the television, with a player in almost nine out of 10 homes. But the rapid take-up of DVD players represents a major challenge for the video industry.

  1. In assessing the competitive position of a large online trader, we would use the ...

    Amazon sourced more than half of its books from a few distributors to ensure the inventory level and rely on each other. While other product categories, Amazon will not store its inventory by itself but it will order from the suppliers when customers place their order with Amazon.

  2. Web design - build a store guide for a department store.

    To build my website, the software I used was Dreamweaver. It offered everything to be able to create a website such as hyperlinks and navigation bars. I also added a form into my website. I did this by using the controls e.g.

  1. Prototype of the System.

    search function from the add member and view all because they are separate commands. All of the command buttons within the system are logically named in order to keep it simple for the user, the font is clear and the button sizes are kept the same size according to function.

  2. Business Plan - CoViTek is an Atlanta based company that offers a unique value ...

    Reve-lution Int. will offer a unique business-to-consumer service for the rental of videos and DVDs. The technology, containing a fully automated system, will facilitate continuous rental and return of movies bridging the gap between video stores, who only are open 15 hours a day, and services such as the nonexistent Kozmo.com, who offer video delivery for a premium price.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work