What relation of (income and Deduction) and payroll table

Posted by Ahmedsa under Sql Server on 12/4/2014 | Points: 10 | Views : 425 | Status : [Member] | Replies : 0
Alert me | Edit | Change type
Question
You cannot vote on your own post
0
I already make payroll database i have all tables but one relation in this database i don't know how to make relation

between payroll table and deduction and income

Employee Table

Employee ID

Name

Address

Nationality

Salary Table(1 to 1 Employee Table)

Salary ID

Employee ID

Salary

Income Table(N to 1 Employee Table)

Income ID

Employee ID

Bonus

Over Time

From Date

To Date

Deduction Table ( N to 1 Employee Table)

Deduction ID

EmployeeID

Deduction

From Date

To Date

Payroll Table(I don't know Relation)

And this is my question how to collect Deduction and income from two tables

and make relation to Payroll table

Meaning what relation between Payroll and( Deduction And Income)

How to collect two foreign key of income and Deduction in Payroll Table

Are relation one to many or what




Responses

(No response found.)

Login to post response