Exam-style question
Try this first
What is a main reason for normalising a database?.
- A.To increase unnecessary duplication of data.
- B.To reduce data redundancy and help prevent update anomalies.
- C.To ensure every table has exactly three columns.
- D.To replace all primary keys with foreign keys.
Model answer
What a good answer should say
- To reduce data redundancy and help prevent update anomalies.
Explanation
Why this works
Normalisation organises data into suitable relations. This reduces repeated data and makes insert, update and delete operations less likely to create inconsistencies.
Common mistake
No common mistake is linked to this question yet.