Database design case study · Monroe University
A relational database for a 15-property hotel and resort business, covering hotels, rooms, guests, reservations, staff, services, payments and reviews.
Home / Projects / SunCrest
SunCrest Hotels & Resorts Database System
A completed relational database design case study using ER/EER modeling, normalization and SQL.
Key Capabilities
- Designed entities, attributes, primary and foreign keys, cardinalities and participation constraints.
- Modeled individual and corporate guests as a specialization with business rules.
- Normalized legacy reservation data through 1NF, 2NF and 3NF.
- Used joins, subqueries, indexes, views, functions, procedures, cursors, exception handling and triggers.