Q4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all dependencies including functional, partial and transitive dependencies.

Extracted text: Q4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all dependencies including functional, partial and transitive dependencies.


Extracted text: DESPATCH_LIST Order no Order Cus_name Order Prod no Description Quantity Depot_no Location date amount 6023 28 Feb Dave E GONES $1,248 EHO6 Electric heater 3 N24 Shatin 28 Feb Dave E GONES $1,248 Desk lamp 6023 DL21 K10 Hunghom 6028 02 Mar Nick FJENS $1,290 EHO6 Electric heater ноз Aberdeen 04 Mar CHENG Chui Sewing machine 1 6152 $999 SM17 N24 Shatin E132 CHENG Chui $999 Sewing pack 04 Mar SP38 10 K10 Hunghom where, (Order_no, Prod_no) is the Primary Key • Order_no determines Order_date, Cus_name, Order_amount • Prod_no detemines Description Depot_no determines Location (Order_no, Prod_no) determines Quantity, Depot_no