Hi guys i make erd diagram to payroll as following according to my requirments
Are this diagram is ok true and logical
and how to collect allowance and deduction in payroll table by sql query
which query can select allowance and deductions in payroll table
please help me