Add allowance to employee table is wrong or true according to my case

Posted by Ahmedsa under Sql Server on 2/12/2015 | Points: 10 | Views : 1010 | Status : [Member] | Replies : 0
Hi guys I have problem i need to make erd relation entity between employee and allowance Employee table Name address Basic Salary Bonus

Allowance table House rent Food Allowance Moving Allowance

Basic Salary is monthly and fixed Bonus is monthly and fixed food allowance is monthly and fixed for married employee House rent is monthly and fixed for some employee and some employee take house rent two time in year every 6 month every employee married take 3 months salary from basic salary in year suppose i m married and i take basic salary 5000 i will take rent 5000 x 3=15000/12=1250 monthly some employee take rent every half year meaning every 6 month meaning 15000/2=7500

My question according to my case above Which is best put allowance in table allowance or put allowance(food,housing,moving) in employee table and what relation between two tables


(No response found.)

Login to post response