Design and Implementation of a Responsive Secure Payroll System for A Chain Supermarket

TABLE OF CONTENTS

DECLARATION

APPROVAL H

DEDICATION iii

ACKNOWLEDGEMENT iv

ABSTRACT V

TABLE OF CONTENTS Vi

LIST OF ACRONYMS ix

TABLE OF FIGURES X

LIST OF TABLES xi

CHAPTER ONE I

INTRODUCTION

1.1 Background to the Study I

1.2 Problem Statement 2

1.3 Main Objective 2

1.4 Specific Objectives 2

1.5 Scope of the study 2

1.6 Significance of the study 3

CHAPTER TWO 4

LITERATURE REVIEW 4

2. I MEANING AND PURPOSE OF PAYROLL 4

2.1.1 Computation of Payroll Earnings 5

2.1.2 THE PAYROLL PROCESS 6

2.1.3 METHODS OF PAYING EMPLOYEES 7

2.2 COMPUTERIZED PAYROLL SYSTEM 7

2.2.1 Functions of a Computerized Payroll 8

2,2.2 The Advantages of a Computerized Payroll System 8

2.2.3 Controls for a Computerized Payroll System 9

2.3 PAYROLL REPORTS 10

vi

2.4 REVIEW OF THE EXISTING SYSTEM .11

2.5 Comparison between a manual payroll system and a computerized payroll system 12

CHAPTERTHREE 13

METHODOLOGY 13

3.1 Introduction 13

3.2 Interview 13

3.3 Observation 13

3.4 Data collection techniques 14

3.4.1 Primary data sources 14

3.4.2 Secondary data sources 14

3.5 Limitations of the study 14

3.6 System Development 15

3.7 System Development Environment 15

3.8 Systems Development Life Cycle (SDLC) 15

3.8.1 Advantages of Waterfall method 16

3.8.2 Disadvantages of Waterfall method 17

CHAPTER FOUR 18

SYSTEM STUDY. DESIGN & IMPLEMENTATION 18

4.1 Introduction 18

4.2 Brief review of the current system 18

4.3 Strengths and Weaknesses of the current system 18

4.3.1 Strengths 18

4.3.2 Weaknesses in the current system 18

4.4 Proposed System 18

4.4.1 Functional requirements 19

4.4.2 Non-Functional requirements 19

4.5 Hardware and software requirements 19

4.5.1 Software 19

4.5.2 Hardware 20

4.6 Organizational Requirements 20

4.7 User requirements 20

vii

4.8 Target users .20

4.8.1 Accounts 20

4.8.2 Administrator 21

4.9 SYSTEM DESIGNS 21

4.9.1 Components ofa data flow diagram 21

4.10 Database structure design 25

4.1! SYSTEM USER INTERFACES 29

CHAPTER FIVE 33

DISCUSSION, CONCLUSION AND RECOMMENDATIONS 33

5.1 Discussion 33

5.2 Conclusion 33

5.3 Recommendations 34

5.3.1 Recommendations for future work 34

REFERENCES 35

APPENDIX A; 36

INTERVIEW GUIDE 36

APPENDIX B;

PROPOSED BUDGET / TIME FRAME 37

APPENDIX C; 38

WORK PLAN AND SCHEDULE 38

ABSTRACT

This study focused at designing and implementing a computerized payroll system, which will assist in carrying out payroll transactions. The computerized payroll system helps the payroll administrators to ensure an efficient and effective management of employee’s information since the system is systematic than using the manual system. It will improve the time efficiency and provide a user friendly environment. The system design used the three-tier client server architecture to implement the inference mechanism while database component was implemented using Mysql. The user interface was implemented using Visual Basic.