Framework for Client-Server Distributed Database System for an Integrated Pay Roll System

Abstract

A pay roll is a list of companies’ employees and the amount of money that they are to be paid at the end of each work schedule, hourly, weekly or monthly. In a company, pay roll is the sum of all financial records of salaries of an employee, wages, bonuses and deductions.A nominal roll is a list containing employee details in a particular organization. An integrated pay roll system is an automated (computer based) pay roll system where individual autonomous pay roll system of an organizations are networked together to form a distributed pay roll system. This is initiated to ease pay roll transaction processing, improve transparency in pay roll processing and to reduce duplication of pay roll processing functions.The research work is to create a distributed pay roll system for local government areas in Bayelsa Sate. The system consists of a relational database of pay roll variables which could be shared by the various Local Government Areas of Bayelsa State. Each LGA will form a site. The database will be hosted by the server at the local government Service Commission office. All LGAs will access the database via a distributed network. The client/server distributed network architecture is used in the design and implementation of the system. The system is capable of monitoring an employee’s nominal roll and pay roll records from the day of resumption of duty to the day of retirement, detection of an employee working in more than one local government, generation of reports concerning an employee or set of employees for promotion, demotion or retirement as the case may be, and automatic monthly pay roll computation.