Normalisation

[|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.

Normalising to 1st Normal Form (1NF)
Unnormalised Form (UNF)

First Normal Form (1NF)

Exercises
Locker Allocation Caravan Club

Bank Customer

DVD Rental

DIY Store Orders

Kennel Club