Flashcards
FLAT FILE VS RELATIONAL DATABASE
Cards in this deck (6)
- 1Advantages of Relational databasesData doesnt have to be duplicated, this reduces the risk of errors.
Less data makes the file smaller so it is likely to run quicker.
Quicker to use as the main data would already be there and only new data has to be added. - 2What is a Flat File database?Where all of the data in the database is stored in one table
- 3What is a relational database?Where data is stored in separate sensible tables and then a link (relationship) is established between the tables connecting them together
- 4Disadvantages of Flat File databasesData is often repeated as information is needed again for different events...e.g.when a person comes to the doctors with a different problem than before they will have a new record created for the new problem.
With repeating data there is a higher risk of inputting errors.
With repeated data the file size is larger and could make the computer slower. - 5Advantages of Flat File databasesIt is very easy to set up and requires no real training to set up or use
- 6Disadvantages of Relational databasesIt is complex and difficult to set up.
The fields that are linked must contain the same data otherwise the connection won't work.
The user must be familiar with navigating between the tables.
Information
- Description
- GCSE ICT Flashcards on FLAT FILE VS RELATIONAL DATABASE, created by rosiejones on 16/05/2013.
- Created by
- rosiejones · May 2013
- Updated
- Nov 25, 2016
- Views
- 320
- Tags
- Rating