Normalisation is the process which database designers use to ensure their data model has data integrity.
We need to go from UnNormalised Form (UNF) to the third normal Fom (3NF)
UNF is where all the data is held in one big table
(e.g a spreadsheet.)
1NF here all the duplicate items are removed
2NF ensures that all the data in the table is dependant on the Primary Key
(i.e. No data item is unlrelated to the PK
3NF removes part key dependancies
NB Relational databases cannot be succesfully implemeted, unkess they are normalised to the 3NF
UNF to 1NF
1NF to 2NF
2NF to 3NF
Codd's Law
The data is dependant on the key (1NF)
the whole key (2NF)
and nothing but the key (3NF)
so help me Codd