Booking table(s) design

[law]

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.

 

[Duane Hookom]

Check this possible data model
http://www.databaseanswers.org/data_models/hotels/index.htm.

 

[law]

I'm not to sure how to query this database design though. Can anyone please
help?

 

[Duane Hookom]

Actually after reviewing the model, I don't like it. This one might be
better
http://www.databaseanswers.org/data_models/longterm_accommodation/index.htm.