Normalization

The aim of normalization is to remove certain kinds of data redundancy, and therefore avoid update anomalies.

Update anomalies are difficulties with the insert, update and delete operations on a database due to the data structure.