Boyce-Codd normal form

Lizapotter's Avatar, Join Date: Feb 2009
Go4Expert Member
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
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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