First page Back Continue Last page Graphics
Third Normal Form
Comparison of BCNF and 3NF
To summarize
- Design Goals
- Goal for a relational database design is:
- BCNF (no redundant information)
- Lossless join
- Dependency preservation
- If we cannot achieve this, we accept:
- 3NF (possible repetition of information)
- Lossless join
- Dependency preservation
Notes: