Luton Luxury Hotel Booking System

Project Overview

This project was built to design and implement a complete database system for a hotel booking platform named Luton Luxury Hotel. It allows customers to book rooms online, check availability, manage bookings, and more — backed by a well-structured Oracle SQL database.

Technologies Used

• Oracle APEX (Database Implementation)
• SQL (DDL, DML, Queries)
• Entity Relationship Modeling (ERD)

Key Features

• Customer Registration & Login
• Room Booking with Date & Type (Single/Double)
• Room Availability Checks
• Booking Assignment by Managers
• Data Validation and Normalization (up to 3NF)

What I Did

• Created an ERD and designed entities with primary and foreign keys
• Normalized data to 3NF for minimal redundancy
• Implemented tables and sample data in Oracle APEX
• Executed queries like "Top Guest", "Bookings by Month", and "Room Availability"

Reflection

This assignment boosted my skills in SQL, database normalization, and Oracle APEX. While normalization was initially challenging, research and peer feedback helped me improve significantly. I'm now more confident in designing scalable, normalized databases and writing real-world queries.