need 1) ERD and 2) relational model for an airline company

An airline company has many planes that travel between different airports. A trip is handled by one pilot and involves one plane. Trips depart on a certain day and time from a departing airport and arrive at a different day and time in an arrival airport. Each airport is identified by a code, has a type (e.g., domestic), city and country, and a maximum plane capacity (e.g., 100). Each plane has a unique name and a date of manufacturing. A plane also has both weight and passenger capacities that cannot be exceeded. Each pilot has a name and an experience level (junior or senior). A senior pilot can supervise one (or many) junior pilots. However, a junior pilot can be supervised by only one senior pilot, if any. need an ERD (conceptual model) and a relational model (logical model) to capture the data as described.

If information provided is insufficient for a decision (e.g. determining the cardinality of a relationship), you can make reasonable assumptions. However, your assumptions must 1) not contradict information provided and 2) must be clearly noted on your models. You may add a simple key (e.g. customerID) to an entity if there is not a clear choice of an existing attribute that should serve as a primary key.

1) ERD and 2) Relational Model on the following criteria relative to the case given:

1. Identifying and including all of the entities, and no others.
2. Identifying and including all of the attributes of each entity, and no others.
3. Identifying and including appropriate primary keys.
4. Identifying, including and correctly characterizing relationships between entities.
5. Addressing many-to-many relationships appropriately.
6. Clearly legible and easy to interpret.
7. Relational Model Only: Identifying foreign keys.

1- ERD created by Visio (or similar) and saved as a PDF 

2- Relational Model created by Visio (or similar) or Excel and saved as a PDF