ahmed sa

ahmed sa

  • NA
  • 289
  • 129.1k

How to design database tables for payroll

Apr 30 2014 1:15 AM
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
What i need entity for payroll and relations
what i do until now
employee
addition
deduction
attendance
My question is
what is the relation between attendance and deduction
and which table will give me final transactions
meaning table that store result of final salary
please help me


Answers (3)