What is Boyce-Codd Normal Form (BCNF)?

What does BCNF stand for?

Boyce-Codd Normal Form (BCNF) is one of the kinds of Database Normalization. A Database desk is in BCNF if and most effective if there are not any non-trivial purposeful dependencies of Attributes on whatever apart from a superset of a Candidate Key.

BCNF is also every so often called three.5NF, or three.Five Normal Form.

What Does Boyce-Codd Normal Form Mean?

BCNF became advanced by Raymond Boyce and E.F. Codd; the latter is extensively considered the daddy of Relational Database layout.

BCNF is truly an Extension of Third Normal Form (3NF). For this motive it's far frequently termed 3.5NF. 3NF States that every one information in a Table ought to depend handiest on that desk’s number one key, and not on any other area within the table. At first glance it might appear that BCNF and 3NF are the same factor. However, in a few rare Instances it does appear that a 3NF desk isn't always BCNF-compliant. This can also show up in tables with two or extra overlapPing composite candidate keys.