Find the names and addresses of employees

Assignment Help Database Management System

Reference no: EM133089340

Question 1: Specify the following queries on the database schema shown in attached Figure using the relational algebra discussed in class. This is not asking you to write SQL queries.

1. Retrieve the names of employees who work on the ‘Newbenefits' project.

2. Find the names of employees that works for ‘Administration' department

3. Retrieve the names of department managers who do not work on any project. (You may assume if Hours in works_on is always positive. An employee does not work on any project if his/her ssn is not in works_on)

4. Find the names and addresses of employees who work on at least one project located in Stafford.

5. List the last names of female employees who have no dependents.

6. Find the average salary of all female employees who works for ‘Administration' department

7. For each department, list the department name and the total number of project controlled by the department.

8. Retrieve the names of employees who work on every project controlled by department 5

9. For each employee, retrieve employee's name, and the total hours working in projects

Attachment:- database schema.rar

Reference no: EM133089340

Questions Cloud

What is the cost of the marginal cash discount : The firm expects that the change in credit terms will result in a minor increase in sales of 10 films per year, What is the cost of the marginal cash discount

Discuss the limitations of management information : Accounting for Management - Discuss the limitations of management information in providing guidance for managerial decision-making

Integrated social media : More and more businesses have integrated social media into every aspect of their communication strategies

Discuss ge management systems and performance : Why was GE considered to be such an exemplary organization? (Discuss GE's management systems and performance.)

Find the names and addresses of employees : Find the names and addresses of employees who work on at least one project located in Stafford and List the last names of female employees who have no dependent

Prepare a material purchases budget in units : Each unit produced requires 1kg of raw material at a cost of $6 per kg. Prepare a Material Purchases Budget in units and dollars

Authentic leadership : Identify elements of authentic leadership. Describe the behavioral elements that one might objectively see in an authentic leader.

Negative organizational performance : How do you think the change process of AMD contributed to negative organizational performance?

Analyze methods to convert resources : Analyze methods to convert resources into goods and services.

User Account

All Pages