CS: Normalization

In this assignment, please examine the data table below and transform it into $3$NF$.$ Please complete this

assignment in attached Answer Sheet with your full name, course section, and class time.

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

a$)$ Does the table above meet the definition of $1$NF$?$ 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 $2$NF and show the resulting tables. Please depict the primary

keys and functional dependencies in the $2$NF tables.

d$)$ Normalize the SHIPMENTS Table to $3$ NF and show the resulting tables. Please depict the primary

keys and functional dependencies in the $3$NF tables.

Notes:

You can use either graphical expression notation or written expression notation to depict

functional dependencies.

You may use WORD to draw the $2$NF and $3$NF tables. No need to fill in the normalized tables

with data.