Sidney Raabe

For this project, I was tasked with creating a SQL database to model relationships between raw data about hotel room reservations. The data set included tables of information about rooms, guests, and reservations.

To accurately model the relationships, I standardized the data into second normal form, addressing issues of redundant data and inter-column dependencies within table rows.

I then engineered an ERD using Draw.io to model the relationships between the data.

From this ERD, I was able to create a functional SQL database that was able to effectively store and retrieve the data needed. The querying functionality provides insights and information that were not possible before when it was presented as raw table data.

The most challenging part of this project was modeling many-to-many relationships, such as the relationship between guests and reservations. To solve this, I utilized bridge tables to effectively represent these relationships.

This project helped me understand the use and power of bridge tables in effectively modeling less straightforward relationships.