(Solved) : Given Following Shipping Manifest Ship Number 12 Origin New York Ship S Trip 564 Destinati Q27624633 . . . .

You are given the following shipping manifest:

Ship Number12OriginNew YorkShip’s Trip #564DestinationColumbiaShip TypeCARGO-2Trip Rate$175.65Captain #008-12Shipment Rate40667Captain Name:Julio VasquezExpected Arrival06/15/11Item NumberCategoryItem NameQuantityWeightTotalWeight1257CNMasonry Blocks600200.00120,000.001689CNSteel Rods943,000.00282,000.002249GDSteel Bolts1806.001,080.005528GD, CNReady-set Formwork300250.0075,000.00TOTAL478,080.00

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 assumptionsyou make while doing this question.

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

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

c) Using the results obtained so far,