Payroll System Database Design Using MySQL

After we have developed the application design or the user interfaces for our Payroll System, we will now proceed to our Payroll System Database Design Using MySQL with XAMPP 1.7.4 Server Application.

I assume that you are already familiar with the database definition and how to design it in accordance with the system you are developing.  To begin here are the name and  the details of the table:

Steps for building Payroll System Database Design

Database Name: PayrollDatabase

Table Name: tblEmployee

Please follow the image below for the fields and data type.

The purpose of this table is to store employee information.

Table Name : tblEmployeePosition

The purpose of this table is to enroll the employee in the position list so that, a particular employee will have its basic pay and status upon hiring.

Table Name : tblPagibig

Pag–IBIG is an acronym which stands for “Pagtutulungan sa Kinabukasan: Ikaw, Bangko, Industria at Gobyerno”. To this day, the Pag–IBIG Fund continues to harness these four sectors of the society to work together towards providing Fund members with adequate housing through an effective savings scheme.

The purpose of this table is to control the Pag-ibig Contribution design by the Pag-ibig agency. I will also be posting the Pag-ibig table contributions in accordance with the law.

Table Name : tblphilhealth

The Philippine Health Insurance Corporation (PhilHealth) was created in 1995 to implement universal health coverage in the Philippines. It is a tax-exempt, government-owned and government-controlled corporation (GOCC) of the Philippines, and is attached to the Department of Health.

The purpose of this table is to control the PhilHealth Contribution design by the Pag-ibig agency. I will also be posting the PhilHealth table contributions in accordance to the law.

Table Name : tblphilhealth

The appropriate SSS contribution corresponds to the Range of Compensation category where your monthly salary belongs. Social Security – EE means Employee contribution; basically the amount of your own SSS contribution. The EC contribution is solely paid for by the employer.

The purpose of this table is to control the SSS Contribution design by the SSS agency. I will also be posting the SSS table contributions in accordance to the law.

Table Name : tblemployeeexpenses

Payroll is the sum total of all compensation a business must pay to its employees for a set period of time or on a given date. It is usually managed by the accounting department of a business; small-business payrolls may be handled directly by the owner or an associate.

This is where we store our payroll record upon posting. It will be recorded in accordance with the period of payroll.

GO back to our Previous Topic: 102 – Graphical User Interface Using VB.Net for Payroll System

Move to our Next Topic: 104 – Payroll System Managing Employee Information