Table of Contents
Higher Normal Forms and Further Normalization
Normalization through Decomposition
Problems with Normalization through Decomposition
Decomposition into 3NF (example)
Normalization through Synthesis
Algorithm Synthesize
Boyce-Codd Normal Form (BCNF)
BCNF Example
BCNF example
Dependency Preserving Decomposition
Dependency Preserving Decompositions (2)
Decomposition into BCNF
Multivalued Functional Dependencies
Another example
Multivalued Dependencies (MVFDs)
Fourth Normal Form (4NF)
Decomposition into 4NF
Fifth Normal form (PJ/NF)
Decomposition of SPJ
Join constraint
Join dependencies
5th Normal Form
|