Plz can anyone help me with a program below:
Need to check how much money the company is paying to 'smart employee' department wise.
Smart means : attendence should be good and rating should be avergae and good
compute salary such that salary is increasd bonus wise for each employee.
2000 + 20% of 2000 = 2400.
There are two files:
Name, department, attendence, rating, salary
A, HR, bad, bad, 1000
B, Sales, good, good, 3000
C, Admin,bad, average, 1500
D,Admin, bad,average, 2000
E,Contract temp, good, average, 2000
F, production, good, bad, 1500
Dep num, dept name, hike, num of employees