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