In this assignment, please examine the data table below and transform it into 3NF. Please complete this assignment in attached Answer Sheet. Imagine the following scenario: The SHIPMENTS table for a car part company captures the data about car shipments Each shipment has a unique Shipment ID and a Shipment Date Each shipment is shipped on one truck Each truck has a unique Truck ID, and a Truck Type Each shipment can ship multiple products Each product has a unique Product ID and a Product Type Each quantity of a product shipped in a shipment is recorded in a table in the column Quantity SHIPMENTS TABLE ShipmentID ShipmentDate TruckID TruckType ProductID ProductType Quantity 111 1-Jan T-111 Semi-Trailer A Tire 180 111 1-Jan T-111 Semi-Trailer B Battery 120 222 2-Jan T-222 Van Truck C SparkPlug 10,000 333 3-Jan T-333 Semi-Trailer D Wipers 5,000 333 3-Jan T-333 Semi-Trailer A Tire 200 444 3-Jan T-222 Van Truck C SparkPlug 25,000 555 3-Jan T-111 Semi-Trailer B Battery 180 a) Does the table above meet the definition of 1NF? What is the primary key? b) Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the SHIPMENTS table c) Normalize the SHIPMENTS Table to 2NF and show the resulting tables (with functional dependencies) d) Normalize the SHIPMENTS Table to 3NF and show the resulting tables (with functional dependencies) e) Draw a relational schema for the resulting tables, after the tables are in 3NF *Note: For questions b-d, you can use WORD to draw the tables with functional dependencies For question e, please use ERD Plus to draw a relational schema, and export and copy the image into your answer sheet.