Advanced Data Structures

Motiviation

First Normal Form (1NF)

All modern RDMS are 1NF

1NF anomalies

Partial Dependencies

Second Normal Form (2NF)

2NF example

2NF Anomalies

Transitive Dependencies

Third Normal Form (3NF)

3NF Anomalies

Boyce-Codd Normal Form (BCNF)