First page Back Continue Last page Graphics
Third Normal Form
Decomposition into 3NF
Principles
- Input/Output
- Input
- A set of functional dependencies F
- A relation schema R
- Output
- A lossless-join, dependency-preserving decomposition in 3NF
- Decomposition of R into relation schemas that are in 3NF
- Canonical Cover
- The set of dependencies Fc in the algorithm is a canonical cover of the functional dependencies
Notes: