Question: Answer the following queries using the model languages given to the left. (a) [TRC, Relational Algebra] Name and hiring names of employees earning more than
Answer the following queries using the model languages given to the left. (a) [TRC, Relational Algebra] Name and hiring names of employees earning more than $100,000. Find the dates. (b) For each project for which [TRC, Relational Algebra] department no. E21 is responsible, find the name of the employee responsible for that project. Find the name of the employee responsible for the project. (c) List the last names of employees who earn more than [SQL] Managers. (d) [SQL] Find the name(s) and number(s) of the highest paid employee(s). (e) [SQL] For each department, give the number of distinct projects.

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
