Hi i am creating a payroll system in c# with SQL server 2016 database my question is i have no idea about this project so please seniors guide me about the database tables and how i design the database tables the customer requirement is generate monthly payroll system or half of month the loan given to employ and other deduction and have all tractions history and of each employ with ledger system.
Don't simply have HR tables, have a transactional payroll system.
A minimum of a solid schema
Worker → master data
A monthly view of payroll data, including Gross, Net, and other information, is captured in the monthly snapshot of payroll data (PayrollId, EmployeeId, Month, Year, Gross, Net, etc.).
The information on a loan is stored in the table advances/loans called Loan.
All cuts are Foreign Keys to the PayrollId field in all cuts.
LedgerId (PK) and EmployeeId (FK) are the two keys of the system of records.The keys of the record system are: EmployeeId (FK) and LedgerId (PK).
A basic SQL rule: The money moving on the ledger will always be the correct amount.
All activities are stored on Ledger for audit, reporting and reconciliation purposes as Payroll, Loan and Deduction are just "business tables".