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

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 ov all projects in the city? 4. Find the names of projects whose budgets are greater than the budgets of any projects cated 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!

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,...

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,...

Derive a horizontal fragmentation of ASG that is best for the following two applications using ASG. Refer to the relations giving in the tables below. The first application is present at 4 sites and...

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,...

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,...

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,...

HINT: The answer for this question is on Course Hero. I just don't have access to it. If you have it please paste your answer here. Thank you. Q1: (10 Points) Consider the following engineering...

Q1: (10 Points) Consider the following engineering database DUR 12 10 18 FMP ENO ENAME TITLE ENO PNO RESP E1 J. Dnes Elmet. Eng Manager M. Smith Byet. Anal P1 Analyst Mach Eng P2 Analyst E4 J. Miller...

5.8 In a pseudo first order hydrolysis of ester in water, the following results were obtained: t/s 30 60 90 [Ester/mol L 0.31 0.55 0.17 0.085 (i) Calculate the average rate of reaction between the...

There is a need to write a program which computes the cube of the number entered from the keyboard. The number can be any number between 0 and 9. For example, if the number entered from the keyboard...

Financial planners can help client s review several factors when evaluating insurance plans. These include: a . Deductible, copayment, coinsurance, stop - loss limit b . Lifetime max, annual limit ,...

Horizon Investment Corporation has 9 million shares of common stocks outstanding; 250,000 shares of preferred stock outstanding (annual preferred dividend rate of 4.5%, par value = $100); and 105,000...

4. It has been said that net neutrality is the most important issue facing the Internet since the advent of the Internet. Discuss the implications of this statement. What kind of Internet user are...

Youll advertise your position in the local newspaper(s), with area post-secondary schools, in newsletters circulated to members of the Professional Womens Network (see Part 5 feature) and similar...

The career fair was a very positive experience. Prepare the text of an e-mail thanking Sarah for suggesting you attend (sking09@redriver.edu).