Database Systems Project $($PHASE $2)$ Functional Requirements

Due: Saturday, May $11,2024.$

Functions of a Passenger

$$ Add$/$Remove$/$Edit ticket: To add, remove or modify ticket.

$$ Search flights

$$ Book seats.

$$ Do payment

Functions of an Admin

$$ Add$/$Remove$/$Edit ticket: To add, remove or modify ticket.

$$ Book seats

$$ Generate reports

$$ Promote a waitlisted passenger

$$

General Function

$$ Login and Logout

Reports

$$ Current active flight

$$ Percentage of booking in every flight on a given date

$$ Payments that have been confirmed and complete

$$ Waitlisted passengers in each class given a flight number

$$ Average load factor $($percentage of seats occupied divided by total seats$)$ for all planes on a given date

$$ Ticket cancelled