Normalize the following table into BCNF

EQUIPMENT (Manufacturer, Model, Acquisition Date, Buyer Name, Buyer Phone, Plant Location, City, State, ZIP)

where the Functional dependencies (FD) are:

Buyer Name → Buyer Phone, Plant Location, City, State, Zip;

Zip → City, State;

(Manufacturer, Model, Buyer Name) → Acq Date

Answer rating: 100% (QA)

The BoyceCodd Normal Form BCNF is a normal form used in database normalization It is a slightly stro... View the full answer