Name Q5: Depict full key functional dependencies, partial transitive functional
ID: 3729290 • Letter: N
Question
Name Q5: Depict full key functional dependencies, partial transitive functional dependencies (if any) in partial functional dependencies (if any),and the SHIPMENTS Table given below The SHIPMENTS Table for a car car part company captures the data about car shipments company SHIPMENTS TABLE ShipmentiD ShipmentDate TruckD TruckType ProductID ProductType Quantity 1-Jan 1-Jan 2-Jan 3-Jan 3-Jan T-111 Semi-Trailer A T-111 Semi-Trailer B T-222Van Truck C T-333 Semi-Trailer|D T-333 Semi-TrailerA 180 120 SparkPlug 10,000 6,000 200 T-222 Van Truck C Tre SparkPlug 25,000 5653-Jan 3-Jan 180 T-111 Semi-Trailer B 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. nt is recorded in a table in the column Quantity. .Each uustmer service employee and needs to be able to update data in tk 'Write the DCL (Data control languaExplanation / Answer
Here are the funtional dependencies....
Candidate Key:
Shipment ID, Product ID -> Shipment Date, Truck ID, Truck Type, Product Type, Quantity
Other partial dependencies:
Shipment ID -> Shipment Date, Truck ID, Truck Type
Truck ID -> Truck Type
Product ID -> Product Type
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.