Flight Enterprise System (FES)

Inspired by the exceptional user experience and efficiency of Singapore Airlines' Online Reservation Platform, we proudly introduce our cutting-edge flight reservation enterprise system. This innovative system is meticulously designed to cater to the diverse needs of the aviation industry and its stakeholders.

Project Overview

• Objective:
  • Design and develop a comprehensive Flight Reservation System to support Merlion Airlines' core business processes and enhance customer experience.

Key Features

1. Fleet Management:

   • Manage a fleet of aircraft, aircraft configuration, cabin configuration & seat management.

2. Route Planning:

   • Plan flight routes to about as many destinations as you want.

3. Cabin Classes:

   • Offer four cabin classes: First Class (F), Business Class (J), Premium Economy Class (W), and Economy Class (Y).

4. Dynamic Fare Management:

   • Implement a dynamic pricing mechanism that adjusts fares based on demand, time, and availability, optimizing revenue.

5. Collaborative Reservation Management:

   • Allow group reservations with multiple passengers, facilitating easy management and coordination for group travelers.

6. FRS Management Client:

   • Empowers comprehensive oversight and management of crucial elements within the aviation ecosystem. This includes meticulous control over employees, partners, airports, diverse aircraft types, intricate flight routes, precise flight schedules, and seamless reservation management.

7. FRS Reservation Client:

   • Tailored to deliver an exceptional experience for customers, this client offers a suite of user-centric functionalities. From effortless registration and secure login mechanisms to intuitive flight search, seamless reservation processes, and convenient access to viewing and managing reservations, it prioritizes a smooth user journey.

8. Holiday Reservation System:

   • Facilitating seamless integration with external partners, this client streamlines interactions with our system. It provides secure login access for partners, robust flight search capabilities, efficient reservation processes, and access to viewing their reservations within our system.

ER DIAGRAM

Project Structure

• docs: Documentation folder containing UML use case diagrams and associated business rules.

Contact Us

Contributors:

Glenn Quah

• GitHub: Glenn's GitHub
• LinkedIn: Glenn's LinkedIn

Ryan Tang

• GitHub: Ryan's GitHub
• LinkedIn: Ryan's LinkedIn

Test Case Docs: https://docs.google.com/document/d/14NK6GCpDTColbh9XLE1QcpfnPCRb9bW2/edit?usp=sharing&ouid=102220279603524460646&rtpof=true&sd=truehttps://docs.google.com/document/d/14NK6GCpDTColbh9XLE1QcpfnPCRb9bW2/edit?usp=sharing&ouid=102220279603524460646&rtpof=true&sd=true

Technology Stack

Our tech stack includes the following technologies and tools:

1. Java EE
2. NetBeans (IDE)
3. Java Persistence API (JPA)
4. SQL for database management
5. Java Persistence Query Language (JPQL)