Topic 11

Question 1

What are the advantages and disadvantages of a relational database?

Answer 1

Ad- less data duplication. Data only needs to be entered once, which saves time. Improved data integrity

Dis- more technical knowledge is needed to set up the database. More expensive software.

Question 2

What are the two main approaches to a database called?

Answer 2

Flat file- all data is stored in one big table where one row is one record.

Relational- uses a series of tables which are linked to one and another