Booking System - Database Design

gareth7 · Nov 26, 2004

I'm doing an online booking system for B&B accomdation.
Originally they just had a start date and end date for which days of the year they are open.
They now want to incorporate extra dates they may be open or closed - i.e. multiple open and close dates.

Could someone give me ideas on how to build this into the database schema? How can I build checks to see if a booking is possible for certain dates?

Any hints, links to tutorials etc would be appreciated

Thanks

johnherman · Nov 29, 2004

I would build a calendar (for each B&B), similar to an appointment calendar. Each day would have a status, Open, Closed, Booked, etc.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

ceh4702 · Nov 29, 2004

Here is a link to a web based hotel reservation system:

http://www.pelicansystem.com/index.html

This is just an example of some of the complexity. I am guessing B&B is bed and breakfast. I have no idea how many rooms you are talking about. However, if you are renting multiple rooms you have many rooms to many dates. You may also want to know what kind of beds are in each room or the capacity of the room. Then there is the rate structure. You may have different rates for different seasonal times or for travel agents.

If you do this by date, room, and status that might help. You could also link it up with billing and/or payment information.

If you do not like my post feel free to point out your opinion or my errors.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Booking System - Database Design

gareth7

Programmer

johnherman

MIS

ceh4702

Programmer

Similar threads

Part and Inventory Search

Sponsor