Project #29014 - SQL

 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

employee.

5. Choose a job_title_code from the job_title table; delete this

job_title_code.

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.

Subject Computer
Due By (Pacific Time) 04/28/2014 01:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy