This pair project is one of NUS School of Computing (Information Systems [IS] major) core IS modules.
- Every entity class has a unique key identifier.
- Not all entities must perform CRUD (Create, Remove, Update & Delete) operations, only FlightSchedulePlan entity must.
- The core logic lies in Create Flight Schedule Plan and Search Flights.
- By having a unique key identifier, which is a primary key, data objects are retrieved easily and directly with its own ID.
- We assume that there will be 30 aircrafts and tracking of aircraft based on its tail number is not required.
- We assume that row numbers and seat letters are sequential with no skipping. Such that it is not essential to skip letters that may be confused with numbers (e.g. I, O, Q, S or Z).
- We assume that Merlion Airlines does not operates only in its home hub in Singapore Changi Airport and Taoyuan International Airport, it can also operate in other airports like Narita and Incheon International Airport.
- We must consider that different countries have different time zones.
- We assume that there is a fixed 4hrs period for layover.\
- For connecting flights, we assume that 2 hrs is needed for the transit, so flights between this period will not be taken into consideration during this 2hr period after landing of the first flight to the departing of the next flight.
This project also known as FRS, consists of 3 parts:
- FRS Management Client
- FRS Reservation Client
- Holiday Reservation System
- Create New Employee
- Create New Partner
- Create New Airport
- Create New Aircraft Type
- Employee Login
- Employee Logout
- Create Aircraft Configuration
- View All Aircraft Configurations
- View All Aircraft Configuration Details
- Create Flight Route
- View All Flight Routes
- Delete Flight Route
- Create Flight
- View All Flights
- View Flight Details
- Update Flight
- Delete Flight
- Search Flight
- Reserve Flight
- Create Flight Schedule Plan
- View All Flight Schedule Plans
- View Flight Schedule Plan Details
- Update Flight Schedule Plan
- Delete Flight Schedule Plan
- View Seats Inventory
- View Flight Reservations
- View My Flight Reservations
- View My Flight Reservation Details
- Register As Customer
- Customer Login
- Customer Logout
- Partner Login
- Partner Search Flight
- Partner Reserve Flight
- View Partner Flight Reservations
- View Partner Flight Reservation Details
- Partner Logout