Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

5. Interpret the results of your test.

Answered: 1 week ago

Question

8-2 What is the business value of security and control?

Answered: 1 week ago