First page Back Continue Last page Graphics
Third Normal Form
Decomposition into 3NF
3NF Decomposition Algorithm
- Decomposition into 3NF
- Demonstration
- B is in but not in :
- must be superkey (why?)
- The second condition of 3NF is satisfied
- B is in but not in
- is thus a candidate key
- The third alternative in the definition of 3NF is satisfied
- Note: we cannot show that is a superkey. This shows exactly why the third alternative is present in the definition of 3NF
Notes: