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

Required(*) Message

Database Management System Questions & Answers

Describe entities and attributes that the website must track

Describe entities and attributes that the website must track.

Produce a set of relations

An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein methodology as per the study book and tutorials.

If those were for me wed keep them all in two to three

if those were for me wed keep them all in two to three minutes longer he says. but thats not my call-its the

Provide an entity relationship model

Provide an Entity Relationship Model (ERM) that will describe the data structure that will store all data elements and analyze the university's requirements and provide a proposal to organize all the required data elements.

Write a statement of work to present to wild wood management

Wild Wood Apartments owns 20 different apartment complexes in Washington, Oregon, California, and Idaho. Write a statement of work to present to the Wild Wood management

Create a tree that models of the scenario

Create a tree that models the following scenario. A player decides to play a maximum of 4 times, betting on red each time. The player will quit after losing twice. In the tree, any possible last plays will be an ending point of the tree.

Describe five olap uses of the data warehouse

Happy Cruise Lines has several ships and a variety of cruise itineraries, each involving several ports-of-call. The company wants to maintain information on the sailors who currently work on each of its ships. It also wants to keep track of both..

Prepare a database design specification

Understand and interpret a set of business rules for a database and create an Enhanced Entity Relationship Diagram that models the requirements accurately

What is the two-phase locking protocol

What is the two-phase locking protocol? How does it guarantee serializability and describe the wait-die and wound-wait protocols for deadlock prevention.

Case study-zen chiropractic clinic

Display the full details for the cheapestservices provided by ZC2 - The Case Study-Zen Chiropractic Clinic

Develop a data dictionary and create an e-r diagram

Identify the entities and relationships that are relevant for a system to manage SEAMM. Develop a data dictionary (catalogue) and create an E-R diagram.

Explain data mining write the major characteristics and

define data mining. what are the major characteristics and objectives associated with data mining? what professions

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