Consider the database consisting of the following relations:

Flights(Flno: integer, City_From: string, City_To: string, Distance: integer, departs: Time, Arrives: time)

Flight_Instance(Flno: integer, Day: date, Aid: Integer)

Aircraft(Aid: integer, Make: string, Model: string, CrusingRange: string)

Certified(Eid: integer, Make: string, Model: string)

Employee(Eid: integer, Ename: string, Salary: integer)

Flight_Employee(Flno: integer, Day: date, Eid:integer, Role: string)

The Flight table contains general information about the flights whereas the Flight_Instance is about a flight number on a specific date. Aircraft list the aircrafts in the company, the make is the company that made the aircraft (e.g. Boing, Airbus) and the model is for example 747 for Boing or 321 for Airbus. The table Certified tells which employees can fly which airplanes, the tables Fight_Employee assigns employees to specific flights with a role (e.g. captain, first officer, flight-attendant, etc.). Finally, the table Employee lists the employees of the airline company.

Express the following queries in Algebra (1 to 4), Calculus (1 and 2), SQL (all)

=

1. Find the employees who can operate for at least one Boing airplane.

2. Find employees who can operate all the Boeing Airplanes.

3. Find employees who can operate at least airplane but not any Boeing airplane

4. List employees who can operate airplanes but have never been assigned a pilot role (captain, first officer).

5. List the pilot who has travelled the largest millage