Posted by ZeldorBlat on 10/31/05 01:57

Presumably you have something like this:

create table hotel (
hotel_id int not null
....
)

create table room (
room_id int not null
hotel_id int not null
....
)

Then create a table to store the bookings. Something like this:

create table booking (
room_id int not null,
bookingDate smalldatetime
)

The primary key for this table should be (room_id, bookingDate). If
there is a row for a given room and date, then it's booked on that
date. Otherwise it isn't.

[Back to original message]