Hotel Booking System Database Management

Description

 A relational database for a hotel booking system was designed and implemented using SQL, with a focus on enhancing the guest experience. The system includes unique features such as a loyalty program and tracking additional services. Data analysis was performed to identify trends in bookings and customer behavior, generating insightful reports. The database was deployed on AWS Cloud with robust backup strategies to ensure data integrity and availability. 

Code & Diagrams & Dashboard

Link for Code

Link for Diagrams

Link for Dashboard

Skills

- SQL (Relational Database Design, Normalization - 3rd Normal Form)

- ER Diagram

- AWS Cloud Deployment (Data Integrity and Availability)

- Dashboards (Customer Behavior Analysis, Trend Analysis)