Raffles Airways Flight Reservation Database

This project was an individual graded assignment where I designed a relational database for Raffles Airways based on provided UI flows and business rules. The goal was to convert real booking and check-in processes into a consistent ERD with correct keys, relationships, and constraints, then implement it in MySQL. The schema supports end-to-end ticket purchasing (select airports/dates, choose flights, compute pricing by seat class, store booking details, and issue tickets after payment). It also models check-in steps including validating a booking reference, capturing passport details, seat confirmation, baggage check-in, and generating boarding-pass-ready data. I implemented the design using MySQL Workbench (forward engineering) with InnoDB tables and foreign keys to enforce referential integrity. The final output includes a structured creation script and a schema that demonstrates practical database modelling decisions such as many-to-many relationships (aircrew scheduling, aircraft seat-class configurations) and optional membership linkage for points earning/redemption.