Create a hotel management system using Pl/SQl
$8-15 USD / hour
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.
Project ID: #30091337
About the project
11 freelancers are bidding on average $15/hour for this job
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 More
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 More
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.
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 More
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 More
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 More
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.
