Database project

Completed Posted 4 years ago Paid on delivery
Completed 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

 

Oracle Database Development Database Programming MySQL Data Entry

Project ID: #22681974

About the project

21 proposals Remote project Active 4 years ago

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
(9 Reviews)
3.8

21 freelancers are bidding on average $31 for this job

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
(5 Reviews)
4.1
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
(9 Reviews)
4.0
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
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
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
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
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
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
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
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
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
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
Singhanshusingh7

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

$10 USD in 1 day
(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
MdSami786

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

$25 USD in 5 days
(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
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