Question: Consider the following relation with sample data. The SHIPMENTS Table for a car part company captures the data about car part shipments. Each shipment has
Consider the following relation with sample data.
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.
a Depict full key functional dependencies, partial functional dependencies if any and transitive functional dependencies if any in the Shipments Table. points
b Show the result of normalizing the Shipments Table to NF points
c Show the result of normalizing the Shipments Table to NF points
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
