Ditutup

Create a hotel management system using Pl/SQl

I need help with making a database and building a code with it.

Deliverables

Add a new hotel: Create a new hotel with appropriate information about the hotel as input parameters.

2. Find a hotel: Provide as input the address of the hotel and return its hotel ID

3. Delete a hotel by ID

4. Display hotel info: Given a hotel ID, display all information about that hotel (Includes room, rates and availability)

• Task 2:

5. Make a reservation: Input parameters: Hotel ID, guest’s name, start date, end date, room type, date of reservation, etc. Output: reservation ID (this is called confirmation code in real-life). NOTE: Only one guest per reservation. However, the same guest can make multiple reservations.

6. Find a reservation: Input is guest’s name and date, hotel ID. Output is reservation ID

7. Cancel a reservation: Input the reservationID and mark the reservation as cancelled (do NOT delete it)

• Task 3:

8. Change a reservationRoomType: Input the reservation ID and change reservation room type if there is availability for that room type during the reservation’s date interval

• Task 4:

9. Display a bill: Input parameters: reservation ID. Print on the console a bill for the guest. Include guest name, hotel Name and ID, start date, end date, room type, date of reservation, room number, charge per day, rate per day and total amount.

10. Income By State Report:

a. Input is state. Print total income from all sources of all hotels by room type.

b. Input is hotel ID. Print total income of hotel by room type.

• GUI: There is no Graphical User Interface (GUI) for this project. You need to create PL/SQL procedures and functions that carry out the tasks identified above. Each task will be a separate PL/SQL stored procedure or function.

• Input/output: For tasks that require input parameters, you need to call the corresponding PL/SQL procedure or function and pass to it the input parameters. This means that you need to have another program that calls your procedures and functions.

• How to speed up your work: First start by writing and completing the simple tasks. Make sure that you are DEBUGGING your code:

First thing to do in each procedure/function is to print out the values of the input parameters. This way you know that they were passed correctly, before you start working on the main part of the procedure/function.

Occasionally within the procedure/function print out the values of variables, just to make sure your procedure is progressing correctly.

Always use EXCEPTIONs to explain what went wrong. This will definitely speed up the implementation time. In addition, EXCEPTIONS ARE REQUIRED for every single procedure and function. There will be points taken off for missing exceptions.

Kemahiran: SQL, Oracle

Lihat lagi: tomake project royal hotel management using gui language, hotel management system using sql server 2000, project computerization hotel management sql server 2000, school management using sql 2005 aspnet, hotel management system sample project sql, inventory management system using php sql, hotel management system using visual basic, sql design help tournament database, hotel management using excel template, hotel management using excel, hotel management using, create website php using dreamweaver sql, hotel management using php mysql, how to create a package in pl sql with example, I need someone to create the PL/SQL scripts that, hotel management system using sql, how to insert data into table by using pl/sql procedure, how to export data from oracle table to csv file using pl/sql, import data from excel to oracle table using pl/sql developer

Tentang Majikan:
( 11 ulasan ) Bucharest, Romania

ID Projek: #30091337

15 pekerja bebas membida secara purata $15/jam untuk pekerjaan ini

SqlDevelopment

I can qualitatively assist with required Oracle project because I am exceptionally well qualified SQL developer with 10+ years' seniority and with long term professional experience in implementation of complex database Lagi

$25 USD / jam
(44 Ulasan)
5.1
Truonggiang86

Hello there, i've done similar job for hotel management like this before. The entities include: Hotel, Booking, Room connected, room type has allow smoking or pet, a bill after they leave. Finally write some PLSQL stor Lagi

$15 USD / jam
(11 Ulasan)
4.2
huseyinaygun

Hi, I have relational database (Oracle) design and development experience of 10 years. My area of expertise are: - Conceptual design (ERD) - Creation of database schema (creating tables, constraints) - Writing simpl Lagi

$15 USD / jam
(7 Ulasan)
3.4
bohdansmoliar

Hi. I am a Senior Web Developer who has rich experience for 4+ years. As I have a rich and deep experience at mysql, php, you can get perfect result. You can check at my profile and portfolio. As per your requirements, Lagi

$12 USD / jam
(3 Ulasan)
2.4
anuarcastillo

Hi! A couple of days ago I was working on a very similar academic project and my client obtained an excellent result with the work I submitted. I would be willing to start immediately on your project. I have extensive Lagi

$15 USD / jam
(2 Ulasan)
2.4
artistixeit

Hi, Greets of the Day!! I have gone through the posted project and I understood that you are looking for the development of a Hotel Management CRM application for your Hotel. I work very hard to build the best solut Lagi

$12 USD / jam
(1 Ulasan)
2.0
bizmanas

Hi I have 15 years of experience in SQL server Database development, MySQL development, postgress SQL,c#, Python, power bi. I will be able to help you with the project. Please ping me offline to discuss further.

$22 USD / jam
(3 Ulasan)
1.2
indrajitpaul

Hello, There are 10 granular functionalities. I will charge 25USD per functionality. So in total 250USD. If I have to design the schema and provide you DDL scripts for tables, that would be 50USD more. I will use PL/SQ Lagi

$26 USD / jam
(1 Ulasan)
0.6
ArtemFillipov

Hi. I am the right developer you are looking for. I am an expert in oracle and much experience in various kinds of management systems. I am interested to hear more about your project. Thank you.

$15 USD / jam
(0 Ulasan)
0.0
franciscoarizti

I have developed severa applications data base driven in sql server, with front end in ASP. I can develop your app in 14 days

$14 USD / jam
(0 Ulasan)
0.0
karacicomer

Hi, I'm full-stack software engineer with strong knowledge in developing websites, web apps and RESTful services. I also have experience in developing hotel management system (check [login to view URL] - search for Sarajevo Lagi

$10 USD / jam
(0 Ulasan)
0.0
vw7585806vw

Hi, Thanks for reading my bid I read the project description and its matching my skill I am senior software engineer with hands on experience in dot net development (Web and Win forms ) with MSSQL/PLsql . I am having Lagi

$12 USD / jam
(0 Ulasan)
0.0
nekumars

Hey There, I have over 10 years of professional experience in handling similar project requirements. Also I can fast track the execution. Let me know if you would want to discuss further and let the work progress. Re Lagi

$9 USD / jam
(0 Ulasan)
0.0
asimfayyaz1

I wiLl work with and create procedures and functions for you hotel management system. i have good experience in pl sql. i hope you will award me this project.

$12 USD / jam
(0 Ulasan)
0.0
ambersaeedsl

Hi. I have been working with database designs, database programming using SQL, MYSQL and PLSQL for small to large scale organizations for the last 13 years. It would be my pleasure to work for you on your requirement.I Lagi

$12 USD / jam
(0 Ulasan)
0.0