Question

Plz someone answer my database questions post

Exercise I (50 pts): This exercise deals with a database that stores information abhout Hotel Management System. Customer (C email, name, country) Payment (Invoice id. C email, payment method, date) Invoice (Invoice id, starus, invoice description) Has (Bill id, Invoice id) Bill (Invoice id, Bill id, amount, Bname, type, date, reservation id) Reservation (Hotel id., room id. C email, date, period, reservation id) Rooms(Hotel id, room id. price, category) lotel (Hotel id, H name, country) Own (room id. Ilotel id) AUL 1- Draw the ER Diagram for the proposed 1Hotel Management System Date 2- Create in SQL language a database with your name. Then, create Customer and Invoice tables with their proposed attributes. Be sure to include the correct names and types for all attributes, and any primary key or foreign key constraints. Name Course 3- Write SQL queries to retrieve the requested information from your database. Suppose that all tables described previously are included in you database. a List the name of the customers along with the rooms category they did reserve and the date of their reseryation, Each of the customers must have at least a reservation. b- List the total number of payed invoices for each Customer CList all the customers who belongs to the country Lebanon or that they have not any reservation yet. d- List all the reservation id which are not billed on date 2019-09-09 and which have an amount of 1000,00 and below. 4- Write the relation algebra equations for all the requested lists in the previous question (3-a,b.c.d). Exercise II (20 pts): SQL and relational algebra PS: cach wrong answer eliminates a correct answer We consider the following relation: Articles(ID, title, journal, issue, year, startpage, endpage. TR-D) Indicate for each of the following expressions whether it is a valid SQL statement or not. A valid statement, should be accepted by a standard SQL interpreter, whereas an invalid statement should result in an error message. Please circle the correct answer. Valid Invalid FROM Articles WHERE endpage-startpage>10; 1- SELECT Valid Invalid 2- SELECT FROM Articles WHERE endpage-startpage<0; Valid Invalid 3- SELECT SUM(title) FROM Articles; Valid Invalid 4- SELECT AVG(year) FROM Articles WHERE title LIKE 'C% : Valid Invalid 5- SELECT COUNT(*) FROM Articles GROUP BY year; Valid Invalid 6- SELECT year, COUNT(*) FROM Articles WHERE COUNT(*)>10 GROUP BY year; A-2/3 CSC222: Database Systems

Answer 1

Exercise II)

1) Invalid

2) Invalid

3) Valid

4) Valid

5) Valid

6) Invalid

NOTE: As per HOMEWORKLIB POLICY, I am allowed to answer only 4 questions (including sub-parts) on a single post. I have gone ahead and answered 6. Kindly post the remaining questions separately and I will try to answer them. Sorry for the inconvenience caused.