Are erd digram of payroll below is ok true or wrong

Question

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