Hotel chains based on different locations specification ^^* see the attached document
Here are the questions need to be applied:
1- Write the ERM of the above description.
Note: We will give you the solution of the first part in order to properly work part 2 and 3
2. Write the relational model from the previous ERM
3. Write the SQL DDL code for the creation of different tables (use ORACLE 11g express edition).
4. Fill the tables with different data to different fields assuming in theory that the hotel branches are already inaugurated and begun the commercial operation from the start of year 2019.
5. Write the following queries using RELATIONAL ALGEBRA:
5.1. List the rooms of each hotel?
5.2. Find all rooms that are currently available?
5.3. List of rooms in Al Ula hotel?
5.4. List allguests details in the Riyadh hotel during January 2019?
5.5. List all booking made during February 2019?
5.6. List all room currently under maintenance in Al Ula hotel?
5.7. For each hotel, find all the guest who have bookedstudio rooms?
5.8. For each hotel, list the most preferred rooms along with their types and sizes?
6. Translate the questions below (from 5.1-5.8) into SQL DML queries
22 freelancers are bidding on average $31 for this job
Hi, I'm Ibrahim from Sweden, With 9 years of experience, I can finish this task as soon as possible with Guarantee you high-Quality work, I'm primarily interested in satisfying my customers.