Table of Contents
Functional Dependencies and Normalization
Motivational example
Update Anomalies
Update Anomalies
Decomposition: Panacea for anomalies?
Update Anomalies
One More Example
Example (SP join PC)
Functional Dependencies (FDs)
Functional Dependencies (FDs)
Normalization
Non-full functional dependencies
Transitive functional dependencies
2nd and 3rd normal forms
Summary
|