Gien the following schema ROOM mNo mPrice mBeds mCapecity mFacilities mElec 80 95 100 10 WC Shower Bathtub 20 2. 25 3 TV CUSTOMER cusNo cusName 1000 Ahmed Aamer 1001 Sami Mohamed RESERVATION cusAddress cusNo rmNo dateln Salelah dateOut 1000 20 09/02/2020 15/02/2020 20/04/2021 12/12/2020 18/12/2020 Ibri 1001| 25 1004 Faisal Fares Suhar 1004 10 1. Write SQL commands to create the above tables. Include necessary constraints. 2. Write relational algebra expression to display names of customers who reserved a rooms with capacity less than 3 peop 3. Write SQL command to find the name of the customers who stayed in rooms that do not have a Bathtub. 4. Write SQL command to display the names of customers who did not fix the date of departure from the hotel. 5. Write SQL command to modify the attribute mPrice in the table ROOM to real number with 3 decimal places.

Gien the following schema ROOM mNo mPrice mBeds mCapecity mFacilities mElec 80 95 100 10 WC Shower Bathtub 20 2. 25 3 TV CUSTOMER cusNo cusName 1000 Ahmed Aamer 1001 Sami Mohamed RESERVATION cusAddress cusNo rmNo dateln Salelah dateOut 1000 20 09/02/2020 15/02/2020 20/04/2021 12/12/2020 18/12/2020 Ibri 1001| 25 1004 Faisal Fares Suhar 1004 10 1. Write SQL commands to create the above tables. Include necessary constraints. 2. Write relational algebra expression to display names of customers who reserved a rooms with capacity less than 3 peop 3. Write SQL command to find the name of the customers who stayed in rooms that do not have a Bathtub. 4. Write SQL command to display the names of customers who did not fix the date of departure from the hotel. 5. Write SQL command to modify the attribute mPrice in the table ROOM to real number with 3 decimal places.

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

Question 10 Save Answer Adventure Works Cycle Data Warehouse: The Adventure Works Cycle Data Warehouse is available for your use in the course database server (follow the steps in Tutorial 2 to access the data warehouse (named "aw") and review the course Handout 8, slides 13-18 for the description). You are required to complete the following MYSQL statement to perform this task: For each of the product category, display (in this order) the category name (in English), the total number of unique products belonging to the category, the total number of sales orders of the category, and the total sales amount in the category. (enter only one alphanumeric string in each blank below; do not enter space or other unnecessary symbols; assume that all strings are non-case sensitive. Hint: The sum of all the total sales should be equal to the sum of all the total sales in Question 8). SELECT c. AS 'Product Category', р. ) AS Num_Products, (f. ) AS Num_Orders, (f. ) AS Total_Sales FROM C, P. S, f…
Discuss the importance of queuing by defining the different types of commands enqueued
Direct diffusion protocol express data as : interests task O gradients O relay O attribute-value pairs
Make 5 intelligent questions about each chart along with the answers (10 in total)
Mahmood AlI Ghasani University of Technology and Applied Sciences Ibri oard / Courses / AY_2020_2021 / Semester 2 / Information Technology / 54_ITDB101_DB_S2/ Final Examination nal Examination 13 April 2021 8:30 to 10:45 AM Course search There is a Hostel Booking Software in one of the hostels in Ibri. There you can book a suitable hostel room for yourself if you log in as a student. What type of user are you in this scenario? estion 3 st yet Swered larked out of O a. Application Programmer 00 Flag question Ob. Database Designer Oc. Database Administrator d. End User Previous page Next page TATMOLie ENG d
Cse number 6,can you please help me on my assignment sir.
SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 800 100 SalesRepNo 345 434 654 345
i need ans within 15 minutes my best wishes ton
QUESTION 16 Consider the following two tables: Table1: Products productID productName unitPrice entryDate expiryDate P1 Dell Laptop 350 16-10-2016 30-10-2016 P2 Apple mobile 420 17-02-2018 02-03-2018 P3 Samsung Mobile 330 20-08-2020 30-08-2020 P4 HP Printer 80 21-09-2019 05-10-2019 P5 Canon Printer 150 15-05-2020 20-06-2020 Table2: Orders orderID Quantity Price productID 1 10 3300 P3 2 5 1800 P1 3 20 1600 P4 4 20 3000 P5 5 9 1100 P7 6 8 2250 P10 Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it). 1. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p INNER JOIN Orders AS o ON p. productID = o. productID; 2. SELECT p. productName, p.…
ed1 x emp x A 7 Filter EMPNO ENAME DNAME JOB HIREDATE LOC SALARY 8876 adams research clerk 2017-07-23 Johor 5000 8499 allen sales salesman 2018-01-23 KL 3400 8698 blake sales manager 2016-03-11 KL 10000 8782 ali accounting manager 2015-06-25 Penang 11000 8902 ford research analyst 2016-02-03 Johor 8700 8900 james sales clerk 2017-12-13 KL 3500 8566 jones research manager 2015-04-02 Johor 9000 8839 king accounting president 2019-11-17 Penang NA 8654 martin sales salesman 2012-06-17 KL 3250 8934 miller accounting clerk 2012-01-23 Penang 3000 8788 scott research analyst 2017-04-19 Johor 7500 8369 smith research clerk 2016-12-17 Johor 5600 8844 turner sales salesman 2018-09-08 KL 3000 8521 andrew sales salesman 2018-02-22 KL 3200 Which of the following can be used to return the maximum salary (SALARY) for each location (LOC) Select one: O emp %>% group_by(LOC) %>% summarise(max_sal=max(emp$SALARY, na.m = T)) O emp %>% fiter(LOC="Penang') %>% group_by(LOC) %>% summarise(max_sal=max(SALARY,…
Cloud computing, as we've seen, is a blanket term that now encompasses many different products and services. For example, at Amazon Web Services or Azure Development Tools offerings to see just how much is available. What jobs that involve cloud computing either on the provider end or as an IS professional making use of such services. Explain on one such job. What kind of skills are necessary? What kinds of organizations are hiring and how does the pay scale measure up to your expectations?
Knowing the function of the AMM PROC CMP AX,97 JL DONE following CMP AX,122 JG DONE SUB AX,32 program, written in the language of Asambly DONE: RET AMM ENDP