Computers And SQL

Write SQL DML statements that address the following requirements:    Update the Employees table and give all employees making less than $10 per hour a 5% increase.    List all records/fields in the EMPLOYEES table in order of the employee’s last name.    List all records/fields in the EMPLOYEES table in order of the department name.    List employee names, hourly pay rate and department name for employees making between (and including) $10 and $30 per hour.    What is the total organization payroll assuming each employee works 40 hours per week? Using the tables you created in Unit 2’s project database (excluding the Employees and Departments tables), create one or more SQL queries to demonstrate your understanding of the following concepts:    WHERE clause using comparison operators    ORDER BY clause    JOINS    Aggregation

 

Hint: The assignment refers to the “Department Name”. That field is stored in the Departments table. A join is needed.

Deliverable: One Word document with at least nine queries. For each query include:    SQL in text format (not a screen shot)    Screen shots of SQL results

  

NEED A WORD DOCUMENT AND THE .ACCDB FILE

  (Word document and .accdb file) 

MUST USE THE TEMPLATE!!!!

Hint: The assignment refers to the “Department Name”. That field is stored in the Departments table. A join is needed. {Your Name}

ITCO333 – Unit 4

{date}

Note: Unit 2’s assignment provided the specifications for the EMPLOYEES and DEPARTMENTS tables.

Update the Employees table and give all employees making less than $10 per hour a 5% increase.

1. Paste SQL as text

2. Include a screen shot of SQL

3. Include a screen shot of the results (there must be some results).

List all records/fields in the EMPLOYEES table in order of the employee’s last name.
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).

List all records/fields in the EMPLOYEES table in order of the department name.

Note: Department name is not in the Employees table.

1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).

List employee names, hourly pay rate and department name for employees making between (and including) $10 and $30 per hour.
Note: Department name is not in the Employees table.
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).

What is the total organization payroll assuming each employee works 40 hours per week?

Note: Do not permanently change the data in your tables to arrive at the answer.

1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).

EXAMPLE: WHERE clause using comparison operators
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).

EXAMPLE: ORDER BY clause
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).

EXAMPLE: JOINS
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).

EXAMPLE: Aggregation
1. Paste SQL as text
2. Include a screen shot of SQL
3. Include a screen shot of the results (there must be some results).

Page 2 of 9