Refer to the ER diagram provided for this assignment. It presents the schema

$*$ of a database supporting a hotel management system. This is a US hotel chain

$*$ with multiple hotels at different locations. Staff may work at one or more

$*$ locations. Each hotel building has multiple rooms that guests can reserve.

$*$ Guests can also write reviews about their experiences.