Re: hotel booking database

Gaz wrote:

> Ok the situation is this i have to create a backend database in oracle
> and a front end in visual basic 6. The database is an hotel booking
> system. Basically you have a customer who can be linked to a company.
> this customer can book a room in which there are three choices in
> which the customer can be billed. THe customer can be billed, the
> company who they work for can be billed or another alternative address
> can be billed. What i am trying to do is to be able to set up a
> billing table that would enable me to set who is being billed but also
> to be able to push a button in my front end and the customers invoice
> for their stay can be printed out which has to display the billing
> address.
>
> Has anyone every built a system for a hotel or a similar kind of
> thing.
>
> Any help or advice would be greatly appreciated
>
> CHEERS
I built one for a major resort chain. A good system is extraordinarily complicated. You can email me off-line if you wish ... but I will tell you this for free ... the greatest fun comes from the fact that they overbook rooms. And that the percentage of overbooking depends on room type, resort, season, and historical trends. So you have to allow reserving things that don't exist and flexibility that doesn't smile when it confronts relational integrity.

Daniel Morgan Received on Fri Nov 22 2002 - 00:31:04 CET