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 andPIN is the Composite Key.Cusid Cusname10001 Saman10002 Saman10001 Saman10003 Soma10001 Saman10004 YohanAddress(Area Only)PadukkaNugegodaPadukkaKandyPadukkaPadukkaPhonePINDtbookedOrdid0112858143 1232020/11/24 100101123456781242020/11/23 9990112858143 125 2020/11/11 899071200888201128581430713008883 127 2020/11/24126 2020/09/11 700Room/tbl11112114-Ocean Villa5-Rose VillaPax Price212233Table1.1 Customer BookingsList and briefly explain occurrences of Insert. Update and Delete anomalies with respect to the above table of data80006000850080001000010000

Below I have provided a solution for the given 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 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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

I need the output of the queries create table Accounts (account_no number primary key, client_name varchar2(200),Gender varchar2(20),address Varchar2(200)); create table loans (branch_id number, bank_name varchar2(200),Loan number, loan_Status varchar2(200),account_no number references Accounts(account_no) ON DELETE CASCADE); 1. delete from accounts where account_no= 101; 2. select * from accounts a where exists (select 1 from loans l where l.account_no= a.account_no) 3. select * from accounts a where exists (select 1 from loans l where l.account_no= a.account_no and status = 'accepted') 4. create or replace view view1 as select client_name , address,l.bank_name,l.loan_Status from accounts a, loans l where a.account_no = l.account_no Step 2 5.create or replace view view2 as select client_name , address,l.bank_name,l.loan_Status from accounts a, loans l where a.account_no = l.account_no and address = 'Karachi' 6. create or replace view view3 as select client_name ,…
Convert SHIPMENT to third normal form if necessary. Show the resulting table(s) with the sample data presented in SHIPMENT.
Perform first normalization based on the table information given.
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
List all products with their highest unit price, i.e. not discounted.the database is
You will be using the Colonial Adventure Tours database. How many current reservations does Colonial Adventure Tours have and what is the total number of persons for all reservations?
i need the answer quickly
Correct Query from table given.
4. In the OrderItems table, display a count of the number of products, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BNBG01 BNBG02 BNBG03 BR03 4 rows returned in 0.00 seconds PROD_ID Download 3 3 3 4 NUM_PROD_ID
Use single-row subquery in a HAVING clause. List customer numbers of customers who paid total amount (sum of quantity * paideach) of their orders less than the average of total amount of orders that paid by all customers. Include the following columns in the result. a. Customer Numberb. Total AmountHint: The subquery returns the average total amount that paid by all customers. We need to join two tables in this subquery and use group function to find average of total amount based on the number of customers.
The Colonial Adventure Tours database will be used. How many bookings have a travel cost of more than $20 but less than $75?
Use schema OE and table CUSTOMERS. Write a query to list the customer name(s) and GPS (geo location) using ISO 6709, a Standard representation of geographic point location by coordinates, for customers from Madison (city name in the customer address). Sort the results by the customer's last name. Include your query and the result for the first customer only. Hint: Customer address uses Object-Oriented features in Oracle. Please refer to the following notes (from COMP 3610) Please give proper explanation and typed answer only.