Database - How To Movies
 
1. Setting up and creating tables and fields 2. Formatting Fields. 3. Creating Primary Key and Relationships 4. Searching and Creating Reports 5. Editing Reports
 
Home DatabaseUsing Information Internet NAB/Coursework Revision Legal Responsibilities

Database

Types of Database

The two main types of computerised database are flat file and relational.


Flat file databases

A flat file database is like an electronic card index file. In this type of database, the data is stored in a single table. In the case of the DVD rentals system, the table would store data about both members and DVDs.

DVD Code
Title
Cost
Date Out
Date In
Member Number
Name
Telephone Number
002 Finding Nemo £2.50 03/09/04 04/09/04 1034 John Silver 142536
003 American Pie £2.50 27/08/04 28/08/04 1056 Fred Flinstone 817263
003 American Pie £2.50 01/09/04 02/09/04 1012 Isobel Ringer 293847
008 The Pianist £2.50 04/09/04 06/09/04 1097 Annette Kirton 384756
011 Notting Hill £2.50 27/08/04 28/08/04 1012 Isobel Ringe 293847
014 Prime Suspect £2.00 27/08/04 28/08/04 1097 Annette Kirkton 384756
015 Shrek £1.50 10/09/04 11/09/04 1034 Joan Silver 142536

The flat file database contains one record for each DVD rental. This is because flat file databases only allow a single value to be stored in each column


Limitations of flat file databases


There are a number of problems with flat file databases.

In fact, a flat file database is not much of an improvement on the manual system!

Click here for a quick quiz on limitations.


 

 



 

Intermediate II Home
Database | Using Information | Internet | NAB/Coursework| Revision
Log into Glow | School Website | Contact Us