← Back to problems

43. Hotel Booking Schema

MEDIUM
DatabaseSystem Design

Design the relational schema for a hotel booking system - guests, rooms, and bookings, with real constraints.

Design the database schema for a hotel booking system. The hotel has rooms, guests can book rooms for a date range, and each guest has a unique email on file. No architecture diagram or API design is required - this problem is purely about relational modeling: tables, columns, keys, and constraints.
Log in to submit a solution

Comments

Log into join the discussion.