First page Back Continue Last page Graphics
Third Normal Form
Informal Presentation
Motivation
- There are some situations where
- BCNF decomposition is not dependency preserving, and
- Efficient checking for FD violation on updates is important
- Solution
- Define a weaker normal form, called Third Normal Form
- FDs can be checked on individual relations without computing a join
- There is always a lossless-join, dependency-preserving decomposition into 3NF
Notes: