Question: 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

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 Phone PIN Dtbooked Ordid Room/tbl Pax Price Address (Area Only) 10001 Saman Padukka 0112858143 123 2020/11/24 1001 11 2 8000 10002 Saman Nugegoda 0112345678 124 2020/11/23 999 1 1 6000 10001 Saman Padukka 0112858143 125 2020/11/11 899 12 2 8500 10003 Soma 0712008882 10001 Saman Kandy Padukka Padukka 0112858143 126 2020/09/11 700 11 2 8000 10004 Yohan 0713008883 127 2020/11/24 4-Ocean Villa 3 10000 5-Rose Villa 3 10000 Tablel.1 - Customer Bookings List and briefly explain occurrences of Insert. Update and Delete anomalies with respect to the above table of data
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
