Question

In DBMS Write a procedure to update the PF column of any employee on table Wipro (EMP_ID, NAME, GROSS_SALARY, PF) based on SALARY. If SALARY <15000 then PF is 12%, SALARY >=15000 and <45000 - PF is 15%, otherwise 20%, using if else end if and case.

Answer 1

Answer:

The employer's contribution to the EPF scheme is 10% or 12%. The contribution made by the employer is 10% in case the number of employees working for the organisation is less than 20. However, the employer's contribution is split among EPF, Employees' Pension Scheme (EPS), and Employee Deposit Linked Insurance (EDLI).