You are given the following shipping manifest:

Note: The trip rate, which is the cost per nautical mile, depends on where the ship is leaving from, where it is heading to, and the time of the year. Please specify any additional assumptions you make while doing this question.

a) Given this structure, draw its dependency diagram. Label all transitive and/or partial dependencies.

b) Break up the dependency diagram you drew in a) to produce dependency diagrams that are in 2NF and then in 3NF

c) Using the results obtained so far, draw an E-R diagram.

d) Using the results from (c) present the relational schemas.

Ship Number Ship's Trip # Ship Type Captain # Captain Name: 456 CARGO-2 002-16 Juan Rodriguez Origin Destination Trip Rate Shipment Date Expected Arrival Boston Brazil $159.85 01/10/07 02/15/07 Quantity Weight Item Name Concrete Form Steel Beam Steel Nails Ready-set Formwork Item Number Category TotalWeight 500 100.00 50,000.00 87 2,000.00 174,000.00 3233 BM 3297 BM 3256 FC 4265 FC, BM 124 5.00 620.00 150.00 37,500.00 262,120.00 250 TOTAL