How to design database tables for payroll

ahmed sa

12y4.1k

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

ahmed sa12y ago
what is the relation between deduction table and salary table if possible help me
ahmed sa12y ago
ok thank for reply if i make diagram for this which tables i will need and what relation between them if possible help me
kris kris12y ago
i dont think you will have table with final salary, you can have table called "salaries" where you will store the salaries which are already payed ;] but the new salaries you will be counting based on more than one table.