BBC HomeExplore the BBC
This page has been archived and is no longer updated. Find out more about page archiving.

28 August 2014
Accessibility help
Text only
BBC Key Skills Go to ICT Home
Key Skills Home

BBC Homepage

Contact Us


Data Processing
The Video Store Database

Photo of Chris Video and DVD

Chris owns a video rental store, hiring out videos and DVDs to its members. He decides he needs to use a database.

To start with, Chris wants to have access to a list of all his members, all the DVDs and videos in the store, and all transactions carried out. That way he can keep track of who has borrowed what and also his stock. In order to build his database Chris needs to decide what information to put in it.

key pointInformation stored in a database is kept in tables. You can have as many tables as you want in a database.



If you are unable to view the Flash movie above, click here for a non-Flash alternative

Move on to the next screen to have a look at records and fields.





About the BBC | Help | Terms of Use | Privacy & Cookies Policy