• 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

    This all helps Sony to keep on top of the competitive market. * Microsoft's Xbox 360 is the first of the new generation consoles, but sales did not encounter as much success as expected. As its launch came very late in the year this is not too shocking.

  2. Setting up a good video shop.

    These are just two sources I can look at to find out more about the video shop that I am planning to open up. Analysing potential methods of research has shown me that I prefer to use questionnaires as the means of collecting data that is required for the video shop.

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

    I did this by using the controls e.g. Drop boxes and tick boxes, and this allows the visitors of my website to leave information about themselves if they wish, and it leaves me to contact them with any offers I have on my website. Dreamweaver is also web-authoring software which you need to create a website.

  2. 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.

  1. 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.

  2. Many Swedish newspapers publish all or parts of their articles and advertisements on the ...

    The Internet papers that have a regular TV channel have a strong marketing advantage. Suppliers The changing distribution channels results in that previous suppliers are exchanged. The Internet newspaper does not need paper or printing, instead suppliers related to the new technology e.g.

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