First page Back Continue Last page Graphics
Third Normal Form
Decomposition into 3NF
3NF Decomposition Algorithm
- Decomposition into 3NF
- Demonstration
- Assume is the dependency that generated Ri in the algorithm
- B must be in or , since B is in Ri and generated Ri
- Let us consider two possible cases
- B is in but not
- B is in but not
Notes: