I need only form payroll which tables i will using

[ahm1985]

I work in sql server 2005 and c#.net 2005 i need to create payroll form to every worker.
Now i make employee card and employee Table
after this which tables needed to create payroll systems
can you help me
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
What structures of tables for this

 

[simian336]

That is a good question, how were you thinking of setting it up?

Simi

 

[ahm1985]

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

 

[tcsbiz]

It all depends on the payroll system you are using. Are you asking us to design a payroll system for you?

Tom

 

[fredericofonseca]

looks and smells like homework...

Any way.. look at the business requirements that you would have been supplied with by someone working on your project - it should state how those things are related and calculated.
If you don't have the business requirements then you have a bigger problem - and should solve that one before even asking how tables relate to each other

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[ahm1985]

My question is
How to collect all data found in tables above to transaction table(payroll table)
bussines requirment not different from payroll to payroll in another company
requirments fixed in all payroll
different only in taxes
this is depend on the country