Draw the ERDs for the following business rules using any software tool of your choice Gliffy is preferred. Copy/paste your diagrams to Word and then convert to .pdf for submission. Professional quality is expected. Identify all entities, attributes, relationships, primary keys, cardinalities and constraints where appropriate. Each complete entity (including all attributes, primary key, and foreign key) receives one point and each relationship (labeled with cardinalities in both directions) receives one point. Any constraint used correctly, receives two points. Primary keys will be bold or underlined, foreign keys in italics ONLY (no PK or FK on your diagrams). Label your relationships if there are more than one between the same entities.

For the FAA operation, model the following:

• All airlines are operational and employ at least one pilot.
• Airline pilots fly many flights. Each flight has one pilot.
• Pilots work for only one airline and are required to take two months leave per year.
• All pilots report to a supervisor, who is also a pilot.
• There are many passengers on a flight, each identified by a passenger number - they take any number of flights. A passenger may also cancel their flight but may incur a charge.
• The flight information includes a flight number, the source city, destination city, and flight date. Flights may be cancelled at any time for any reason.