Databases - Relational Databases Flashcards

1
Q

What is a flat file database?

A

When all data is stored in a single table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

Unnecessary duplication of information and the possibility of data inconsistency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a relational database?

A

When data is stored in more than one table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is a key field?

A

A field that uniquely identifies a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly