a) Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any), in the Shipments Table.

b) Show the result of normalizing the Shipments Table to 2NF.

c) Show the result of normalizing the Shipments Table to 3NF.

d) Using the SHIPMENTS TABLE, describe an example for each of insertion anomaly, deletion anomaly, and modification anomaly

e) Populate the relations you created for Part C based on the data given on SHIPMENTS TABLE

f) Using the populated data in Part E, describe how the 3 anomalies are eliminated

SHIPMENTS TABLE