0

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

3
Contributors
2
Replies
4
Views
10 Years
Discussion Span
Last Post by sam10
0

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.

0

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)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.