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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!