Table Design for payroll management.

Question

I am creating a new Payroll project where in i just started to design the database. But right now i am struck in loans table. I have no idea how to design tables for salaryloansadvances for an employee. If you have any references please send it.

Francis · Answer

I have no idea how to design tables for salaryloansadvances for an employee. For these kind of questions we are unable to help much. Since what you have mentioned the general terms also you are the person who knows the requirement clearly. So i would suggest you go thru requirement and try to design the table.

Shreyas Tg · Answer

I needed the database design can i get those?

Rupali Shinde · Answer

Hi Shreyas Please Refer below link for ur requirement. http://www.finance.upenn.edu/ftd/documentation/payroll_sec_4_sal_mgmt.pdf If it works out Please Accept this as Answer