Figure $5$

a$)$ For each table, identify the primary key and foreign key$($s$)$ when possible.

b$)$ Identify all the relationships between the tables.

You want to see data on charters flown by either Robert Williams $($employee number$105)$ or John

Lange $($employee number $104)$ as pilot or copilot, but not charters flown by both of them. Complete

Problems $2-$c to $2-$e to find this information.

c$)$ Create the table that would result from applying the SELECT and PROJECT relational

operators to the CHARTER table to return only the CHAR$\_$TRIP, CHAR$\_$PILOT, and

CHAR$\_$COPILOT attributes for charters flown by either employee $105$ or employee $104$

as pilot or copilot.

d$)$ Create the table that would result from applying the SELECT and PROJECT relational

operators to the CHARTER table to return only the CHAR$\_$TRIP, CHAR$\_$PILOT, and

CHAR$\_$COPILOT attributes for charters flown by both employee $105$ and employee $104.$

e$)$ Create the table that would result from applying a DIFFERENCE relational operator of

your result from Problem $2-$c to your result from Problem $2-$d$.$