Reservation System

[juggernaut]

Hi,

  We need to build a reservation system for a group of hotels. We have got two entities: Hotels which contains available capacity and Reservations which contains one entry for each reservation, hotel details and dates on which a room is booked. Now I need to display the current availability to a user whenever he wants to make a reservation for a Hotel. So in RDBMS, we need to group the reservation records in Reservations table by reservation date (filled in by user during reservation) and subtract the total from available capacity in Hotels. 

 

Following is the data scenario:

 

Entity: Hotels

 

Hotel Name  Available Capacity

ABC              10

PQR               8

 

Entity: Reservations

Hotel Name Reserved Capacity Date of Reservation

ABC             1                             08-NOV-14

PQR             2                             08-NOV-14

 

So if a user comes in and selects Hotel ABC and puts in the reservation date as 08-Nov-14 then he should see the available capacity as 9. For PQR, the same would show up as 8.

 

 

Can this be done through Caspio ?

 

Thanks.

[Jan]

Hi juggernaut,

 

There is the  ready application, you can see demos of the application.

 

I hope, it helps.