[Lizapotter]

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

[shabbir]

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