Question: Consider the following relations and answer questions 1-6 using SQL. 2 points for each question. Emp (eno, ename, title, city) Proj (pno, pname, budget, city)

Consider the following relations and answer questions 1-6 using SQL. 2 points for each question.

Emp (eno, ename, title, city)

Proj (pno, pname, budget, city)

Works (eno, pno, responsibility, duration)

Pay (title, salary)

1. Find the enames of employees who work on the project named Installation.

2. Find the employees number whose salaries are above the average salary.

3. For each city, how many projects are located in that city and what is the total budget over all projects in the city?

4. Find the names of projects whose budgets are greater than the budgets of any projects located in Boca Raton.

5. Find employees enames who work on all the projects.

6. Find projects names for any project if there are more than 2 people sharing the same responsibility.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Consider the following relations and answer questions 1-6 using SQL. 2 points for each question. Emp (eno, ename, title, city) Proj (pno, pname, budget, city) Works (eno, pno, responsibility,...

Q:

Consider the following relations and answer questions 1-6 using SQL. 2 points for each question. Emp (eno, ename, title, city) Proj (pno, pname, budget, city) Works (eno, pno, responsibility,...

Q:

Consider the following relations and answer questions 1-6 using SQL. 2 points for each question. Emp (eno, ename, title, city) Proj (pno, pname, budget, city) Works (eno,.pno, responsibility,...

Q:

Consider the following relations and answer questions 1-6 using SQL. Emp (eno, ename, title, city) eno is the primary key Proj (pno, pname, budget, city) pno is the primary key Works (eno, pno,...

Q:

Question 3 [25 points] Consider the following relations as discussed in class: Emp (eno, ename, title, city) Proj (pno, pname, budget, city) Works (eno, pno, responsibility, duration) Pay (title,...

Q:

Question 3 (25 points] Consider the following relations as discussed in class: Emp (eno, ename, title, city) Proj (pno, pname, budget, city) Works (eno, pno, responsibility, duration) Pay (title,...

Q:

Question 3 [25 points] Consider the following relations as discussed in class: Emp (eno, ename, title, city) Proj (pno, pname, budget, city) Works (eno, pno, responsibility, duration) Pay (title,...

Q:

SUMMARY OF LEARNING OBJECTIVES AND KEY POINTS 1. Identify the basic elements of organizations. Organizations are made up of a series of elements: Designing jobs Grouping jobs Establishing reporting...

Q:

1. - Expain the motivations of Unilever in acquiring Inmarko. - Identify the risks Unilever faces in using acquisition as a mode for growth, as opposed to other modes discussed in the chapter. 2....

Q:

1. - Expain the motivations of Unilever in acquiring Inmarko. - Identify the risks Unilever faces in using acquisition as a mode for growth, as opposed to other modes discussed in the chapter. 2....

Q:

On Fig. 10.5, identify and define an outwash plain.

Q:

Figure 1 shows nominal yields on sovereign (i.e., government) two-year bonds. . (a) The debt-to-GDP ratio in the U.S. is relatively high at around 100%, but its bonds pay a low nominal interest rate....

Q:

Crane, Inc. reported actual sales of 2 0 9 2 0 0 0 and fixed costs of 3 5 0 4 1 0 . The contribution margin ratio is 2 5 % Compute the company's margin of safety in dollars and the margin of safety...

Q:

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Q:

Visit your campus career center and gather information on interest and personality tests they offer or recommend to help individuals determine their career interests. Take one of the tests, have the...

Q:

What are the three purposes of an oral communication message? Identify a business scenario that would be appropriate for each purpose. (Objective 4)

Q:

Give emphasis to the important points in the following paragraph by varying (a) your pitch; (b) your volume; (c) your speed; and (d) your pitch, volume, and speed in appropriate combinations....