Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started