1. Write a program to display all EName and their DName from the Emp_yourld and Dept_YourID...

 

Transcribed Image Text:

1. Write a program to display all EName and their DName from the Emp_yourld and Dept_YourID table using cursor with simple loop. Calculate and Display house allowances given to the employees as per the given conditions. [5.5 Marks] Department IT HR BUS House Allowances 5% of salary 6% of salary 10% of salary 2. Write a program using a cursor with while loop to update the salary of employees in Emp_YourlD table, as per the Department Number. [6.5 Marks] Department Number 10 11 12 Increase of salary 300 200 250 Display the EName, 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. [4 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_YourID 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] 1. Write a program to display all EName and their DName from the Emp_yourld and Dept_YourID table using cursor with simple loop. Calculate and Display house allowances given to the employees as per the given conditions. [5.5 Marks] Department IT HR BUS House Allowances 5% of salary 6% of salary 10% of salary 2. Write a program using a cursor with while loop to update the salary of employees in Emp_YourlD table, as per the Department Number. [6.5 Marks] Department Number 10 11 12 Increase of salary 300 200 250 Display the EName, 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. [4 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_YourID 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]

Answer rating: 100% (QA)

Solution 1 Program to display all EName and the DName from EmpyourID and DeptYourId table DECLARE CU... View the full answer