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
Expert Solution
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
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage