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...
-
Sage Laundromat is trying to enhance the services it provides to customers, mostly college students. It is looking into the purchase of new high efficiency washing machines that will allow for the...
-
How does the strategic direction of the organization influence human resource planning activities?
-
Hayes (2000) took a stratified sample of New York City food stores. The sampling frame consisted of 1408 food stores with at least 4000 square feet of retail space. The population of stores was...
-
On January 1, 2024 , Stone leased an office building . terms of the lease require stone to make 15 annual lease payments of $135,000 beginning on leased an office building. Terms of the lease...
-
Mariam is a trader. On 1 March 202 the balances in her cash book were: Cash $100 debit Bank $494 credit The following transactions took place in March 202: March 4 Paid for repairs to office...
-
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 ping program allows you to send a test packet to a given location and see how long it takes to get there and back. Try using ping to see how long it takes to get from your location to several...
-
A 1.38 kg skateboard is coasting along the pavement at a speed of 5.59 m/s when a 0.790 kg cat drops from a tree vertically downward onto the skateboard. What is the speed of the skateboard-cat...
-
Two identical cylinders with a piston contain two different gases ( equal masses ) : helium in one, carbonic acid gas in the other. Gases are heated with the same amount of heat. Will the gas...
-
Darvin Company contained the following account balances: Cash Accounts Receivable Finished Goods Work in Process Materials Accounts Payable Accrued Payroll Common Stock 200,000 Retained Earnings...
-
Which of the following statements about a modular organizational design are correct? Manufacturing and service units may be modular. Managers outsource nonvital functions. The company becomes a...
-
Evaluate a ladder logic below. Is output 1 on or off? 11 17 # Input 1 On Input 2 Off Input 5 Off Input 9 On Input 7 Off 12 15 # H 19 H 01 H
-
The required rate of return is 12%, and the expected rate of inflation over the life of the project is forecast to remain steady at 3%. Should you invest in this project?
-
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?
-
ABC Inc. curently has a share price of $44. If they are paying a dividend of $1.13, with a cum dividend date of November 1, would would you expect their share price to be on November 2nd? Please give...
-
Does China benefit from a weak currency?Does Us benefit from a strong currency? Why? Please explain
-
You purchased 10 ASD June 45 puts and the company declares a 10% stock dividend. How are the terms of the option contract then changed?
Study smarter with the SolutionInn App