Database normalisation

Problem Explain database normalisation and its trade-offs.

Be ready to discuss

• Goals: reducing redundancy and update/insert/delete anomalies.
• Normal forms: 1NF, 2NF, 3NF, BCNF and what each removes.
• Functional dependencies and how they drive decomposition.
• When to denormalise for read performance, and the write/consistency cost.