Databases - Relational Databases

Question 1

What is a flat file database?

Answer 1

When all data is stored in a single table

Question 2

What are the disadvantages of using a flat file database? (2)

Answer 2

Unnecessary duplication of information and the possibility of data inconsistency

Question 3

What is a relational database?

Answer 3

When data is stored in more than one table

Question 4

What is a key field?

Answer 4

A field that uniquely identifies a table

Question 5

What is a foreign key?

Answer 5

A field that is not the key field in its own table but is in another table

Question 6

What are the three types of relationships?

Answer 6

• One to One (Car to registration number)
• One to Many (Football team to footballers)
• Many to Many (Students to Teachers)