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. create an erd (conceptual model) and a relational model (logical model) to capture the data as described.