How i make ERD Diagram for payroll salary for employees

ahmedbaahmedba Member Posts: 424
edited 2014-04-28 in SQL General
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
Sign In or Register to comment.