edited by
1,737 views
1 votes
1 votes

Consider the relational database given below where the primary keys are
underlined. Give an expression in tuple relational calculus for each of the
following queries:

a. Find all employees who work directly for “Jones.”
b. Find all cities of residence of all employees who work directly for
“Jones.”
c. Find the name of the manager of the manager of “Jones.”
d. Find those employees who earn more than all employees living in the
city “Mumbai.”

here is the database

employee (person name, street, city )
works (person name, company name, salary)
company (company name, city)
manages (person name, manager name)
edited by

1 Answer

Related questions

0 votes
0 votes
1 answer
3