| Column No. | Column Type |
| Emp no | Varchar2 |
| Emp name | Varchar2 |
| hiredate | Date |
| Dept | Varchar2 |
| Desig | Varchar2 |
| Salary | Number |
| Hra | Number |
| Da | Number |
| Pf | Number |
| Tax | Number |
| Ma | Number |
| Net salary | Number |
1. Dept. should be MKT, ADM, SALES.
2. Desig. Should be EXE, ACC, MGR, CLK.
3. Calculate the hra as per the following condition.
a. HRA CONDITION. (AS PER DESIG.)
6% of salary MGR
4.5% of salary EXE
3% of salary ACC
1.5% of salary CLK
4. Calculate the da as per the following condition ( % of Basic).
| Desig | | | | |
| Dept | ||||
| MKT | 49% | 47% | 45% | 43% |
| ADM | 47% | 45% | 43% | 41% |
| SALES | 45% | 43% | 41% | 39% |
5. Calculate the pf as per the following condition.
PF CONDITION (AS PER DEPT)
3.5% of salary MKT
2.5% of salary ADM
1.5% of salary SALES
6. Calculate the tax as per the following condition.
CONDITION (AS PER SALARY) Tax MA
Salary > =10000 500 350
Salary >6000 & <10000 400 250
Salary <6000 300 150
Net Salary = (salary+hra+da+ma)-(pf+tax)
No comments:
Post a Comment