• 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

    43 38 45 Gamestation 20 13 16 16 Music/electrical 19 32 23 22 Non-specialists 12 18 28 24 Supermarket 13 22 16 14 This table shows which websites were used to purchase video game consoles or game software in the last 12 months, July 2006.

  2. Setting up a good video shop.

    To make sure the questionnaires are answered correctly and to make are it is a fair test I will get the questionnaires filled in front of me. This would increase the reliability of the information gathered. The results from the above questionnaire were incorporated into graphs so that I would

  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.

    Universal Search Result Error: This error message appears when a user searches for either a member or video which is not in the system. The error message is clear and concise and lets the user know that there is problem by appearing on top of the current operation.

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

    License fees finance them. 6 The Internet newspapers have to take these actors into consideration to develop a strategy. SVT has for example developed and marketed their coverage of Swedish soccer on the Internet (SVT.se). This is also an example of the convergence of markets discussed earlier in this paper.

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