Can anybody explain to me what is Boyce-Codd normal form (or BCNF) ? What is it's importance in database design and how a table can be in BCNF form
Boyce-Codd normal form (or BCNF) is a slightly stronger version of the third normal form (3NF). A table is in Boyce-Codd normal form if and only if, for every one of its dependencies X → Y, X is a superkey