DEVELOPING AN AUTOMATED LOAN PROCESSING SYSTEM FOR COMMERCIAL BANK (A CASE STUDY OF FIRST CITY MONUMENT BANK, UYO)
Table of Contents – – – – – – – – vii-ix
List of Figures – – – – – – – – x
List of Tables – – – – – – – xi
CHAPTER ONE: INTRODUCTION
1.0 Introduction – – – – – – – 1-2
1.1 Statement of Problem – – – – – 2
1.2 Aim and Objectives of the Study- – – – – 3
1.3 Significance of the Study – – – – – – 3
1.4 Scope of the Study – – – – – – – 3
1.5 Organization of Research – – – – – – 4
1.6 Definition of Terms – – – – – – 5
CHAPTER TWO: LITERATURE REVIEW
- Introduction – – – – – – – – 6
2.1 Theoretical Background – – – – – – 6-7
2.2 The Concept of Loan Transaction System by
Commercial Banks – – – – – – – 8-9
- Submission and Processing of the Loan Application – – 9-11
- Loan Approval Process – – – – – – 11-13
2.5 Preparation of Proposals and Making the Credit Decision – 13-14
2.6 Loan Issuance – – – – – – – – 14-15
2.7 Loan Monitoring – – – – – – – 15-21
CHAPTER THREE: SYSTEM ANALYSIS AND DESIGN
3.0 Introduction – – – – – – – – 22
3.1 Analysis of the Existing System – – – – – 23
3.2 Advantages of the Existing System – – – – 23
3.3 Disadvantages of the Existing System – – – – 23
3.4 Analysis of the Proposed System – – – – 24
3.5 Advantages of the Proposed System – – – – 24
3.6 Disadvantages of the Proposed System – – – 24
3.7 Design of the Proposed System – – – – – 24
3.7.1 Use Case Model – – – – – – 24-25
3.7.2 Database Design – – – – – – 26-27
3.8 System Architecture – – – – – – 27-28
3.8.1 Input Layout – – – – – – – 29
3.8.2 Output Layout – – – – – – 30
3.8.3 Algorithm – – – – – – – 31
3.8.9 Program Flowchart – – – – – – 32-36
CHAPTER FOUR: SYSTEM IMPLEMENTATION
4.0 Introduction – – – – – – – 37
4.1 System Design Diagram – – – – – – 37
4.2 Analysis of Modules – – – – – 37
4.3 Choice of Programming Language – – – 38
4.4 Programming Environment – – – – – 38
4.4.1 Hardware Requirements – – – – – 38
4.4.2 Software Requirements – – – – 39
4.5 System Implementation – – – – – – 39
4.6 Software Testing – – – – – – – 39
CHAPTER FIVE: SUMMARY, RECOMMENDATION AND CONCLUSION
5.0 Introduction – – – – – – – 40
5.1 Constraints of the Study – – – – – – 40
5.2 Summary – – – – – – 41
5.3 Conclusion – – – – – – 41
5.4 Recommendations – – – – – – 41
References – – – – – – 42
Appendix A (Source Code) – – – – – 43-46
Appendix B (Output) – – – – – – 47-52
LIST OF TABLES
Page Number
Table 3.1: Database Design – – – – – 26-27
Table 3.2: Output layout – – – – – – 30
LIST OF FIGURES
Page Number
Figure 2.1: Loan Application form – – – – 7
Figure 3.7.1.1: Use case model – – – – – 2
Figure 3.8.1: Architecture of the existing system – – 28
Figure 3.8.2: Architecture of the proposed system – – 28
Figure 3.8.1.1: Loan request processing input layout – 29
Figure 3.8.4.1: Login flowchart – – – – – 32
Figure 3.8.4.2: Main menu – – – – – 33
Figure 3.8.4.3: Loan Application and processing flow chart- 34
Figure 3.8.4.4: Update loan flow chart – – – – 35
Figure 3.8.4.5: Existing flow chart – – – – 36
Fig 4.1: System Design Diagram – – – – 37
Appendix B.1: Login screen – – – – – 47
Appendix B.2: Main menu screen – – – – 48
Appendix B.3: Loan application and processing screen – 49
Appendix B.4: Loan ID search screen – – – – 50
Appendix B.5: Update loan record screen – – – 51
Appendix B.6: Existing records screen – – – 52