online room reservation database design

Reply

Join Date: Jul 2009
Posts: 1
Reputation: twity is an unknown quantity at this point 
Solved Threads: 0
twity twity is offline Offline
Newbie Poster

online room reservation database design

 
0
  #1
Jul 3rd, 2009
Hi there,
I am designing database for a room reservation website. I have designed database such as:
RoomDetail(RoomNo#,RoomType,RoomStatus)
RoomTypeDetail(RoomType#,Description,rent)

Now I want reservation which handles for any pre-booking, on the spot booking. What modification is required in RoomDetail or a new database ......
I am really confused
Pl I am looking for help.

Thank you
Reply With Quote Quick reply to this message  
Join Date: Mar 2007
Posts: 304
Reputation: timothybard is an unknown quantity at this point 
Solved Threads: 25
timothybard's Avatar
timothybard timothybard is offline Offline
Posting Whiz

Re: online room reservation database design

 
0
  #2
Jul 3rd, 2009
I would recommend a new table that has fields to track the following:

Room, Customer, Check-In Date, Check-Out Date
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Database Design Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC