First page Back Continue Last page Graphics
Third Normal Form
Comparison of BCNF and 3NF
BCNF or 3NF?
- Relations in BCNF and 3NF
- Relations in BCNF: no repetition of information
- Relations in 3NF: problem of repetition of information
- Decomposition in BCNF and in 3NF
- It is always possible to decompose a relation into relations in 3NF and
- the decomposition is lossless
- dependencies are preserved
- It is always possible to decompose a relation into relations in BCNF and
- the decomposition is lossless
- the information is not repeated
Notes: