Decomposition and Higher Forms of Normalization
"Lossless" Joins
Preserving FDs
Decomposing R Into BCNF
Decomposing R into 3NF
Fact of life...
Contracts schema CSJDPQV
Multivalued Dependencies (MVDs)
Textbook Example (3-way pun)
MVD Theory
Fourth Normal Form
Fifth Normal Form
Normalization Summary
Caveat
Looking Ahead: One Query Is Usually Not Enough
Current Trends
Email: dickey@cs.washington.edu
Home Page: http://www.cs.washington.edu/education/courses/444/99sp/
Download presentation source