For this assignment we are going to design a system to schedule flight crews and aircraft for Mean Green Airlines For this we will need the following entities, plus collections for each of the entities: Plane/Aircraft, Crew Member and Flight. The data for a Plan will contain at least the following Make (e.g. Boeing) Model (eg 737) Tail Number (eg B171A) Number of Seats (eg 137) Range (e.g. 800 miles) Status (out, in, repair) You may add other data needed for your implementation as well as you will need accessor and mutator functions for the data The data for a crew member will contain at least: Name D number Type (Pilot, CoPilot, Cabin) Status (available, on leave, sick) You may add other data needed for your implementation as well as you will need accessor and mutator functions for the data The data for a Flight (The transaction entity) will contain at leat the following Plane ID (Tail number) Pilot ID CoPilot ID Crew IDs for 3 Cabin Crew Members Start Date/Time with TZ End Date/Time with TZ Starting Airport code (3 letters) Ending Airport Code (3 letters) Number of Passengers Status (active, cancelled, completed) For this assignment we are going to design a system to schedule flight crews and aircraft for Mean Green Airlines For this we will need the following entities, plus collections for each of the entities: Plane/Aircraft, Crew Member and Flight. The data for a Plan will contain at least the following Make (e.g. Boeing) Model (eg 737) Tail Number (eg B171A) Number of Seats (eg 137) Range (e.g. 800 miles) Status (out, in, repair) You may add other data needed for your implementation as well as you will need accessor and mutator functions for the data The data for a crew member will contain at least: Name D number Type (Pilot, CoPilot, Cabin) Status (available, on leave, sick) You may add other data needed for your implementation as well as you will need accessor and mutator functions for the data The data for a Flight (The transaction entity) will contain at leat the following Plane ID (Tail number) Pilot ID CoPilot ID Crew IDs for 3 Cabin Crew Members Start Date/Time with TZ End Date/Time with TZ Starting Airport code (3 letters) Ending Airport Code (3 letters) Number of Passengers Status (active, cancelled, completed)