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

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Q4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all
dependencies including functional, partial and transitive dependencies.
Transcribed Image Text:Q4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all dependencies including functional, partial and transitive dependencies.
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
Transcribed Image 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
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Normalization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education