List the name of employee and total hours

List the name of employee and total hours

Assignment Help Database Management System

Reference no: EM13899534

1 List the name of employee and total hours he works on the project (use outer join so that employees who don't work on project will be also listed withzero project count )

2 List the name of project that ‘chen’ does not work on (request: must use NOT EXISTS)

3. List the total number of projects whose budget is above the average project budget.

4. List the name of project that has more than two employee working on it

5. List the name of the division that has more than 2 employees who work on project.

6. List the name of the managers who do not work on any projects. (note, the manager is the employee whose ID is in division table)

7. List the name of project and the name of its sponsoring division that has more budget average budget of projects.

8. List the name(s) of employees who is/are working on some project(s) but not on the project "Web development"

9. List the name of division whose average salary is higher than company's average salary

10 List the name of the division that has at least one employee who works on a project that has budget over 4000 (use subquery)

11. List the name of project whose budget is higher than project “security system”.

12 List the name of the employee whose salary is below the company average but the total working hours of project is over 100 (subquery)

1 List the name of employee and total hours he works on the project (use outer join so that employees who don't work on project will be also listed withzero project count )

2 List the name of project that 'chen' does not work on (request: must use NOT EXISTS)

3. List the total number of projects whose budget is above the average project budget.

4. List the name of project that has more than two employee working on it

5. List the name of the division that has more than 2 employees who work on project.

6. List the name of the managers who do not work on any projects. (note, the manager is the employee whose ID is in division table)

7. List the name of project and the name of its sponsoring division that has more budget average budget of projects.

8. List the name(s) of employees who is/are working on some project(s) but not on the project "Web development"

9. List the name of division whose average salary is higher than company's average salary

10 List the name of the division that has at least one employee who works on a project that has budget over 4000 (use subquery)

11. List the name of project whose budget is higher than project "security system".

12 List the name of the employee whose salary is below the company average but the total working hours of project is over 100 (subquery)

Reference no: EM13899534

Questions Cloud

What is the difference from an associated array verses : What is the difference from an Associated array verses a Varray.

An electronic logic gate whose output is logic 0 : An electronic logic gate whose output is logic 0 only when all inputs are logic 1

Each member in the club is assigned a number : Expand the database design you created in Question #1 so that it will also support the following situation: Ray wants to start a DVD rental program at his stores. He refers to each of his customers as "Members." Each member in the club is assigned a ..

Prepare the journal entry to record autumn company : 1.Prepare the journal entry to record Autumn Company's issuance of 63,000 shares of no par value common stock assuming the shares:

List the name of employee and total hours : 1 List the name of employee and total hours he works on the project (use outer join so that employees who don't work on project will be also listed withzero project count ) 2 List the name of project that ‘chen’ does not work on (request: must use NO..

Discuss the implications of the profitability of the company : An excerpt from the Sun Company's annual report is presented below. Calculating any profit measures deemed necessary, discuss the implications of the profitability of the company.

All businesses in the united states are sole proprietorships : all businesses in the United States are sole proprietorships

Prepare the journal entry to record zende : 1.Prepare the journal entry to record Zende Company's issuance of 75,000 shares of $ 5 par value common stock assuming the shares sell for:

Prepare a multiple-step income statement for jackrabbit inc : Prepare a multiple-step income statement for Jackrabbit Inc. from the following single-step statement. Gain on sale of equipment, Interest income and General and admin expenses.

Reviews

Write a Review

Message

Database Management System Questions & Answers

Identify the primary key of mpd

Create a SQL Select Query to pull Product_ID, Product_Description and Units_Sold for Product 85773 from the CSS.Sales table. Hint: do not use the CSS prefix in your query

Ensure the security of organizations distributed database

How can you make your database more hacker proof? How do you ensure the security of an organizations distributed database?

Why would you choose a database system instead of simply

Why would you choose a database system instead of simply storing data in operating system files? When would it make sense not to use a database system?

Transform the table into one or more tables in bcnf

Transform this table into one or more tables in BCNF. State the primary keys, candidate keys, foreign keys, and referential integrity constraints.

Make a select query with a calculated field for age

Make a select query with a calculated field for age, to list only guests between 20 and 40 years of age! Make sure to enter a range of ages in your table so you have something to display.

Implement a program to query and update the text database

Implement a program to query and update the text database for a library using a client/server model allowing multiple clients safe access to the database, and using a producer-consumer model to control the inventory of each item.

What messages are sent if not well-formed

Create new DOM documents for each of your .xml file and .xsl file. Use these to generate output to the browser.

Design and implement the database-best home real estate

you are to design and implement the database of Best Home real estate that you have modelled in assignment-1 and a series of SQL queries to reflect the business logic of it

Describe database management systems

Describe Database Management Systems and the various models - Describe how organizations use databases to make decisions

Write program to ask user to enter last name of customer

Write a program that will ask the user to enter the last names of our candidates in a class officer's president election and the number of votes received each candidate.

Analyze the business activity

Data Files needed for this Case Problem: OBrien.accdb (cont. from Tutorial 3) and Tests.bmp O'Brien Educational ServicesKaren O'Brien is using the OBrien database to track and analyze the business activity of her educational consulting company. T..

Write a program that will open a blastn

Write a program that will open a BLASTN nucleotide to nucleotide search output file, parse out specific information, and produce formatted output that will be written to STDOUT

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd