Databases - Relational Databases Flashcards
1
Q
What is a flat file database?
A
When all data is stored in a single table
2
Q
What are the disadvantages of using a flat file database? (2)
A
Unnecessary duplication of information and the possibility of data inconsistency
3
Q
What is a relational database?
A
When data is stored in more than one table
4
Q
What is a key field?
A
A field that uniquely identifies a table
5
Q
What is a foreign key?
A
A field that is not the key field in its own table but is in another table
6
Q
What are the three types of relationships?
A
- One to One (Car to registration number)
- One to Many (Football team to footballers)
- Many to Many (Students to Teachers)