How to design database tables for payroll

Question

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

ahmed sa · Answer

what is the relation between deduction table and salary table if possible help me

ahmed sa · Answer

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 kris · Answer

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.