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
|