(Solved) : Consider Following Relation Shipping Shipname Shiptype Voyageid Cargo Port Date Hint Date Q30177277 . . .
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
Answer to Consider Following Relation Shipping Shipname Shiptype Voyageid Cargo Port Date Hint Date Q30177277 . . .
OR