Database: Your task is to design an E-R schema for the OntarioTech Airlines (OTA) database, which includes flight information and reservations. The requirements/specifications are provided below.

• Regarding flights
  • A flight will be composed of a flight number, a single economy fare, and a sequence of flight segments;
  • A flight segment should contain info about departure, which includes airport and time, and arrival, which also includes airport and time. To simplify the database, consider that a single airplane is assigned to a given flight segment on a given day.
  • A flight segment will also have the number of seats available to be reserved. A seat on an airplane is reserved for a flier, which is composed of name and email.
• Regarding airplanes and airports
  • The airline also needs to keep information about their airplanes and the airports they serve. For airports, they want to keep the code (e.g. YYZ), the name (e.g. Toronto Pearson International Airport), city and province (e.g. Toronto, Ontario).
  • Airplanes will also have a model/type, with information regarding the model#, manufacturer, and number of seats.
  • In addition, the ER diagram should consider that certain airplane models will be allowed (or not) to land at certain airports (e.g., a large airplane like a Boeing 747 can land at YYZ, but not at the smaller Billy Bishop Toronto City Airport - YTZ).
• Q1: Design an ER diagram to model OntarioTech Airlines database. Please state any assumptions that you make (e.g., primary keys you created), and also any rules that are not captured in your diagram.