Question 1 - Table 4.5 below shows a shipping manifest of a shipping company. Create a 3 NF logical schema of a database that should be able to produce this shipping manifest as a report. In Table 4.5 Captain ID is 002-15 and captain name is Henry Moore. A ship can be captained by different persons over its lifetime and a person can be a captain of different ships over his/her tenure. TABLE 4-5 Shipping Manifest Shipment ID: 00-0001 Shipment Date: 01/10/2012 Origin: Destination: Boston Expected Arrival: 01/14/2012 Brazil Ship Number: 39 Captain: 002-15 Henry Moore Item Number Description Weight Quantity TOTALWEIGHT 3223 BM Concrete 500 100 50,000 Form 3297 BM Steel 87 2,000 174,000 Beam Shipment Total: 224,000 Answer the following Draw a dependency diagram that shows all functional dependencies (full, partial, and transitive as applicable) for one combined table based on the sample data shown in Table 4.5. Please clearly mark full, partial, and transitive dependencies in your diagram. Give example of insertion anomalies that can result in using this relation. Convert this one relation into a set of 3NF relations and clearly show functional dependencies (show that they are full functional dependencies only) and referential integrity (PK-FK match).