469,091 Members | 1,178 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,091 developers. It's quick & easy.

Online booking system problem

9
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
Jan 22 '07 #1
1 3039
MMcCarthy
14,534 Expert Mod 8TB
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
Jan 23 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Dave Robinson | last post: by
2 posts views Thread by Andy | last post: by
20 posts views Thread by bredal Jensen | last post: by
reply views Thread by thegame21 | last post: by
3 posts views Thread by =?Utf-8?B?cGF0cmlja2RyZA==?= | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.