boyce-code normal form bcnfa relationship is said


Boyce-Code Normal Form (BCNF)

A relationship is said to be in BCNF if it is already in 3NF and the left hand side of each dependency is a candidate key. A relation who is in 3NF is almost always in BCNF. These could be similar situation when a 3NF relation might not be in BCNF the following conditions are found true.

The candidate keys are composite.

There are more than one candidate keys in the relation.

There are some common attributes in the relation.

 

Request for Solution File

Ask an Expert for Answer!!
Database Management System: boyce-code normal form bcnfa relationship is said
Reference No:- TGS0327030

Expected delivery within 24 Hours