DESPATCH_LIST Order no Order Cus_name Order Prod no Description Quantity Depot_ne Location date 6023 Deve EGONES amount S1.24 Shetin 28 Feb Electric heater N24 6023 28 Feb Deve EGONES S1.248 Desk lamp K10 Hunghom 02 Mar Nia FJENS Electric hester HO3 Aberoeen 04 Mar CHENG Chui SMI7 Sewing machine: N24 Shatin 04 Mer CHENG Chu SP3E Sewing pack 10 K10 Hunghom where, • (Order_no, Prod_no) is the Primary Key • Order_no determines Order_date, Cus_name, Order_amount • Prod_no determines Description Depot_no determines Location • (Order_no, Prod_no) determines Quantity, Depot_no Q3. Using the DESPATCH_LIST table above, identify one example each for insertion, deletion and modification anomalies.
DESPATCH_LIST Order no Order Cus_name Order Prod no Description Quantity Depot_ne Location date 6023 Deve EGONES amount S1.24 Shetin 28 Feb Electric heater N24 6023 28 Feb Deve EGONES S1.248 Desk lamp K10 Hunghom 02 Mar Nia FJENS Electric hester HO3 Aberoeen 04 Mar CHENG Chui SMI7 Sewing machine: N24 Shatin 04 Mer CHENG Chu SP3E Sewing pack 10 K10 Hunghom where, • (Order_no, Prod_no) is the Primary Key • Order_no determines Order_date, Cus_name, Order_amount • Prod_no determines Description Depot_no determines Location • (Order_no, Prod_no) determines Quantity, Depot_no Q3. Using the DESPATCH_LIST table above, identify one example each for insertion, deletion and modification anomalies.
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
Related questions
Question
![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
Dave E GONES
$1,248
Desk lamp
6023
28 Feb
DL21
K10
Hunghom
6028
02 Mar
Nick FJENS
$1,290
EHO6
Electric hester
ноз
Aberdeen
04 Mar CHENG Chui
Sewing machine 1
6132
$999
SM17
N24
Shatin
CHENG Chui
Sewing pack
6132
04 Mar
$999
SP38
10
K10
Hunghom
where,
(Order_no, Prod_no) is the Primary Key
• Order_no determines Order_date, Cus_name, Order_amount
• Prod_no determines Description
Depot_no determines Location
• (Order_no, Prod_no) determines Quantity, Depot_no
Q3. Using the DESPATCH LIST table above, identify one example each for
insertion, deletion and modification anomalies.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fec71ba2b-bc1c-4493-a03c-0ade678c8c74%2F4eb8e773-c5b2-42be-84e8-92a4e63c6005%2Fte9grxdl_processed.png&w=3840&q=75)
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
Dave E GONES
$1,248
Desk lamp
6023
28 Feb
DL21
K10
Hunghom
6028
02 Mar
Nick FJENS
$1,290
EHO6
Electric hester
ноз
Aberdeen
04 Mar CHENG Chui
Sewing machine 1
6132
$999
SM17
N24
Shatin
CHENG Chui
Sewing pack
6132
04 Mar
$999
SP38
10
K10
Hunghom
where,
(Order_no, Prod_no) is the Primary Key
• Order_no determines Order_date, Cus_name, Order_amount
• Prod_no determines Description
Depot_no determines Location
• (Order_no, Prod_no) determines Quantity, Depot_no
Q3. Using the DESPATCH LIST table above, identify one example each for
insertion, deletion and modification anomalies.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)