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
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 langua
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
