If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Booking table(s) design
As part of a hotel system, i need to create a booking system with customers
being booked into rooms on days of the year. I am looking to query a table(/s?) for the fields of: arrival date, departure date, occupancy the customer requires and whether they require an ensuite room or not. I am wondering what format my table/s should take to achieve the desired outcome of telling a customer whether there is a room free or not. Any help would be greatly appreciated. |
#2
|
|||
|
|||
Check this possible data model
http://www.databaseanswers.org/data_...tels/index.htm. -- Duane Hookom MS Access MVP "law" wrote in message ... As part of a hotel system, i need to create a booking system with customers being booked into rooms on days of the year. I am looking to query a table(/s?) for the fields of: arrival date, departure date, occupancy the customer requires and whether they require an ensuite room or not. I am wondering what format my table/s should take to achieve the desired outcome of telling a customer whether there is a room free or not. Any help would be greatly appreciated. |
#3
|
|||
|
|||
I'm not to sure how to query this database design though. Can anyone please
help? "Duane Hookom" wrote: Check this possible data model http://www.databaseanswers.org/data_...tels/index.htm. -- Duane Hookom MS Access MVP "law" wrote in message ... As part of a hotel system, i need to create a booking system with customers being booked into rooms on days of the year. I am looking to query a table(/s?) for the fields of: arrival date, departure date, occupancy the customer requires and whether they require an ensuite room or not. I am wondering what format my table/s should take to achieve the desired outcome of telling a customer whether there is a room free or not. Any help would be greatly appreciated. |
#4
|
|||
|
|||
Actually after reviewing the model, I don't like it. This one might be
better http://www.databaseanswers.org/data_...tion/index.htm. -- Duane Hookom MS Access MVP "law" wrote in message ... I'm not to sure how to query this database design though. Can anyone please help? "Duane Hookom" wrote: Check this possible data model http://www.databaseanswers.org/data_...tels/index.htm. -- Duane Hookom MS Access MVP "law" wrote in message ... As part of a hotel system, i need to create a booking system with customers being booked into rooms on days of the year. I am looking to query a table(/s?) for the fields of: arrival date, departure date, occupancy the customer requires and whether they require an ensuite room or not. I am wondering what format my table/s should take to achieve the desired outcome of telling a customer whether there is a room free or not. Any help would be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Many to many reationship design? | Dave | Database Design | 4 | January 18th, 2005 11:11 PM |
Relationship design problem with multiple tables | Don | New Users | 3 | November 24th, 2004 06:27 PM |
Mutliple Tables lookup? | Westley | Database Design | 4 | June 15th, 2004 01:07 AM |
Need help with Tables Design and Relationships | Tom | Database Design | 24 | May 19th, 2004 06:51 PM |
Multiple Many-To-Many Tables | Tom | Database Design | 7 | May 15th, 2004 03:47 AM |