06: Advanced Normalisation

Dr. Rosanne Birney, Mary Lyng, WIT
06: Normalisation 2

Normalisation example


Normalisation (unnormalised to 3NF)


Normalisation beyond 3NF


Boyce Codd Normal Form

Fourth Normal Form

Fifth Normal Form


Data Definition


SQL

Lab-01 SQL 6