Boyce–Codd normal form

GPTKB entity

Statements (21)
Predicate Object
gptkbp:instanceOf Database normal form
gptkbp:abbreviation BCNF
gptkbp:appliesTo Relational schema
gptkbp:category Database theory
gptkbp:defines A normal form used in database normalization to eliminate redundancy and anomalies.
https://www.w3.org/2000/01/rdf-schema#label Boyce–Codd normal form
gptkbp:introducedIn 1974
gptkbp:isWeakerThan gptkb:Third_normal_form
gptkbp:namedAfter gptkb:Edgar_F._Codd
gptkb:Raymond_F._Boyce
gptkbp:prevention Deletion anomalies
Insertion anomalies
Update anomalies
gptkbp:relatedTo gptkb:Third_normal_form
Database normalization
Functional dependency
Superkey
gptkbp:requires For every non-trivial functional dependency X → Y, X is a superkey.
gptkbp:usedIn Relational database design
gptkbp:bfsParent gptkb:Raymond_F._Boyce
gptkbp:bfsLayer 5