Designing a Hotel Management System

A guest reaches the front desk late at night and asks for a room for two nights.

The clerk needs four answers before she can say yes. Which rooms are free on both nights. What each one costs. Whether this guest is already in the system. How the stay will be paid for.

Each answer is a query against one database. This case study builds that database, from the requirement to running SQL.

What the system must do

Six capabilities, taken from what hotel staff actually do.

Manage guests. Who they are, how to reach them, and which document proved their identity.

**Manage rooms