Question: Use LargeCO tables to complete this assignment. Complete one of the following assignment option groups. Option Group 1 - note that these problems are different;

 Use LargeCO tables to complete this assignment. Complete one of the

Use LargeCO tables to complete this assignment. Complete one of the following assignment option groups. Option Group 1 - note that these problems are different; you will need to write two completely different pieces of code. Problem 1. Write a stored procedure that adds a new employee to Igemployee table. Pass the field values to the procedure as parameters. Problem 2. Use parameters and a DECLARE statement to display employees that were hired in every decade beginning 1970. The program should return the statements similar to this example (you will NOT get the exact same numbers) 12 employees were hired between 1970 and 1980 19 employes were hired between 1980 and 1990 etc. Option Group 2 Problem 1. Write a cursor to print a report for each employee's salary history. Display employee's number, last and first name, and the salary with the starting date Problem 2. Modify the previous problem code to make it a stored procedure that accepts employee's last name as a parameter. Note the cursor assignment in Group 2 is a challenge, but it is very similar to the cursor example posted in this folder

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!