Frequently Asked Questions on 3NF and BCNF
Which one among 3NF and BCNF is stronger Normalization?
BCNF is a stronger form of normalization than 3NF.
Can BCNF be lossy?
The BCNF decomposition always fulfills the lossless-join condition.
Does BCNF have anomalies?
No anomalies does not occur in BCNF.
Difference between 3NF and BCNF in DBMS
A relation is in the third normal form, if there is no transitive dependency for non-prime attributes as well as it is in the second normal form. The Boyce-Codd Normal Form (BCNF) is based on functional dependencies, BCNF has additional constraints when compared to the basic definition of 3NF. In this article, we will see the differences between 3NF and BCNF.