15 December 2010

Boyce-Codd normal form

It is slightly higher version Of 3 NF.
A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a candidate key.

Example:-
Conisder table TblEmployee with columns(employee_id, first_name, last_name).
In this table, the field employee_id determines first_name and last_name. Similarly, the tuple (first_name, last_name) determines employee_id.

No comments:

Post a Comment

Your comments, Feedbacks and Suggestions are very much valuable to me :)

Things are upgraded

My Dear readers, I am really thankful for being supportive all these years. This site was the first blog site I ever created in my life...