FLAT FILE VS RELATIONAL DATABASE

Description

GCSE ICT Flashcards on FLAT FILE VS RELATIONAL DATABASE, created by rosiejones on 16/05/2013.
rosiejones
Flashcards by rosiejones, updated more than 1 year ago
rosiejones
Created by rosiejones almost 11 years ago
216
5

Resource summary

Question Answer
Advantages of Relational databases Data 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.
What is a Flat File database? Where all of the data in the database is stored in one table
What 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
Disadvantages of Flat File databases Data 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.
Advantages of Flat File databases It is very easy to set up and requires no real training to set up or use
Disadvantages of Relational databases It 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.
Show full summary Hide full summary

Similar

Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
Weimar Revision
Tom Mitchell
Biology Revision - Y10 Mock
Tom Mitchell
Hitler and the Nazi Party (1919-23)
Adam Collinge
History of Medicine: Ancient Ideas
James McConnell
Geography Coastal Zones Flashcards
Zakiya Tabassum
Biology- Genes and Variation
Laura Perry
FREQUENCY TABLES: MODE, MEDIAN AND MEAN
Elliot O'Leary
CUMULATIVE FREQUENCY DIAGRAMS
Elliot O'Leary
Enzymes and Respiration
I Turner