1. Introduction


Hotel booking systems face a fundamental design decision: how to model availability and reservations in the database. This document compares two primary approaches:

Schema 1: Row-Per-Day for Fungible Room Types


One row per (hotel_id, room_type_id, date)
Rooms of the same type are fungible (interchangeable)
Uses B-tree indexes...