By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,650 Members | 1,785 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,650 IT Pros & Developers. It's quick & easy.

Online booking system problem

P: 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
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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.