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...
-
Mark is the sole shareholder of Tex Corporation. Mark first formed Tex as a C corporation. However, in an attempt to avoid having Tex's income double taxed, Mark elected S corporation status for Tex...
-
To what extent do you agree that the Ubuntu philosophy could improve American leadership models? L01
-
Dana Corporation, based in Toledo, Ohio, is a global manufacturer of highly engineered products that serve industrial, vehicle, construction, commercial, aerospace, and semiconductor markets. It...
-
Stuart Corporation expects to incur indirect overhead costs of $ 1 0 4 , 5 0 0 per month and direct manufacturing costs of $ 1 2 per unit. The expected production activity for the first four months...
-
Friendly Grocer has three departments in its store: beverages, dairy and meats, and canned and pack-aged foods. Each department is headed by a departmental manager. Operating results for the last...
-
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 .
-
Using the adjusted present value model, under what assumptions are the MM (with corporate taxes) results correct?
-
See US Debt Clock and answer the following: (Hint: Take a screenshot of the Debt Clock) (2) A. What is the current US deficit and the total federal debt? (1) B What is the net interest...
-
GASB states that public colleges and universities are special purpose governmentsand therefore accountable to the citizenry (Hoyle, 2015). Furthermore, GASB found that for public colleges and...
-
You have recently been assigned to the production planning department within your company. Your firm makes large blades for power generation windmills. The windmills are mostly used in the western...
-
Jason Ready attended the University of Ohio from 2 0 1 9 to 2 0 2 3 under the Air Force ROTC program. Excluding the school expenses covered by his ROTC scholarship, he incurred additional school...
-
Questions Chap 1 1. Consider the following cases and decide whether criminal or civil proceedings would result, and make a note of the parties in the action. a) Ali is being prosecuted for careless...
-
Terrapin Marmots 2018 annual report has been included as an enclosure.
-
What mass of KBr (in grams) should you use to make 350.0 mL of a 1.30 M KBr solution?
-
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?
-
During 2024, its first year of operations, Hollis Industries recorded sales of $11,900,000 and experienced returns of $760,000. Cost of goods sold totaled $7,140,000 (60% of sales). The company...
-
What is the value of a 15% coupon bond with 11% return? Is it a discount or a premium bond?
-
A manufacturer with a December 31 taxation year end sells new machinery for $50,000 on January 2, 2022. The cost of the machinery is $20,000. The terms of the sale require an initial payment of...
Study smarter with the SolutionInn App