in Databases edited by
1,239 views
1 vote
1 vote

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)
in Databases edited by
1.2k views

1 Answer

0 votes
0 votes

Here is the official link for solutions of this book.

https://www.db-book.com/db6/practice-exer-dir/index.html

The solutions have been given by writers of this book. There can be other answers too for solving these questions.

Related questions