An Information System for a Credit Reference Bureau

TABLE OF CONTENTS

DECLARATION I

APPROVAL II

DEDICATION Ill

ACKNOWLEDGEMENT IV

LIST OF TABLES VIII

LIST OF FIGURES IX

ABBREVIATIONS X

ABSTRACT XI

CHAPTER ONE 1

INTRODUCTION 1

1.1 INTRODUCTION 1

1.2 BACKGROUND OF THE STUDY

1.3 SCOPE OF THE STUDY 2

1.3.1 Geographical scope 2

1.3.2 Scope ofthe System 2

1.4 STATEMENT OF TilE PROBLEM 2

1.5 OBJECTIVES 3

1.5. 1 Main Objectives 3

1.5.2 Specific Objectives 3

1.7 CONCEPTUAL FRAMEWORK 4

1.8 SIGNIFICANCE OFTI-IE STUDY 4

CHAPTER TWO 6

LITERATURE REVIEW 6

2.1 INTRODUCTION 6

2.2 KNOWLEI)GE BASED SYSTEMS 6

2.3 DATABASE AND DATABASE SYSTEM 6

2.4 DATABASE MANAGEMENT SYSTE~ 8

2.5 BENEFITS OF A DATABASE AND DATABASE MANAGEMENT SYSTEM 8

V

2.6 FUNCTIONS OF DATABASE AND DATABASE MANAGEMENT SYSTEM 9

2.7 iNFORMATION SYSTE~ io

2.8 MANAGEMENT INFORMATION SYSTEM

2.9 CoNCLUSION 11

CHAPTER THREE 12

METHODOLOGY 12

3.1 INTRODUCTION 12

3.2 ORGANIzATION UNIT TO BE STUDIED 12

3.3 RISK ASSESSMENT 12

3.5 SYSTEMS DEVELOPMENT METHODOLOGY 13

3.5.1 Requirements gathering and Analysis 13

3.5.2 System & Software Design 13

3.5.3 Implementation and unit testing 14

3.5.4 Integration & System Testing 14

3.5.5 Operations & Maintenance 14

3.6 CONCLUSION 14

CHAPTER FOUR 15

SYSTEMS ANALYSIS AND DESIGN 15

4.0 INTRODUCTION 15

4.1 SYSTEM ANALYSIS I5

4.1.1 Procedure ofthe Study 15

4.1.2 Target Population 16

4.1.3 Sample Selection 16

4.1.4 Data collection Tools 17

4.1.5 Analysis froni the Study 17

4.1.5.1 Introduction I 7

4.1.5.2 Population of the Respondents 18

4.1.5.3 Analysis of the Respondents Age and Gende 18

4.1.5.4 Level of the respondents 19

4.1.5.5 Response on loan taking Procedure’ 19

4.1.5.6 Response on whether respondents had a Computerized Loan System 20

4.1.5.7 Response on the Efficiency of the System 21

4.1.5.8 Response on whether the banks are in Partnership with CRB 21

4.1.5.9 Response on whether the CRB is going to improve the loan acquisition procedure 22

4.1.6 Feasibility Analysis 22

4.1. 7 System Specifications 23

4.1.7.1 Systems Requirements 23

4.1.7.2 Functional Requirements’ 23

Vi

4.1.7.3 Non-Functional Requirements .24

4.1.8 Hardware and Software Requirements 25

4.2 SYSTEMS DESIGN 26

4.2.1 Context level Diagram of the new system 26

4.2.2 Class Diagram representing the nei~ system 27

4.2.1 Sequence Diagram 29

4.2.4 Database Design 30

43.5 Structure oft/ic Information Systemfor C’ompuscan Credit Refi~rence Bureau 33

4.3 CoNcLusioN 34

CHAPTER FIVE 35

SYSTEM IMPLEMENTATION AND UNIT TESTING 35

5.0 INTRODUCTION 35

5.1 SYSTEM IMPLEMENTATION 35

5.2 SYSTEM CODING 35

5.3 TESTING 36

5.3.1 Unit Testing 36

5.3.2 Integration testing 36

5.3.3 System Testing 36

5.4 USER INTERFACES 37

5.5 SAMPuE DATA INPUT 47

5.6 SAMI’LE DATA OuTPUT 48

5.7 USER TRAINING 53

5.6 CONCLUSION 53

CHAPTER SIX 54

RECOMMENDATIONS, DISCUSSIONS AND CONCLUSIONS 54

6.0 INTRODUCTION 54

6.1 RECOMMENDATION 54

6.2 DISCUSSION 55

6.3 CONCLUSIONS 56

BIBLIOGRAPHY 57

APPENDICES 58

APPENDIX A: TIME FRAME 58

APPENDIX B: SAMPLE CODES 59

APPENDIX C: MYSQL DATABASE CODES 64

APPENDIX D: QUESTIONNAIRE 68