How i make ERD Diagram for payroll salary for employees

Posted by Ahmedsa under Sql Server on 4/28/2014 | Points: 10 | Views : 2085 | Status : [Member] | Replies : 1
Hi guys i want to make database for payroll only but i dont know how to make structure for this
suppose i want to calculate payroll every month for employees as following
basic salary
bonus
overtime
absence
deduction
meaning
salary = basic salary +bonus+overtime-absence-deduction
How i make database (ERD)Diagram for this
Meaning tables i need and relations




Responses

Posted by: Vuyiswamb on: 5/6/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
This should be a good start

http://auciello.tripod.com/ac01.html



Thank you for posting at Dotnetfunda
[Administrator]

Ahmedsa, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response