An airline ticket agency does the seat booking for passengers. A separate booking reference number is given to each passenger. An airplane has a number of seats allowed for each ticket agent. Any airplane flight has a unique flight number, a departure airport, a destination airport, departure date and time, and arrival date and time. A passenger has a passport number, given names, a surname, and an email address. Develop a system to manage the day-to-day business of this agency