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

(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


An answer will be send to you shortly. . . . .

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post