Write a script that creates and calls a stored procedure named spUpdateInstructor that updates the AnnualSalary column in the Instructors table. This procedure should have one parameter for the instructor ID and another for the annual salary.If the value for the AnnualSalary column is a negative number, the stored procedure should raise an error that indicates that the value for this column must be a positive number.Code at least two EXEC statements that test this procedure.

Insert part: Different vendors provide different functions for raising an error like mysql has "signal sqlstate("message");" and oracle SQL has "raiseerror('message', 18,1);". And table scheme was not given so I assumed the types of columns In the table Instructors, change if they are different from mine. Insert: -- different vendors have different ways to raise an error in my system is was raiseerror -- yours may be same or try "signal sqlstate('message')" -- Insert procedure create procedure spInsertInstructor( @LastName varchar(20), @FirstName varchar(20), @Status varchar(10), @DepartmentChairmen varchar(30), @AnnualSalary INT @DepartmentID INT ) as begin if (@AnnualSalary < 0) raiseerror('Annual salary does not accept negative values', 18, 1) return end if insert into Instructors(LastName, FirstName, Status, DepartmentChairmen, AnnualSalary, DepartmentID, ) values (@LastName, @FirstName, @Status, @DepartmentChairmen, @AnnualSalary, @DepartmentID); end -- testing -- should success exec spInsertInstructor @LastName = 'Washington', @FirstName = 'George', @Status = 'Working', @DepartmentChairmen = 'Newton', @AnnualSalary = 10021, @DepartmentID = 101; -- should fail exec spInsertInstructor@LastName = 'Washington', @FirstName = 'George', @Status = 'Working', @DepartmentChairmen = 'Newton', @AnnualSalary = -10021, @DepartmentID = 101;Update -- procedure for updateing create procedure spUpdateInstructor( @InstructorID INT @AnnualSalary INT ) as begin if (@AnnualSalary < 0) raiseerror('Annual salary does not accept negative values', 18, 1) return end if update Instructors set AnnualSalary = @AnnualSalary WHERE InstructorID = @InstructorID end -- TESTing update values according to you -- to test for instructors already in tables exec spUpdateInstructor @InstructorID = 1001, @AnnualSalary = 10202; -- This should fail exec spUpdateInstructor @InstructorID = 1001, @AnnualSalary = -111;