employee (person name, street, city)
works (person name, company name, salary)
company (company name, city)
Consider the relational database on above. Give an expression inthe
RELATIONAL ALGEBRA(NOT SQL) to express each of thefollowing queries:
a. Find the names of all employees who live in city “Miami”.
b. Find the names of all employees whose salary is greater than$100,000.
c. Find the names of all employees who live in “Miami” andwhose
salary is greater than $100,000.
Expert Answer
An answer will be send to you shortly. . . . .