Consider the relational database of Figure. Write a Datalog program for each of the following queries: a.
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) 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.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 44% (9 reviews)
a Find all employees who work directly or indirectly under the man...View the full answer
Answered By
Ashington Waweru
I am a lecturer, research writer and also a qualified financial analyst and accountant. I am qualified and articulate in many disciplines including English, Accounting, Finance, Quantitative spreadsheet analysis, Economics, and Statistics. I am an expert with sixteen years of experience in online industry-related work. I have a master's in business administration and a bachelor’s degree in education, accounting, and economics options.
I am a writer and proofreading expert with sixteen years of experience in online writing, proofreading, and text editing. I have vast knowledge and experience in writing techniques and styles such as APA, ASA, MLA, Chicago, Turabian, IEEE, and many others.
I am also an online blogger and research writer with sixteen years of writing and proofreading articles and reports. I have written many scripts and articles for blogs, and I also specialize in search engine
I have sixteen years of experience in Excel data entry, Excel data analysis, R-studio quantitative analysis, SPSS quantitative analysis, research writing, and proofreading articles and reports. I will deliver the highest quality online and offline Excel, R, SPSS, and other spreadsheet solutions within your operational deadlines. I have also compiled many original Excel quantitative and text spreadsheets which solve client’s problems in my research writing career.
I have extensive enterprise resource planning accounting, financial modeling, financial reporting, and company analysis: customer relationship management, enterprise resource planning, financial accounting projects, and corporate finance.
I am articulate in psychology, engineering, nursing, counseling, project management, accounting, finance, quantitative spreadsheet analysis, statistical and economic analysis, among many other industry fields and academic disciplines. I work to solve problems and provide accurate and credible solutions and research reports in all industries in the global economy.
I have taught and conducted masters and Ph.D. thesis research for specialists in Quantitative finance, Financial Accounting, Actuarial science, Macroeconomics, Microeconomics, Risk Management, Managerial Economics, Engineering Economics, Financial economics, Taxation and many other disciplines including water engineering, psychology, e-commerce, mechanical engineering, leadership and many others.
I have developed many courses on online websites like Teachable and Thinkific. I also developed an accounting reporting automation software project for Utafiti sacco located at ILRI Uthiru Kenya when I was working there in year 2001.
I am a mature, self-motivated worker who delivers high-quality, on-time reports which solve client’s problems accurately.
I have written many academic and professional industry research papers and tutored many clients from college to university undergraduate, master's and Ph.D. students, and corporate professionals. I anticipate your hiring me.
I know I will deliver the highest quality work you will find anywhere to award me your project work. Please note that I am looking for a long-term work relationship with you. I look forward to you delivering the best service to you.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer Sciences 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,...
-
In view of the information provided below provide suggestions for the efficient management of trade debtors. INFORMATION MANAGEMENT OF TRADE DEBTORS Debtor management is central to the effective cash...
-
Owner Yuning Zhu is considering franchising her Oodles of Noodles restaurant concept. She believes people will pay $7.00 for a large bowl of noodles. Variable costs are $2.45 a bowl. Zhu estimates...
-
Popeye Canning is contracted to receive daily 60,000 lb of ripe tomatoes at 7 cents per pound from which it produces canned tomato juice, tomato sauce, and tomato paste. The canned products are...
-
A laminar boundary layer velocity profile is approximated by the two straight-line segments indicated in Fig. P9.30. Use the momentum integral equation to determine the boundary layer thickness,...
-
A project that is expected to last six years will generate a profit and cash flow contribution before taxes and depreciation of $23,000 per year. It requires the initial purchase of equipment costing...
-
The total payroll of Crane Company for October, 2025 was $788000, of whic $147000 represented amounts paid in excess of $128,400 to certain employees for FICA. $490000 represented amounts paid to...
-
Morrell Company produces several products from processing krypton, a rare mineral. Material and processing costs total $30,000 per ton, one-third of which are allocated to the product merifulon. The...
-
Let R = (A, B) and S = (A, C), and let r(R) and s(S) be relations.Write expressions in QBE and Datalog for each of the following queries: a. { < a > | b ( < a, b > r b = 17)} b. { < a, b, c > | <...
-
Write an extended relational-algebra view equivalent to the Datalog rule p (A,C,D) : q1 (A,B), q2 (B,C), q3 (4,B), D = B + 1 .
-
The Fed conducts a $10 million open-market purchase of government bonds. If the required reserve ratio is 10 percent, what is the largest possible increase in the money supply that could result?...
-
You finding the specifications of the CPU you have installed in the computer in the simulation. 2. Look up the specifications of the CPU a. What is the base speed of the CPU? b. What is the number of...
-
Jones Company has $5,000,000 of average inventory and sales of $30,000,000. Using a 365-day year, calculate the firms inventory conversion period.
-
Do you agree that the impact of the message is dependent on the prestige, status or image of the speaker? Why?
-
Why did so many people participate in politics in the late nineteenth century? What did they hope to get out of it?
-
Examine the effects of group dynamics on the delivery of effective and efficient health care. (use your own words) Determine legal, ethical, diversity, and risk factors affecting decision-making and...
-
A financial analyst at Buckco Ltd. wants to compute the companys weighted average cost of capital (WACC) using the dividend discount model. The analyst has gathered the following data: Buckcos WACC...
-
Describe a group you belong or have belonged discuss the stages of group development and suggest how to improve the group effectiveness by using the group development model.
-
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?
-
Kaplan Inc. had 100,000 in unit-sales during the last quarter of last year. Managers expect the sales to increase by 10% each quarter over the next four quarters. The selling price is expected to...
-
This article titled "Evaluating Monetary Policy with Inflation Bands and Horizons 2023 -05 Troy Davig and Andrew Foerster February 21, 2023" discusses how monetary policy affects different sectors of...
-
Corporate governance is the set of rules, processes, and policies that guide and govern a business as it operates and manages risk. Tax laws have existed since the 1800s, and the history, Scope, and...
Study smarter with the SolutionInn App