This assignment is to develop a hotel room reservation system. We have 3 types of room(each with different pricing per day). Pricing per day will be appicable as per standard check-in/check-out time(which is 12pm) .
Below are the room types and per day prices
1. Single - INR 1500
2. Double - INR 2200
3. Luxury - INR 3500
There are 100 rooms in hotel which are distributed as 50 single, 25 double and 25 luxury rooms.
You need to perform the following tasks:
1. Design a database for the reservation management(illustrate by a database/ER diagram).
2. Create a function using php to get all free rooms.
Input : Check-in Date, No. of Days for stay
Output : Available rooms, Price for entire stay.
3. Create a function to make reservation
Input : Check-in Date, No of Days for stay
Output : True/False - based on whether reservation was successfully made or not.
Below are the room types and per day prices
1. Single - INR 1500
2. Double - INR 2200
3. Luxury - INR 3500
There are 100 rooms in hotel which are distributed as 50 single, 25 double and 25 luxury rooms.
You need to perform the following tasks:
1. Design a database for the reservation management(illustrate by a database/ER diagram).
2. Create a function using php to get all free rooms.
Input : Check-in Date, No. of Days for stay
Output : Available rooms, Price for entire stay.
3. Create a function to make reservation
Input : Check-in Date, No of Days for stay
Output : True/False - based on whether reservation was successfully made or not.
No comments:
Post a Comment