You have been asked to design a database system to support the operations of ABC International Airport. The airport needs to track flights from their scheduling through to completion, aircraft details, tickets sold, and passenger bookings.

Senario:

ABC International Airport manages hundreds of flights across multiple destinations per day. As the airport expands operations, they need to implement a new database system to efficiently handle flight scheduling, aircraft fleet management, passenger bookings and staff rostering.