Boyce-Codd Normal Form :


This was the topic which my Sir Harinarayana asked me to search and present a seminar in his next class. While searching i pointed out some of the points which i felt it simple and important.

So, A table is in third normal form (3NF) and all determinants are candidate keys.Boyce-Codd normal form (BCNF) can be thought of as a "new" third normal form. It was introduced to cover situations that the "old" third normal form did not address. Keep in mind the mean of a determinant (determines the value in another field) and candidate keys (qualify for designation as primary key). This normal form applies to situations where you have overlapping candidate keys.If a table has no non-key fields, it is automatically in BCNF.

Boyce-Codd normal form (BCNF) is a more rigorous version of the 3NF deal with relational tables that had
(a) multiple candidate keys,
(b) composite candidate keys, and
(c) candidate keys that overlapped .

BCNF is based on the concept of determinants. A determinant column is one on which some of the columns are fully functionally dependent. A relational table is in BCNF if and only if every determinant is a candidate key.

I hope this material will be useful to all of us.