2) (45 pts) Consider the following relational schema: Flights (flno, from, to, distance, departs, arrives) Aircraft (aid, aname, cruisingrange) Certified (eid aid) Employees (eid, ename, salary) Write the Relational Algebra (RA), Tuple Relational Calculus (TRC), and Domain Relational Calculus (DRC) expressions to answer the following queries. Note that some of these queries might not be expressible in Relational Algebra or Relational Calculus. For such queries, informally explain why they cannot be expressed: a. Find the names of pilots certified for some Boeing aircraft. b. Identify the flights that can be certified for all pilots whose salary is more than $100,000. c. Find the eids of the employees that are certified for the largest number of aircrafts. 2) (45 pts) Consider the following relational schema: Flights (flno, from, to, distance, departs, arrives) Aircraft (aid, aname, cruisingrange) Certified (eid aid) Employees (eid, ename, salary) Write the Relational Algebra (RA), Tuple Relational Calculus (TRC), and Domain Relational Calculus (DRC) expressions to answer the following queries. Note that some of these queries might not be expressible in Relational Algebra or Relational Calculus. For such queries, informally explain why they cannot be expressed: a. Find the names of pilots certified for some Boeing aircraft. b. Identify the flights that can be certified for all pilots whose salary is more than $100,000. c. Find the eids of the employees that are certified for the largest number of aircrafts