This tutorial about “Managing SSS Contribution Logic for Payroll System”. The usual algorithm for this kind of module would be the IF ELSE statement or the CASE and the like. We try to set the range conditioning and give a particular value to the result. However, our solution would be one module for the system … Read more
Before we begin with our management to SSS Contribution in our payroll system, it is important to guide us on what are the step by step guide on using the SSS Contribution Table and know how much should be deducted from your monthly salary as SSS contribution. Step 1. Simply look for the row in … Read more
This tutorial about Delete Statement Using Visual Basic Application for managing payroll system module. As database practice, it is important that all records are intact and can be recovered for query purposes at all times. But for the purpose of academic requirement and for testing our application for the delete statement, we will be learning … Read more
The principles covering information standards covers the accuracy of personal data. The Data Protection Act imposes obligations to ensure the accuracy of the personal data you process. It must also be kept up to date where necessary. This requirement is closely linked with the requirement under our Payroll System specifically on the management of Employee … Read more
Insert Statement using Visual Basic Application for Managing Payroll System Module In our previous lesson we define the module for Managing Payroll System for SQL statement Insert, Update and Delete. We will now proceed with our application in Visual Basic. Our task here is to be able to add new employee, update its information and … Read more
MySQL Insert, Update, Delete Statement for Managing Payroll System Module In our previous tutorials entitled “106 – MySQL Query Select Statement for Managing Payroll System Module“, if you are following, we started with SELECT statement in SQL which is followed by a unique set of rules and guidelines called Syntax. All the SQL statements start with … Read more
The MySQL Query Select Statement returns a result set of records from one or more tables. A select statement retrieves zero or more rows from one or more database tables or database views. In most applications, SELECT is the most commonly used data manipulation language (DML) command. MySQL Query Select Statement In our case, our … Read more
