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