Section 11 Chapter 63 - Relational Databases and Normalisation Flashcards by Michael Matthews

Q

Relational database

A

Data is held in tables and the tables are linked by common attributes

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Third order normalisation

A

Make all attributes entirely dependent on the key

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Properties of a normalised database (3)

A

Easy to maintain
Faster to search
Records will always be completely deleted

How well did you know this?

1

Not at all

2

3

4

5

Perfectly