Title: Payroll System Database Design

Description:

Automated Payroll system is an application that will manage and compute the employee’s salary. It connects information throughout the entire company. It is the easiest way to cater these needs. Computerize systems is typically simplify information, Quickly organize reports, automatically archive data, calculate deductions, easily track clock in/out and minimize manual efforts.

Pay slip is a slip of paper of an employee receives either as a notices, it will typically details the gross income and all taxes, and any other deductions such as retirement plan contributions, insurances contributions taken out of gross income to arrive at the final amount of the pay, including the year to date totals of all deductions of your salary in for circumstances.

Additional features of the system are the Backup and Restore utility which enables the users of the application to Backup and Restore the database

Database Schema with description of table:

tblaccount (id, username, password, accounttype)

tblemployee (id, barcode, lastname, firstname, middlename, dateofbirth, address, contact, status, positionid)

tblposition (id, positionname, dailyrate, monthlyrate, workingdayspermonth)

tblpayroll (id, employeeid, numofdayswork, bonus, overtimepay, grosssalary, cashadvance, latehours, absentdays, ssscontribution, philhealth, totaldeduction, netpay, payrollmonth, accountid)

Table Relationship:

Sample Queries:

The query below will display the list of employees together with their position, monthly salary, total deduction and net salary.

SELECT tblemployee.barcode, tblemployee.lastname, tblemployee.firstname, tblposition.PositionName, tblposition.monthlyrate, tblpayroll.grosssalary, tblpayroll.totaldeduction, tblpayroll.netpay

FROM tblposition INNER JOIN (tblemployee INNER JOIN (tblaccount INNER JOIN tblpayroll ON tblaccount.id = tblpayroll.accountid) ON tblemployee.id = tblpayroll.emplooyeeid) ON tblposition.id = tblemployee.positionid

GROUP BY tblemployee.barcode, tblemployee.lastname, tblemployee.firstname, tblposition.PositionName, tblposition.monthlyrate, tblpayroll.grosssalary, tblpayroll.totaldeduction, tblpayroll.netpay;

Development Tools:

Visual Basic and MySQL

References:

https://www.inettutor.com/download/payroll-system-in-visual-basic-and-ms-access-complete-source-code/

https://www.inettutor.com/source-code/automated-payroll-system-thesis-project-with-complete-source-code/

https://www.inettutor.com/source-code/payroll-system-in-visual-basic-6-0/

you can leave your comments, suggestions and questions on the comment box below or you may visit our facebook page.

https://www.inettutor.com/