Consider the relational database shown here, where the primary keys are
underlined. Give an expression in the relational algebra to express each of
the following queries:
a. Find the names of all employees who work for “First Bank Corporation”.
b. Find the names and cities of residence of all employees who work for
“First Bank Corporation”.
c. Find the names, street addresses, and cities of residence of all employees
who work for “First Bank Corporation” and earn more than
$10,000.
d. Find the names of all employees in this database who live in the same
city as the company for which they work.
e. Assume the companies may be located in several cities. Find all companies
located in every city in which “Small Bank Corporation” is
located.
here is the database
employee (person name, street, city )
works (person name, company name, salary)
company (company name, city)
manages (person name, manager name)
