Database Reference
In-Depth Information
The two candidate keys in this example are (SupplierID, ProductID) and ( SupplierName,
ProductID) , and the functional dependency is illustrated in following figure.
So there is a functional dependency {SupplierID} { SupplierName}, which is in viola-
tion of BCNF . A write model of BCNF is shown in following figures.
