EssayproSolutions

(Solved) : Consider Following Relation Shipping Shipname Shiptype Voyageid Cargo Port Date Hint Date Q30177173 . . .

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

Answer to Consider Following Relation Shipping Shipname Shiptype Voyageid Cargo Port Date Hint Date Q30177173 . . .