Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Explain Boyce-Codd Normal Form (BCNF) ?

A table is in BCNF if every determinant in that table is a candidate key. If a table contains only one candidate key, 3NF and BCNF are equivalent.

A table is in Boyce-Codd normal form (BCNF) if every determinant in the table is a candidate key.

A determinant is any attribute whose value determines other values with a row.

If a table contains only one candidate key, the 3NF and the BCNF are equivalent.

BCNF is a special case of 3NF.

Related Posts Plugin for WordPress, Blogger...
Flag Counter