Using the database and tables from lab 2,
write queries using the SQL UPDATE statement.
1. Choose a job_title_code. Increase all employees’ salaries
that have that job_title_code by 10%.
2. Choose a job_title_code. Increase the Minimum_salary and
Maximum_salary for this job_title_code in the job_title table.
3. Increase all employees’ salaries by 5%
4. Choose an employee from the employee table; delete this
5. Choose a job_title_code from the job_title table; delete this
a. Describe any differences you found between
deleting a row from the employee table and deleting
a row from the job_title table.
6. Calculate the average salary for all employees.
7. Calculate the maximum salary for exempt employees
and the maximum salary for non-exempt employees.
8. Calculate the maximum salary for all employees
9. Calculate the minimum salary for all employees.
10. Create a stored procedure that does the following:
a. Accepts one parameter (job_title_code)
b. Based on the job_title_code passed into the
procedure, return the job_title_code, job title, and
the maximum salary for that job_title_code.
11. Create a view named "EmployeeSalary" and include the
following fields from both the Employee and Job_title tables:
employee first name, employee last name, employee salary,
job_title, minimum salary, and maximum salary.
Include all SQL statements and results for each task in your
assignment post. Submit a Microsoft Word document (using the
template attached to the lab post) including these statements and
named. Do not include screenshots,
rather include the SQL scripts in the Word document. Label each
script with the number of the query and use the order in which each
query is listed in the assignment.
|Due By (Pacific Time)||04/28/2014 01:00 pm|
out of 1971 reviews
out of 766 reviews
out of 1164 reviews
out of 721 reviews
out of 1600 reviews
out of 770 reviews
out of 766 reviews
out of 680 reviews