Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The SHIPMENTS tab le for a car part company shows data about shipments: SHIPMENTS TABLE Shipment Date Track ID Truck Type Product ID Product Type
The SHIPMENTS tab le for a car part company shows data about shipments: SHIPMENTS TABLE Shipment Date Track ID Truck Type Product ID Product Type Quantity Shipment ID 111 1.Jan Semi-Trailer A Tire 180 111 1.Jan T-111 Semi-Trailer B Battery 120 222 2.Jan T-222 Van Truck SpartaPlug 10,000 333 3-Jan T-333 Semi-Trade D Wipers 5,000 333 3-Jan T-333 Semi-Trailer A Tire 200 144 3-Jan T-222 Van Track c Spark Prag 25,000 555 3-Jan T-111 Semi-Trailer B Battery 180 1. Write the functional dependency determined by the primary key. 2. Depict that using a dependency diagram using arrows along the top. (Hand drawing is fine, as long as it's legible.) 3. There are two additional functional dependencies, one involving ShipmentID, and another involving ProductID. Write those "equations." 4. Depict those on the bottom of the dependency diagram. 5. Cross out the lines on the diagram which reflect augmented dependencies. 6. There is one more non-trivial dependency. Write its "equation". 7. Draw the final dependency diagram
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