Consider the following relation:
Shipping (ShipName, ShipType, VoyageID,Cargo, Port, Date)
Hint: Date is the date the ship arrives inthe given Port
With the functionaldependencies:
ShipName -> ShipType
VoyageID -> ShipName,Cargo
ShipName, Date -> VoyageID,Port
(a) Identify the candidate keys.(5)
(b) Normalize to 2NF. (10)
(c) Normalize to 3NF. (10)
Expert Answer
An answer will be send to you shortly. . . . .