FLAT FILE VS RELATIONAL DATABASE

rosiejones
Flashcards by rosiejones, updated more than 1 year ago
rosiejones
Created by rosiejones over 6 years ago
98
5

Description

GCSE ICT Flashcards on FLAT FILE VS RELATIONAL DATABASE, created by rosiejones on 05/16/2013.

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
MICROSOFT WORD 2013 SKILLS FOR WORK
John O'Driscoll
Enzymes and Respiration
I Turner
Geography Coastal Zones Flashcards
Zakiya Tabassum
Using GoConqr to teach science
Sarah Egan
GCSE AQA Chemistry 2 Salts & Electrolysis
Lilac Potato
GCSE AQA Physics - Unit 3
James Jolliffe
GCSE Maths: Algebra & Number Quiz
Andrea Leyden
GCSE History – Social Impact of the Nazi State in 1945
Ben C
Using GoConqr to study English literature
Sarah Egan
New English Literature GCSE
Sarah Egan