1) T2/T3

Question 2:

Consider the following schema:

Flights (flno: integer, from: string, to: string, distance: integer, departs: time, arrives: time)

Aircraft (aid: integer, aname: string, cruisingrange: integer)

Certified (eid: integer, aid: integer)

Employees (eid: integer, ename: string, salary: integer)

The Employees relation describes pilots and other kinds of employees as well and every pilot is certified for some aircrafts. Write the following queries in relational algebra.

Note: for each join, you must specify the join condition to receive credit.

1)Find the names of pilots certified for the aircraft Boeing-777.

2)Find the names of pilots who can operate planes with a cruising range greater than 3,000 miles.

Question 1 (70 points): Consider the three tables T1, T2 and T3 as shown below. Show the results of the following operations (assuming T1 and T2 are set-compatible). Table T1 Table T2: 10 10 15 25 25 10 Table T3 10 10