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
I work with sql server 2005 and visual studio 2005
I have a feeling that this is a homework assignment.
Sounds like. If you're stuck for ideas, have a look here:
http://www.databaseanswers.org/data_models/
No direct solution, just a heads up
ok thank you for reply i create four entries(tables)
1- employee(salary)
2- attendance
3- addition(bonus +overtime)
4-deductions(absence+punishment)
1-what i need is what relation between attendance
and deduction
2- payroll table that store (deduction and addition ) what the relation between payroll table and deduction table and addition table that store all these information
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.