Database project
$10-30 USD
Paid on delivery
Hotel chains based on different locations specification ^^* see the attached document
Here are the questions need to be applied:
Part1
1- Write the ERM of the above description.
Part2
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.
Part3 Part2
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
Project ID: #22681974
About the project
Awarded to:
Hello. I am a Oracle Certified Database Developer on the below versions: 7g, 8i, 11g, 10g and 12c. In a plus, i am the oracle weblogic expert in my organization and provide administration solutions and architectura More
21 freelancers are bidding on average $31 for this job
My name is Lydia, I have been working on the computer for the last 15 years. My Top Skills are Excel, Microsoft Office and Internet Research.
Dear Sir/Madam, I have relational database design and development experience of 10 years. Recently I completed 5 Database Systems Course projects which cover: - Conceptual design (ER Diagram) - Creation of database More
Hello There, "Thank you for taking the time to read this Proposal" I have over 10 + year experience with front-end and back-end web development, I take great pride in my skills, I like to keep things clean and organiz More
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.
Greetings, My name is Page and I have been working from last 8 years in IT field. I am very much interested in your project and would like to invite you for further discussion over chat board. Waiting for your positi More
You do not worry about your work, I promise you your work will be done on time and you will not get any chance of complaint. Thank you
I am good in English typing as well as speaking Relevant Skills and Experience I have a 3 month extension and my typing speed is near about 30 wps
hello sir..... this is sumit birla.. i wanna tell u that I am well experienced in data entry work. I am lucky person that I will work with you . I promise you that I will complete your work as soon as possible. wait More
I have experience 2 years in data entry and I'm Indian I'm heavy fast worker fast typer Relevant Skills and Experience Data entry in excel, office
Hii I'm Shubham wagh.i am fresher graduate. Having good educational background. Also having good command over English, internet. i will give my best to complete my project within time with quality. Relevant Skills and More
I would like to work on this Relevant Skills and Experience Detail-orient data entry clerk with six years of experience using Excel and Microsoft Word. Proven ability to pivot between assignments while maintaining ac More
Data entry Relevant Skills and Experience Front Office Executive my work and customer belling
hey, i read your database project about hotel rooms.i will complete it without any errors.....................
Having overall 10+ years of IT exp. worked 7 years as oracle plsql developer having good knowledge in analytical functions