Question

Entity Type Attributes Employer Name, Phone, Email, Address Employee Emp_ID, Email, Phone, Designation, Experience (derived) Basic_Salary Salary_Id, Amount Salary_Allowances Allowances_id, Emp_id, Amount,, annual_increment Deduction_Amount Deduction_id, Emp_id, Amount Net_Salary Emp_id, Date, Amount Primary Key Name Emp_ID Salary_id Allowances_id, Emp_id Deduction_id, Emp_id Emp_id Cardinality Ratio Participation constraint Participating Entities Relationship Type (1:1, 1:N, M:N) Entity 1 From Entity 1 (total, partial) Entity 1 Entity Entity 2 TO Entity 2 side 2 side Pays_salary Employer Employee 1:N Total Total Have_employees Employer Employee 1:N Total Total Receives_allowance Employee Salary_Allowance M:N Total Total Deduction Basic_Salary Deduction Amount M:N Total Total Net_after_deduction Deduction_Amount Net_Salary M:N Partial Partial Salary_increment Net_Salary Salary_Allowance M:N Partial Partial Receives Employee Net_Salary M:N Total Total

          Entity Type
Attributes
Employer
Name, Phone, Email, Address
Employee
Emp_ID, Email, Phone, Designation, Experience
(derived)
Basic_Salary
Salary_Id, Amount
Salary_Allowances Allowances_id, Emp_id, Amount,, annual_increment
Deduction_Amount Deduction_id, Emp_id, Amount
Net_Salary
Emp_id, Date, Amount
Primary Key
Name
Emp_ID
Salary_id
Allowances_id,
Emp_id
Deduction_id, Emp_id
Emp_id
Cardinality
Ratio
Participation
constraint
Participating Entities
Relationship Type
(1:1, 1:N, M:N)
Entity 1
From Entity 1
(total, partial)
Entity 1 Entity
Entity 2
TO Entity 2
side
2 side
Pays_salary
Employer
Employee
1:N
Total
Total
Have_employees Employer
Employee
1:N
Total
Total
Receives_allowance Employee
Salary_Allowance
M:N
Total
Total
Deduction
Basic_Salary
Deduction Amount M:N
Total
Total
Net_after_deduction Deduction_Amount Net_Salary
M:N
Partial
Partial
Salary_increment Net_Salary
Salary_Allowance M:N
Partial Partial
Receives
Employee
Net_Salary
M:N
Total
Total

Entity Type
Attributes
Employer
Name, Phone, Email, Address
Employee
EmpID, Email, Phone, Designation, Experience
(derived)
BasicSalary
SalaryId, Amount
SalaryAllowances Allowancesid, Empid, Amount,, annualincrement
DeductionAmount Deductionid, Empid, Amount
NetSalary
Empid, Date, Amount
Primary Key
Name
EmpID
Salaryid
Allowancesid,
Empid
Deductionid, Empid
Empid
Cardinality
Ratio
Participation
constraint
Participating Entities
Relationship Type
(1:1, 1:N, M:N)
Entity 1
From Entity 1
(total, partial)
Entity 1 Entity
Entity 2
TO Entity 2
side
2 side
Payssalary
Employer
Employee
1:N
Total
Total
Haveemployees Employer
Employee
1:N
Total
Total
Receivesallowance Employee
SalaryAllowance
M:N
Total
Total
Deduction
BasicSalary
Deduction Amount M:N
Total
Total
Netafterdeduction DeductionAmount NetSalary
M:N
Partial
Partial
Salaryincrement NetSalary
SalaryAllowance M:N
Partial Partial
Receives
Employee
NetSalary
M:N
Total
Total

Added by Vicente H.

Question

Please give Ace some feedback