Boyce-Codd Normal Form (BCNF)
Definition - What does Boyce-Codd Normal Form (BCNF) mean?
Boyce-Codd Normal Form (BCNF) is one of the forms of database normalization. A database table is in BCNF if and only if there are no non-trivial functional dependencies of attributes on anything other than a superset of a candidate key.
BCNF is also sometimes referred to as 3.5NF, or 3.5 Normal Form.
BCNF is also sometimes referred to as 3.5NF, or 3.5 Normal Form.
Techopedia explains Boyce-Codd Normal Form (BCNF)
BCNF was developed by Raymond Boyce and E.F. Codd; the latter is widely considered the father of relational database design.
BCNF is really an extension of 3rd Normal Form (3NF). For this reason it is frequently termed 3.5NF. 3NF states that all data in a table must depend only on that table’s primary key, and not on any other field in the table. At first glance it would seem that BCNF and 3NF are the same thing. However, in some rare cases it does happen that a 3NF table is not BCNF-compliant. This may happen in tables with two or more overlapping composite candidate keys.
BCNF is really an extension of 3rd Normal Form (3NF). For this reason it is frequently termed 3.5NF. 3NF states that all data in a table must depend only on that table’s primary key, and not on any other field in the table. At first glance it would seem that BCNF and 3NF are the same thing. However, in some rare cases it does happen that a 3NF table is not BCNF-compliant. This may happen in tables with two or more overlapping composite candidate keys.
-
Application Data Design - Course on mapping real-world business requirements to data structures.
Email Newsletter
Join thousands of others with our weekly newsletter
Please Wait...
Resources
![[WEBINAR] Index Insanity: How to Avoid Database Chaos](http://cdn.techopedia.com/images/uploads//qrcode.png?width=80&height=40)
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.
'@Techopedia'