Hotel Reservation MySQL Schema
Independent MySQL Assignment
Introduction
Given preexisting data about a mock hotel’s reservations, as well as specified conditions, such as only certain rooms having a specific amenity, a relational database was constructed through MySQL with appropriate tables, columns, and relationships. This included creating a draft ERD (Entity-Relationship Diagram), plus DDL (Data Definition Language) and DML (Data Manipulation Language) scripts, then testing those scripts through specific queries to gather certain information about the hotel reservations.
My Role
​Completed project as part of my participation in the Alumni Training in Production Support at mThree.
Some of my key contributions to the research included:
-
Visualizing the structure of the database through an ERD
-
Constructing the structure of the database through a DDL script
-
Manually inputting the hotel reservation data through a DML script
-
Write queries that could answer the questions specified in the assignment
Click the button to view my certification for completing the
Alumni Training in Production Support at mThree.
