3NF: A Problem with BCNF
Unit
Company
Product
Unit
Company
Unit
Product
FD’s:
Unit
®
Company
;
Company, Product
®
Unit
So, there is a BCNF violation, and we decompose.
Unit
®
Company
No
FDs