Question: Consider the relational database of Figure 2

Consider the relational database of Figure. Write a Datalog program for each of the following queries:
a. Find all employees who work (directly or indirectly) under the manager “Jones”.
b. Find all cities of residence of all employees who work (directly or indirectly) under the manager “Jones”.
c. Find all pairs of employees who have a (direct or indirect) manager in common.
d. Find all pairs of employees who have a (direct or indirect) manager in common, and are at the same number of levels of supervision below the common manager.


$1.99
Sales0
Views233
Comments
  • CreatedJanuary 28, 2011
  • Files Included
Post your question
5000