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.)...

All:

I have a question on how best to store a deived values for status for a system.

I want to pick up some thoughts on alternatives/better to design a DB for this.

1. I have an...