AI engineering glossary · SQL databases
What is BCNF?
BCNF (also called Boyce-Codd normal form): Boyce-Codd normal form: a stricter version of the third form requiring that, for every dependency in the table, the determining columns are a candidate key. It resolves rare anomalies involving overlapping candidate keys.
BCNF: an example
If teacher determines subject but teacher is not a candidate key of the table, the table violates it and should be split.
Related terms
More SQL databases terms
Where you learn it
BCNF is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.