(c) Normalisation to 3NF.

Question 2

What is normalisation?

Answer 2

The process of dividing larger tables into smaller interlinked tables

Question 3

What does 1NF require?

Answer 3

Atomic fields and no repeating groups.

Question 4

What does 2NF require?

Answer 4

1NF + no partial dependencies (non-key attributes must depend on the whole key).

Question 5

What does 3NF require?

Answer 5

2NF + no transitive dependencies (non-key fields must depend only on the key).

Question 6

What is a transitive dependency?

Answer 6

When a non-key attribute depends on another non-key attribute.