Check our online training feedbacks Here

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 :)