Jump to content
  • 0

Reservation System


juggernaut
 Share

Question

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.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...