Online booking system problem

[simba]

Hello,

I am currently doing a project which requires me to develop an online booking system for hotels and integrate both bed and room booking. I have the room booking working but I cant seem to get the bed booking working. I have dorm rooms with 8 beds in them and I would like to have a query(or something) which allows me to make the dorm rooms bed booked instead of room booked. Anyone any ideas on how to make this happen, anything would be much appreciated. I am using JSP and oracle for the project.

Thank you

[MMcCarthy]

Hello,

I am currently doing a project which requires me to develop an online booking system for hotels and integrate both bed and room booking. I have the room booking working but I cant seem to get the bed booking working. I have dorm rooms with 8 beds in them and I would like to have a query(or something) which allows me to make the dorm rooms bed booked instead of room booked. Anyone any ideas on how to make this happen, anything would be much appreciated. I am using JSP and oracle for the project.

Thank you

I would suggest you create a separate beds table and assign a unique number to each bed regardless of room. Also have a foreign key in this table to the RoomID field of the room table which will allow you to create a query to book the beds in a room rather than just the room.

Mary