Access over 20 million homework & study documents

search

pos410_week4ind

Type

Homework

Rating

Showing Page:
1/6
POS 410 Week 4
Building off of the week 3 assignment – this week it is asked to utilize the tables built in
week 3 and run queries against them as well as utilize some update techniques.It is
also required that the results of each query be turned in as well. The below is a tutorial
on the queries for this assignment.
Use the database and tables from last week’s assignment to write SQL queries
using the SQL SELECT statement.
Note. Select all data from both tables before you perform the following:
o Increase all employees’ salaries with the selected EEO-1 classification by 10
percent.
o Increase all employees’ salaries by 5 percent.
o Choose an employee from the Employee table and delete that employee.
Print out the SQL statements and data from both tables to show how data was
affected. Be prepared to demonstrate your results in class.
Use the database and tables from last week’s assignment to write SQL
statements that do the following:
o Calculate the average salary for all employees.
o Calculate the maximum salaries for exempt and non-exempt employees.
o Calculate the maximum salary for all employees.
o Calculate the minimum salaries for exempt and non-exempt employees.
o Calculate the minimum salary for all employees.

Sign up to view the full document!

lock_open Sign Up
Select all data from both tables before you perform the following would possible look
like the following – the results of these queries should be placed in a sql file or in an
excel file.
SELECT [emp_id]
,[last_name]
,[first_name]
,[address]
,[city]
,[state]
,[telephone_area_code]
,[telephone_number]
,[eeo1_classification]
,[hire_date]
,[salary]
,[gender]
,[age]
,[job_title_id]
FROM [kff_db].[dbo].[Employee]
SELECT [job_title_id]
,[eeo1_classification]
,[job_title]
,[job_description]
,[exempt_status]
FROM [kff_db].[dbo].[job_title]

Sign up to view the full document!

lock_open Sign Up
Increase all employees’ salaries with the selected EEO-1 classification by 10 percent.
This would look like the following where the update is used to set the salary then multiply it by
10% for those with the desired eeo1_classification which in this case is Workers.
update Employee
set salary = salary * 1.10
where eeo1_classification = 'Workers';
Increase all employees’ salaries by 5 percent. This is done with an update statement
setting the salary field to be multiplied by 1.05.
update Employee
set salary = salary * 1.05;
Choose an employee from the Employee table and delete that employee. This is done
with a simple delete statement selecting the desired employee row which in this case is
the row whose emp_id is 1.
delete from Employee where emp_id = 1

Sign up to view the full document!

lock_open Sign Up

Unformatted Attachment Preview

POS 410 Week 4 Building off of the week 3 assignment - this week it is asked to utilize the tables built in week 3 and run queries against them as well as utilize some update techniques.It is also required that the results of each query be turned in as well. The below is a tutorial on the queries for this assignment.Use the database and tables from last week's assignment to write SQL queries using the SQL SELECT statement.Note. Select all data from both tables before you perform the following:Increase all employees' salaries with the selected EEO-1 classification by 10 percent. Increase all employees' salaries by 5 percent.Choose an employee from the Employee table and delete that employee.Print out the SQL statements and data from both tables to show how data was affected. Be prepared to demonstrate your results in class.Use the database and tables from last week's assignment to write SQL statements that do the following:Calculate the average salary for all employees. Calculate the maximum salaries for exempt and non-exempt employees.Calculate the maximum salary for all employees.Calculate the minimum salaries for exempt and non-exempt employees.Calculate the minimum salary for all employees.Select all data from both tables before you perform the following would possible look like the following - the results of these queries should be placed in a sql file or in an excel file.SELECT [emp_id] ,[last_name] ,[first_name] ,[address] ,[ci ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4