Completed

Database project

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

 

Skills: Oracle, Database Development, Database Programming, MySQL, Data Entry

See more: relational database project, database project hotel booking, database project hotel booking system, project hotel reception database, project hotel database, pdf hotel management database project report, database project description relational, sample database project using, hotel managerment database project, ideas relational database project, ready project hotel managing using php, database project using microsoft access 2007, front page database project using, student database project using, mysql database project using jms java code, free database project aspnet using msaccess, database project hotel reservation

About the Employer:
( 12 reviews ) Kuala Lumpur, Malaysia

Project ID: #22681974

Awarded to:

JDeveloper91

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

$45 USD in 2 days
(2 Reviews)
1.7

22 freelancers are bidding on average $31 for this job

CreativeExpertIT

Hi, how are you ? We are experienced developers & designers for mobile apps and website development, we will provide high quality work on time and 100% result assurance. PHP , Wordprss , CI , Cake PHP , Laravel ,Nati More

$20 USD in 7 days
(29 Reviews)
4.7
huseyinaygun

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

$111 USD in 3 days
(8 Reviews)
4.0
LidijaP

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.

$20 USD in 7 days
(3 Reviews)
3.9
inspironweb

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

$20 USD in 7 days
(1 Review)
2.8
Achrist1998

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

$100 USD in 7 days
(0 Reviews)
0.0
Paramjots089

hey, i read your database project about hotel rooms.i will complete it without any errors.....................

$25 USD in 8 days
(0 Reviews)
0.0
PageOllice

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

$20 USD in 7 days
(2 Reviews)
0.0
nitamarathe37

I am here to fulfill your work requirements. I can complete every task in time.

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
vinaynadide

Having overall 10+ years of IT exp. worked 7 years as oracle plsql developer having good knowledge in analytical functions

$20 USD in 7 days
(0 Reviews)
0.0
MdSami786

i can do your work Relevant Skills and Experience i am data typing expert

$25 USD in 5 days
(0 Reviews)
0.0
jyotiangel30marc

hi i read all requirement please share more detail i did 5 similar task i will provide 5 star rating work thanks

$40 USD in 7 days
(0 Reviews)
0.0
Singhanshusingh7

Data entry Relevant Skills and Experience Front Office Executive my work and customer belling

$10 USD in 1 day
(0 Reviews)
0.0
HEMANTPRATAP1

I am a new user Relevant Skills and Experience It is the super and best project

$25 USD in 1 day
(0 Reviews)
0.0
nehachamling99

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

$25 USD in 1 day
(0 Reviews)
0.0
motasl

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.

$20 USD in 1 day
(0 Reviews)
0.0
waghshubham44

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

$25 USD in 1 day
(0 Reviews)
0.0
vikashsaini002

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

$20 USD in 2 days
(0 Reviews)
0.0
sumitbirla853

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

$20 USD in 2 days
(0 Reviews)
0.0
kshitijtakalikar

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

$25 USD in 1 day
(0 Reviews)
0.0