Designing an airline booking database: relationships, seat inventory and overbooking
Airline data-model case study, part 1: writing relationships as sentences, the ER model, evolving v1 into v2, reference data, per-seat rows versus a counter for seat inventory, the correct overbooking formula, and indexes for the main queries.