+0 -0
BCNF stands for Boyce-Codd Normal Form, it is a type of normal form used in database design to ensure that a database is free of certain types of redundancy and inconsistencies.
It is a more stringent version of the Third Normal Form (3NF).
A relation in BCNF must meet the requirements of 3NF and in addition, every determinant must be a candidate key.
A determinant is an attribute (or set of attributes) that uniquely identifies a row in a table. A candidate key is a set of one or more attributes that can be used as a unique identifier for a row in a table.
BCNF is very useful in the case of multi-valued dependencies and join dependencies.