摘要:Problem statement: This research had done the software design and database system model for Payroll Management System (PMS) in Defense Institute of Physiology and Allied Sciences (DIPAS). The calculations are based on the user provided employees details like basic pay, house rent allowance, loan details and so on. Based on these user inputs the system automatically generates pay slip, pay bills, all schedules for debit and credit payments. This system is developed in such a way to suit for both new and old pension schemes of the central government employees of India. The use of Java Server Pages (JSP) language for system development allows easy modification of the system design. So the system design can be directly implemented to any other central government organization with slight modifications. Approach: This study presented the database and software design for PMS. The software changes the manual operation into a computer-based system to automate study, provide efficiency, accuracy, timelessness, security and economy. Results: After undertaking an in-depth examination of the existing manual payroll management system and analyzing its short comings, it has been found necessary to remove its deficiencies and provide a suitable solution for presently encountered problem. Conclusion: The proposed system can help the organization to manage efficiently the employee pay related data as personal information, salary information, loan information and so on.
关键词:Payroll Management Software (PMS); New Pension Scheme (NPS); JSP; database; Structured Query Language (SQL)