Model Flights, Passengers, Bookings, and Seat Holds
Company: Serval
Role: Software Engineer
Category: System Design
Difficulty: medium
Interview Round: Technical Screen
Overview: Design a relational flight-booking model for passengers, scheduled departures, seat reservations, and temporary holds. Explain efficient lookup in both directions, retry behavior, transaction boundaries, expiration races, cancellation history, pagination, and concurrent attempts to claim one seat.
Read the full Serval Software Engineer interview experience this question came from