Question: 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)

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.

Step by Step Solution

★★★★★

3.31 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Find all employees who work directly or indirectly under the man... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

16-CS-DB (157).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Consider the relational database of Figure. Give an expression in the relational algebra for each request: a. Modify the database so that Jones now lives in Newtown. b. Give all employees of First...

Consider the relational database of Figure. Give an expression in SQL for each of the following queries. a. Modify the database so that Jones now lives in Newtown. b. Give all employees of First Bank...

Consider the relational database schema of Figure 3.5. Suppose that all the relations were created by (and hence are owned by) user X, who wants to grant the following privileges to user accounts A,...

Please do not answer if you cannot answer all of them. Problem 6. Answer 6.1-6.2 using Employee database employee (employee name, street, city) works (employee name, company_name, salary) company...

Use Figure 6.17 above to answer the following questions: 5. In the General Hardware Corp. relational database of Figure 6.17: a. How many foreign keys are there in each of the six relations? b. List...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Let r and s be solutions to the quadratic equation x 2 b x + c = 0. For n N, define d0 = 0 d1 = r s dn = b dn1 c dn2 (n 2) Prove that dn = r n s n for all n N. [4 marks] (b) Recall that a commutative...

In a single SQL script file ending in .sql: Create a COMPANY database. This should be part of your SQL script, and you may add a DROP DATABASE command before it so that you can re-run your script as...

See DATALOG EXAMPLES BELOW: Question 4 Work In network records information about users being "connected" to each other as well as about the companies they work for and the countries they live in....

BELOW ARE EXAMPLES FROM MY LECTURE SLIDES ON DATALOG: Question 5 The collaboration distance between two researchers Xavier and Yvonne is defined as n where n is the smallest number such that there...

ABC Manufacturing Co. produces a variety of items in accordance with special orders from its various customers. The following $12 manufacturing cost per unit pertains to an order of 1,250 units of...

Under the entity approach of reporting non-controlling interest, what value is assigned to goodwill?

Enablect Final Exam ( i ) sold for $ 8 0 0 . Gant's tax rate is 5 0 2 . In a discounted cash flow analysis of this project, what worid be the projected Year otherender end

Read the case study Management Information System MIS 201 1. Why are data, information, business intelligence, and knowledge important to Apple? Give an example of each type in relation to the iPad....

Read the chapters Monetary Policy, and compare how the Federal Reserve and Monetary Policy impact how money follows through the economy. Write a paper in which you address the following Analyze the...

On December 31, 20X9, Add-On Company acquired 100 percent of Venus Corporation's common stock for $300,000. Balance sheet information Venus just prior to the acquisition is given here: Cash and...

Consider the AR(1) model Yt = 0 + 1 Y t-1 + ut. Suppose that the process is stationary. a. Show that E(Y t ) = E(Y t - 1 ) b. Show that E(Y t ) = 0 /(1- 1 )

Consider the regression model and show the following: a. b. c. If X 1 changes by ?X 1 and X 2 changes ?X 2 , then ?Y = AY/AX =B + B3X (effect of change in X holding X constant).

The elementary irreversible liquid-phase reaction A+2BC is to be carried out in a semi batch reactor in which B is fed to A. The volume of A in the reactor is 10 dm 3 , the initial concentration of A...

The organization of parts, chapters, sections, and subsections in a book is related to clustering. Explain why, and to what form of clustering.

Consider each of the takes and teaches relations as a fact table; they do not have an explicit measure attribute but assume each table has a measure attribute reg_ count whose value is always 1. What...

Why is column-oriented storage potentially advantageous in a database system that supports a data warehouse?

Classification can be done using classification rules, which have a condition, a class, and a confidence; the confidence is the percentage of the inputs satisfying the condition that fall in the...

Consider the takes relation. Write an SQL query that computes a cross-tab that has a column for each of the years 2017 and 2018, and a column for all, and one row for each course, as well as a row...

Yield to maturity. What is the yield of each of the following bonds, , if interest ( coupon ) is paid semiannually? a . What is the yield of the following bond if interest ( coupon ) is paid...