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

(Solved) : 8 Two Nodes Began Transmit Simultaneously Packet Length N Broadcast Channel Rate R Propaga Q33249077 . . . .(Solved) : 8 Two Nodes Began Transmit Simultaneously Packet Length N Broadcast Channel Rate R Propaga Q33249077 . . . .

<br/><img src="../../../media.cheggcdn.com/media/01e/01e1c858-d3db-4244-b776-9b1f4ccd0e24/image.png" alt="8. If two nodes began to transmit simultaneously a packet of length N over a broadcast channel of rate R where the propagation delay between the two stations