Question: I need SQL-Code to the following problems. Problem 11.1 [4] Write a procedure to add an amount of Rs.1000 for the employees whose salaries is

I need SQL-Code to the following problems. Problem 11.1 [4] Write aprocedure to add an amount of Rs.1000 for the employees whose salariesI need SQL-Code to the following problems.

Problem 11.1 [4] Write a procedure to add an amount of Rs.1000 for the employees whose salaries is greater than 5000 and who belongs to the deptno passed as an argument. Problem 11.2 [4] Write a T-SQL block to update the salary of the employee with a 10% increase whose empno is to be passed as an argument for the procedure. [4] Problem 11.3 Write a function to find the salary of the employee who is working in the deptno 20 (to be passed as an argument). Problem 11.4 [3] Write a function to find the nature of job of the employee whose deptno is 20(to be passed as an argument) [3] Problem 11.5 Write a T-SQL block to obtain the department name of the employee who works for deptno 30. Problem 12.1 [6] Write a TRIGGER to ensure that DEPT TABLE does not contain duplicate of null values in DEPTNO column. Problem 12.2 [6] Write a Trigger to carry out the following action on deleting a deptno from dept table, all the records with that deptno has to be deleted from the emp table Problem 12.3 [6] Write a Trigger to carry out the following action: on deleting any records from the emp table, the same values must be inserted into the log table

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!