Consider the following relation:
Shipping (ShipName, ShipType, VoyageID, Cargo, Port, Date)
Hint: Date is the date the ship arrives in the given Port
With the functional dependencies:
ShipName -> ShipType
VoyageID -> ShipName, Cargo
ShipName, Date -> VoyageID, Port
(a) Normalize to 2NF.
(b) Normalize to 3NF.
Expert Answer
An answer will be send to you shortly. . . . .