Find the name of the manager of the manager of jones

Assignment Help Basic Computer Science

Reference no: EM131058185

Consider the relational database of Figure 6.22 where the primary keys are underlined. Give an expression in tuple relational calculus for each of the following queries:

a. Find all employees who work directly for "Jones."

b. Find all cities of residence of all employees who work directly for "Jones."

c. Find the name of the manager of the manager of "Jones."

d. Find those employees who earn more than all employees living in the city "Mumbai."

Reference no: EM131058185

Questions Cloud

Describe how socioeconomic status affects health care : Socioeconomic status influences health and drives diversity in the context of health disparities. Based on readings provided, describe how socioeconomic status affects health care. Can diversity in the health care workforce promote better health c..

Circumnavigation of the world : What new name did Francis Drake give his ship the Pelican during his circumnavigation of the World?

Creating a list report use proc report : Use the ia.personl data set and a WHERE statement to produce the charts requested below for the ticket agents. (JobCode values are TA1, TA2, and TA3.)

Established interpretation about the french revolution : What were some developments in contemporary French and other Western societies by the 1970s that according to Hobsbawn in his fourth chapter of Echos that facilitated popular acceptance of the attacks on the established interpretation about the Fr..

Find the name of the manager of the manager of jones : Find those employees who earn more than all employees living in the city "Mumbai."

Standard deviation of the data : A sample data set has n=50 observations. The mean of the data is x=46.5. the sum of squares is x^2=127793. What is the standard deviation of the data.

Importance of police patrol in modern policing : Explain the various lines of communications present within any given local law enforcement agency. Next, determine at least two (2) challenges and concerns that law enforcement might encounter with communication and suggest your strategy to mitiga..

Write the following queries in relational algebra : For each department, find the maximum salary of instructors in that department. You may assume that every department has at least one instructor.

Net present value of buying or leasing : Develop a simulation model to compare the net present value of buying or leasing the car for 24 months. To compare the two options a number of assumptions must be made. Assume that:

User Account

All Pages