•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 422,638 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,710 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 2113 | Replies: 2
 |
•
•
Join Date: Dec 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
what is the best way to design a room hotel resveration system
is it by crating entites : reservation( room_id, start_date, end date)
or by creating entites : calender( calender_id, date), reservation(reservation_id, room_id, client_id) bookedates(reservation_id, calender_id) where to store dates of reservation
ps : it will be an onlnie reservation system so we have to show client available dates for reservation
thx
is it by crating entites : reservation( room_id, start_date, end date)
or by creating entites : calender( calender_id, date), reservation(reservation_id, room_id, client_id) bookedates(reservation_id, calender_id) where to store dates of reservation
ps : it will be an onlnie reservation system so we have to show client available dates for reservation
thx
•
•
Join Date: Aug 2007
Location: KSA
Posts: 147
Reputation:
Rep Power: 2
Solved Threads: 26
Junior Poster
Hi,
I think the best setup is:
calender( calender_id, date)
reservation(reservation_id, room_id, client_id,calender_id)
This way you will have the max control over your database where for wach day the client reservers a record will be inserted and if x days where reserved x records will be inserted. I have applied this to a hospital reservation system and it is working excelent as I can transfer reservation, break it, or cancel it easily.
I think the best setup is:
calender( calender_id, date)
reservation(reservation_id, room_id, client_id,calender_id)
This way you will have the max control over your database where for wach day the client reservers a record will be inserted and if x days where reserved x records will be inserted. I have applied this to a hospital reservation system and it is working excelent as I can transfer reservation, break it, or cancel it easily.
It is never about the number of languages you know, you either have the logic of programming or you don't ...
Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.
Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.
•
•
Join Date: Dec 2007
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
You have these entities
hotel(hotel_id,hotel_name,other details)
hotel_rooms(hotel_id,room_id,other details)
bookings(booking_id,date_from,date_to)
Guests(guest_id, name, etc.)
Room_bookings(booking_id,date_booking_from,date_booking_to,room_count)
hotel(hotel_id,hotel_name,other details)
hotel_rooms(hotel_id,room_id,other details)
bookings(booking_id,date_from,date_to)
Guests(guest_id, name, etc.)
Room_bookings(booking_id,date_booking_from,date_booking_to,room_count)
|
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
apple avatar backup breach business computer creative daniweb data data protection database design europe france government hacker howto hp ibm illustrator leopard library linux medicine microsoft news normalization open operating os parliament photoshop print research security server source sql survey switching system technology toread torvalds tutorials upgrade vista web windows xp
- Previous Thread: Optimizing tables to compare bilions of rows. How?
- Next Thread: Basic DBMS Concept
