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

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

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 3.13CP

See similar textbooks

Similar questions

CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the appropriate attribute name for each of the column. custID 123 124 125 126 reservelD 5001 5002 5003 5004 5005 5006 5007 RESERVATION Each reservation is for one taxi. Reservation table is composed of reservation identification number, start reservation date, end reservation date, reservation days requested by customers starting from reservation date until end of reservation date, customer number that make the reservation and taxi number assigned to the reservation. Give and fill-in the appropriate attribute name for each of the column. taxill custName Ahmad Bin Abdullah Fatimah Binti Adam LAI LA2 Ruqayya Binti Idris Sulaiman Bin Daud LA3 LA4 startDate 01/10/2019 05/10/2019 05/10/2019 15/10/2019 20/10/2019 27/10/2019 02/11/2019 taxiType endDate 03/10/2019 12/10/2019 08/10/2019 17/10/2019 25/10/2019 Sedan Sedan Van Van 30/10/2019 04/11/2019 cust Phoneno TAXI Taxi table is composed of taxi…
The following table stores details of tutors, students and dates of lectures. The Primary Key is (TutorID, StudentID). TutorID TutorName StudentID StudentName Lecture_date T01 Kong S1052 Salim 10-May-19 T01 Kong S1051 Vikram 5-Jul-19 T02 Smith S1052 Salim 10-May-19 Explain why the above table is not in 2nd Normal Form. Normalize the table to 3rd Normal Form.
Considering Vaccination Database, write queries to: Display the Subject CNIC, Name, Contact, Dose1 Center, and Dose2 Center as shown below: CNIC Name Contact Dose1 Center Dose2 Center 22401-6645321-1 Nasir 3409991112 Lachi Kohat 2 14301-6045321-5 Shahab 3409991112 kohat 3 Dara The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who were vaccinated ‘Sinovac’ in the first dose, while Pfizer in the second dose.How many Viles of each type have been consumed so far. How many subjects are vaccinated from expired viles. Suggest the name of Incharge for the best performance award based on the highest number of subjects vaccinated on a single day
Note: Use MYSQL Create a database named book-collection-db and table named: bookcollect. Your tableshould contain the following columns: Title, Author, Genre (Children’s, Romance,Thriller, Fantasy, etc.), Publisher, Copyright Date, ISBN Number, Category (Fiction/Nonfiction), Overview, Link Where to Buy, and Price. Create 30 rows containing list of bookwith varied genre.
Q5) What is the normalization of the following table, where the primary keys are underlined: Note: all the data in cells of the table are already atomic. OrderID Order Date 1006 1006 10/24/2010 1006 1007 10/24/2010 1007 10/24/2010 10/25/2010 10/25/2010 Customer Customer Customer ProductID Product ID Name Address Description 2 2 2 6 6 Value Furniture Value Furniture Value Furniture Plano, TX Plano, TX Plano, TX Furniture Boulder, Gallery CO Furniture Boulder, Gallery CO 7 5 4 11 Dining Table Writer's Desk Product Product Finish Standard Price 4-Dr Dresser Natural 800.00 Ash Cherry 325.00 Entertainment Natural 650.00 Center Maple 500.00 4 Entertainment Natural 650.00 Center Maple Ordered Quantity 2 2 1 4 3
Q1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than5000.Q2- List all employee except those with employee_id 101, 102, 103, 104 and 105Q3- Display the city attribute from locations table. Show the ones that contain “South” in the city.Sort the list in descending order.Q4- Display the first name, last name, salary, manager id and job id of all employees whose last fourcharacters of job id ends with “LERK”.Q5- Display the first name, last name and salary of all employees. Round the salary to the nearestunit of 1000 (ex. Salary=4500 New Salary=5000). Label the column as "New Salary".
Consider the following tables. Primary keys are identified after each table. Hotel(Hnum,HName,Location) PK = HNum Room(RNum,HNum,Type,View,Price) PK = RNUM , HNum Booking(id,HNum,GNum,RNum,DateFrom,DateTo) PK = id Guest(GNum,Fname,Lname,Gender,DOB,City) PK = GNum Write SQL queries AND Relational algebra expressions (using the relational algebra operators: ρ, σ, π, , υ, ∩, sum, avg, count) for each of the following queries a) List all information about the rooms that have a price below the average price of all single rooms b) For each Hotel, List the total number of rooms c) List the names of hotels that have no booking in them d) List the first name and last name of Parisian guests who book a double room in Paris PLEASE ANSWER THE QUESTION BY WRITING SQL QUERIES AND RELATIONAL ALGEBRA EXPRESSION. Thank you.
Table 2 stores details of doctors, patients and dates of appointments. The Primary Key is (doctorID, patientID). i. Explain why the above table is not in 2nd Normal Form. ii. Normalize the table to 3rd Normal Form.
Change to use the database frozenfood Alter table customerOrder add column total as data type decimal size 7,2, not null, default value of 0.0 Update table customerOrder, set column total equal to column quantity multiplied by subquery a. (select column price from table product where column productId in table customerOrder equals column id in table product) Update table customerOrder, set column orderStatelId equal to subquery a. (select column id from table orderstate where state equals “Payment received") Alter table customerPayment add column paymentDate as data type date, not null, default value of (CURRENT_DATE) (Note: the parenthesis MUST be included) Insert into table customerPayment, columns customerOrderId and total result set returned from query a. Select columns id and total from table customerOrder where column orderStateld is equal to subquery i. (select column id from table orderState where column state is equal to "Payment received") Write Test Case 1 as a SQL join query…
creat the following tables and insert your own values: emp(eno, ename, bdate, title, salary, dno) proj(pno,pname,budget,dno) dept(dno,dname,mgreno) working(eno,pno,resp,hours)
List unique first (first_name) and last names (last_name) of customers (CUSTOMER table) who rented a movie (RENTAL table) between '2011-06-01' and '2012-01-01’ (rental_date). Sort by last_name. The common key is CUSTOMER_ID.
write a MySQL procedure to retrieve and output the item number, description, storehouse number, and unit price of every item in the category stored in I_CATEGORY.