How to query reservation db by dates for availability
HI there
hope someone can help.
I am trying to make a little hotel reservation system and am really confused as to how I can represent accurately the calendar year and how to query the database to check (1)availability of rooms for a particular time period (2)available rooms & booked rooms for particular month.
I already have 3 tables : bookings, room & clients.
Table called clients contains info on the guest like ID, address etc.
Table called room contains details of a room like roomID etc.
Table called bookings contains details like roomID, clientID, startDate, endDate
Do i need to create month tables for all rooms (e.g. table called May 2005 Rooms, June 2005 Rooms)& how can I create tables for each month in a given year with the right number of days?
I just am really confused about querying the database :(
Any help would be soooooooo appreciated
Subject
Written By
Posted
How to query reservation db by dates for availability
May 04, 2005 03:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.