$2.$ Create the ERD using LucidChart. $($Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many CHARTER trips but that each CHARTER trip is flown by one AIRCRAFT, that a MODEL references many AIRCRAFT but that each AIRCRAFT references a single MODEL, and that all pilots are employees, but not all employees are pilots$$some are mechanics, accountants, and so on$.)$

$3.$ Modify the ERD you created. Create a composite table named CREW to link the CHARTER and EMPLOYEE tables. Some crew members, such as flight attendants, may not be pilots. That$$s why the EMPLOYEE table enters into this relationship.$)$ Show the final LucidChart ERD.

$4.$ Update the table structures in Workbench in order for the database to comply with the ERD diagram, $($add CREW table, PKs and FKs$).$ Create the relational diagram using workbench.

$5.$ Create the S$$L queries to:

a$.$ Print data on charters flown by either Robert Williams or Elizabeth Travis as pilot.

b$.$ Select the total hours that Robert Williams had flown during the month of Octobre, $2018.$

c$.$ Show the REVENUE for the year $2018.$