Đã hoàn thành

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

 

Kĩ năng: Oracle, Phát triển cơ sở dữ liệu, Lập trình cơ sở dữ liệu, MySQL, Nhập liệu

Xem nhiều hơn: 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

Về Bên Thuê:
( 12 nhận xét ) Kuala Lumpur, Malaysia

ID dự án: #22681974

Được trao cho:

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 Thêm

$45 USD trong 2 ngày
(2 Đánh Giá)
1.7

22 freelancer đang chào giá trung bình $31 cho công việc này

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 Thêm

$20 USD trong 7 ngày
(29 Nhận xét)
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 Thêm

$111 USD trong 3 ngày
(8 Nhận xét)
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 trong 7 ngày
(3 Nhận xét)
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 Thêm

$20 USD trong 7 ngày
(1 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
0.0
Paramjots089

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

$25 USD trong 8 ngày
(0 Nhận xét)
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 Thêm

$20 USD trong 7 ngày
(2 Nhận xét)
0.0
nitamarathe37

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

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
$25 USD trong 1 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
0.0
MdSami786

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

$25 USD trong 5 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
0.0
Singhanshusingh7

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

$10 USD trong 1 ngày
(0 Nhận xét)
0.0
HEMANTPRATAP1

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

$25 USD trong 1 ngày
(0 Nhận xét)
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 Thêm

$25 USD trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 Thêm

$25 USD trong 1 ngày
(0 Nhận xét)
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 trong 2 ngày
(0 Nhận xét)
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 Thêm

$20 USD trong 2 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
0.0