Consider the employee database given below.

Staff (person name, street, city) Employee (person name, company name, salary) Company (company name, city) Managed (person name, admin name)

Give Relational Algebra, SQL, and Multiple Relational Analysis (TRC) expressions for each of the following queries:

a) [IC, SQL, and TRC] Find all employees living in the city where their company is located..

b) [IC, SQL, and TRC] Find all employees living in the same city and on the same street as their managers.

c) [IC, SQL, and TRC] Find all employees not working for First Bank Corporation in the database.

d) IC, SQL, and TRC] Find all employees of "Small Bank Corporation" who earn more than each employee. Suppose the companies can be located in several cities.