An Optimised Loan Process Management System For a Cooperative Society Case Study: Kitgum Co-Operative Savings and Credit Society Ltd

ABSTRACT

An Optimized loan process management system is meant to store, update and help in the follow up of clients who are on loan program at Kitgum Cooperative Savings and Credit Society in loan department and store confidential information on them. This will also cater a newly accepted client under the department. It's in due course because of the problems incurred clue to storage of data in a paper system like; data loss, misplacement, and disclosure of confidential data to unauthorized ret1ieval, and others. It therefore calls for a security for the data by design for a computerized database systems and will generate a reports for staff.

 TABLE OF CONTENTS DECLARATION ..................................................................................................................................... i

APPROVAL ........................................................................................................................................... ii

DEDICATION ....................................................................................................................................... iii

AKNOWLEDGEMENT ......................................................................................................................... iv

ACRONYMS/ABBREVIATION ............................................................................................................ v

ABSTRACT ........................................................................................................................................... vi

TABLE OF CONTENTS ............................................................................................................................. vii

CHAPTER ONE ..................................................................................................................................... 1

INTRODUCTION ................................................................................................................................... 1

1.1 Background .................................................................................................................................... 1

1.2 Statement of Problem .................................................................................................................... 2

1.3 Objectives ...................................................................................................................................... 2

1.3.1 Main objectives .............................................................................................................................. 2

1.3.2 Specific objectives .......................................................................................................................... 2

1.4 Research Question ......................................................................................................................... 2

1.5 Scope of the study ......................................................................................................................... 3

1.6 Significance of the study ................................................................................................................ 3

CHAPTER TWO .................................................................................................................................... 4

LITERATURE REVIEW ........................................................................................................................ 4

2.0 Introduction ................................................................................................................................... 4

2.1 The Conceptual Framework ........................................................................................................... 4

2.2 Management information system .................................................................................................. 5

2.3 Information systems ...................................................................................................................... 6

2.4 Information Technology ................................................................................................................. 6 vii

2.5 Database ....................................................................................................................................... 6

2.5.1 Terminologies in database ...................................................................................................... 7

2.6 Database management system-DBMS ........................................................................................... 7

2.6.1 Function of a database management system ........................................................................... 8

2.6.2 Advantages of Database management systems ....................................................................... 8

2.6.3 Disadvantages of Database management system .................................................................... 9

Characteristics of Database management systems .................................................................................. 10

2.7 Recent Development ................................................................................................................... 10

2. 7.1 Infinity Patient Monitoring System ........................................................................................ 10

2.7.2 A&E white board patient tracking system ............................................................................... 11

CHAPTER THREE ............................................................................................................................... 12

METHODOLOGY ................................................................................................................................ 12

3.0 Introduction ................................................................................................................................. 12

3.1 Choice of the research area ......................................................................................................... 12

3.2 The overall research design of the case study .............................................................................. 12

3.2.0 Study area ................................................................................................................................... 12

3.2.1 Research method ......................................................................................................................... 12

3.2.2 Study population ........................................................................................................................... 13

3.2.3 Sampling and sampling techniques ................................................................................................ 13

3.2.4 Sample size ................................................................................................................................... 13

3.3 Data collection techniques ............................................................................................................... 13

3.3.1 Ptimary data sources ..................................................................................................................... 13

3.3.2 Face- to- face interviews ............................................................................................................... 13

3.3.3 Observation .................................................................................................................................. 13

3.4 Secondary data sources ............................................................................................................... 14

3.4.1Document Review ......................................................................................................................... 14

3.5 Data analysis technique ................................................................................................................... 14

viii

3.6 Testing and validation .................................................................................................................. 14

3.7 Limitations of the study ............................................................................................................... 14

3.8 System Development ................................................................................................................... 14

3.8.1 Systems Development Life Cycle (SDLC) ................................................................................ 15

3.9 Conclusions .................................................................................................................................. 15

CHAPTER FOUR ................................................................................................................................. 16

SYSTEM DESIGN AND IMPLEMENTATION ................................................................................... 16

4.1.0 INTRODUCTION ........................................................................................................................ 16

4.2.0 Desired system ......................................................................................................................... 16

4.2.0.1 Functional requirements ............................................................................................................. 16

4.2.0.2 Non-Functional requirements ..................................................................................................... 16

4.3 Hardware and Software requirements ......................................................................................... 18

4.4 Organizational Requirements ....................................................................................................... 20

4.5 User requirements ....................................................................................................................... 20

4.6 Target users ................................................................................................................................. 20

4.7 System user ................................................................................................................................. 20

4.7.1 System administrator ................................................................................................................ 20

4.8 Technical user .............................................................................................................................. 20

4.8.1 Final system .......................................................................................................................... 20

4.8.2 DETAILED ANALYSIS AND DESIGN .......................................................................................... 21

4.8.3 LOGICAL DESIGN ................................................................................................................... 21

4.8.4 Conceptual design Table ....................................................................................................... 24

4.8.4.1 Clients Table .............................................................................................................................. 24

4.8.4.2 Cashiers Table ........................................................................................................................... 25

4.8.4.3 Accounts Table .......................................................................................................................... 25

4.8.4.4 Enquiries 'Table ........................................................................................................................ 27

4.8.4.5 Loan Manager's Table ............................................................................................................... 27

4.8.4.6 Referee's Table .......................................................................................................................... 28

ix

4.8.5 Physical Design ...................................................................................................................... 29

4.8.5.1 Login ......................................................................................................................................... 29

4.8.5.2 Main Menu ................................................................................................................................ 30

4.8.5.2 Loan _Manager Fonn: ............................................................................................................... 30

4.8.5.4 Cashiers Form ............................................................................................................................ 31

4.8.5.5 Enquiries Fonn: ......................................................................................................................... 31

4.8.5.6 Account Fonn ............................................................................................................................ 33

4.8.5.7 Referee Fonn ..................................................................................................................... 33

4.8.5.8 Clients fonn ............................................................................................................................... 35

4.8.6.0 Cashiers Report .......................................................................................................................... 36

4.8.6.1 Enquiries ................................................................................................................................... 37

4.8.7 The Input Requirements ............................................................................................................ 37

4.8.8 Output Requirements ................................................................................................................ 37

4.9 Analysis of the current system ..................................................................................................... 38

4.9.1 Strengths and Weaknesses of the current system .......................................................... 38

CHAPTER FIVE ................................................................................................................................... 39

RECOMMENDATION AND CONCLUSION ...................................................................................... 39

5.0 Introduction ................................................................................................................................. 39

S.1 Recommendation ........................................................................................................................ 39

5.2 Training ....................................................................................................................................... 39

5.3 Implementation ........................................................................................................................... 40

5.4 System evaluation ........................................................................................................................ 40

S.S Conclusion ................................................................................................................................... 40

BIBLIOGRAPHY ................................................................................................................................. 41

APPENDICES A ................................................................................................................................... 42

SAMPLE QUESTIONIARES ............................................................................................................... 42

APPENDICES B ................................................................................................................................... 44

X

System Intemal Coding I Design ........................................................................................................... 44