Normalisation

Introduction
[|Normalisation] is the process of dividing a flat table into smaller tables to remove data anomalies. In other words, normalisation removes the deletion, insertion and update anomalies from a database table.


 * Intermediate 2 / Higher**

Unnormalised Form (UNF)

First Normal Form (1NF)


 * Higher Only**

Second Normal Form (2NF)

Third Normal Form (3NF)

Video Example

[|Worked Example]

Definitions


 * Intermediate 2 / Higher**

Normalisation questions