sql which related to the database programming model

1. Write a program to display all EName and their Name from the Emp_yourld and Dept_Youri table using cursor with simple loop. Calculate and Display house allowances given to the employees as per the given conditions. [5.5 Marks) Department House Allowances IT 5% of salary HR 6% of salary BUS 10% of salary 2. Write a program using a cursor with while loop to update the salary of employees in Emp_YourID table, as per the Department Number. [6.5 Marks) Department Number Increase of salary 10 300 200 12 250 11 Display the Name, Salary of all employees who are working in Dept No 12 only. 3. Write a Program that will allow the user to enter Employee Id and will display the Employee Name using Emp_Yourld table. Include proper named exceptions if query returns more than one rows and if employee record is not available in the table. 14 Marks) 4. Write a program to display the Employee Name of the employee who is earning maximum salary in the given department number using the Emp_Your table. Use your programming skills to enter the department number from the keyboard, using the given tables. Include a user-defined exception handler that handles the condition where value of department Number is more than 200 is not allowed, it should displays the message as 'Number is out of range'. [4 Marks)