IV) Consider below table with Customer ID, Customer Name, Address, Phone Number, PIN (for booking) Number, Date Booked, Order ID, Room/ Table ID, Pax (Number of persons) and the Price data, respectively. Customer ID and PIN is the Composite Key. Cusid Cusname 10001 Saman 10002 Saman 10001 Saman 10003 Soma 10001 Saman 10004 Yohan Address (Area Only) Padukka Nugegoda Padukka Kandy Padukka Padukka Phone PIN Dtbooked 0112858143 123 0112345678 124 0112858143 125 2020/11/11 0712008882 0112858143 126 0713008883 Ordid Room/tbl 2020/11/24 1001 2020/11/23 999 899 2020/09/11 127 2020/11/24 - 700 11 1 12 - 11 4-Ocean Villa 5-Rose Villa Pax Price 2 1 2 2 3 3 Table1.1-Customer Bookings List and briefly explain occurrences of Insert, Update and Delete anomalies with respect to the above table of data 8000 6000 8500 8000 10000 10000
IV) Consider below table with Customer ID, Customer Name, Address, Phone Number, PIN (for booking) Number, Date Booked, Order ID, Room/ Table ID, Pax (Number of persons) and the Price data, respectively. Customer ID and PIN is the Composite Key. Cusid Cusname 10001 Saman 10002 Saman 10001 Saman 10003 Soma 10001 Saman 10004 Yohan Address (Area Only) Padukka Nugegoda Padukka Kandy Padukka Padukka Phone PIN Dtbooked 0112858143 123 0112345678 124 0112858143 125 2020/11/11 0712008882 0112858143 126 0713008883 Ordid Room/tbl 2020/11/24 1001 2020/11/23 999 899 2020/09/11 127 2020/11/24 - 700 11 1 12 - 11 4-Ocean Villa 5-Rose Villa Pax Price 2 1 2 2 3 3 Table1.1-Customer Bookings List and briefly explain occurrences of Insert, Update and Delete anomalies with respect to the above table of data 8000 6000 8500 8000 10000 10000
Chapter3: Performing Calculations With Formulas And Functions
Section: Chapter Questions
Problem 3.13CP
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