Consider the following Scenario. Design a database for an airline. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights,...

Consider the following Scenario.
Design a database for an airline. The database must keep track of customers and
their reservations, flights and their status, seat assignments on individual flights,
and the schedule and routing of future flights. Your design should include an E-R
diagram, a set of relational schemas, and a list of constraints, including primary-key
and foreign-key constraints.
Please determine the entities, attributes and relationships that should exist in the
database and draw an E-R diagram.