DEPICT FULL KEY $,$ TRANSITIVE AND PARTIAL AND SHOW HOW IT WILL BE IN $1$NF $2$ NF AND $3$NF SOLVE THIS CORRECTLY AND STEP BY STEP Consider the following relation with sample data. SHIPMENTS TABLE

ShipmentID ShipmentDate

$1111-$Jan

$1111-$Jan

$2222-$Jan

$3333-$Jan

$3333-$Jan

$4443-$Jan

$5553-$Jan

TruckID TruckType

T$-111$ Semi$-$Trailer

T$-111$ Semi$-$Trailer

T$-222$ Van Truck

T$-333$ Semi$-$Trailer

T$-333$ Semi$-$Trailer

T$-222$ Van Truck

T$-111$ Semi$-$Trailer

ProductID ProductType Quantity

A Tire $180$

B Battery $120$

C SparkPlug $10,000$

D Wipers $5,000$

A Tire $200$

C SparkPlug $25,000$

B Battery $180$

$$ The SHIPMENTS Table for a car part company captures the data about car part 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.

E$4\mathrm{.}7$a Depict full key functional dependencies, partial functional dependencies $($if any$),$ and transitive functional dependencies $($if any$),$ in the Shipments Table.

E$4\mathrm{.}7$b Show the result of normalizing the Shipments Table to $2$NF$.$

E$4\mathrm{.}7$c Show the result of normalizing the Shipments Table to $3$NF$.$SHIPMENTS TABLE

The SHIPMENTS Table for a car part company captures the data about car part 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 auantity of a product shipped in a shipment is recorded in a table in the column Ouantity.