Table of Contents
DECLARATION .......................................................................................................................... ii
APPROVAL ................................................................................................................................. iii
DEDICATION .............................................................................................................................. iv
ACKNOWLEDGMENT ............................................................................................................... v
LIST OF FIGURES ...................................................................................................................... vi
ABBREVIATIONS .................................................................................................................... viii
ABSTRACT .................................................................................................................................. ix
CHAPTER 0 NE ............................................................................................................................ 1
INTRODUCTION ......................................................................................................................... 1
1.0 Introduction ............................................................................................................................. 1
1.1 Background .............................................................................................................................. 1
1.3 Objectives of the study ....................................................................................................... 2
1.3.1 MAIN 0BJECTIVE .............................................................................................................................................. 2
1.4 Research Questions .................................................................................................................. 2
1.5 Scope ......................................................................................................................................... 3
1.6 Significance ............................................................................................................................... 3
1.7 Conceptual Framework .......................................................................................................... 3
CHAPTER TWO ........................................................................................................................... 5
LITERATURE REVIEW ............................................................................................................. 5
2.0 Introduction ............................................................................................................................. 5
2.1 Scope of the Literature review ............................................................................................... 5
2.2 Information system .................................................................................................................. 5
Design and Implementation of Focal Persons' Details Information Management System by Kiggundu Eryeza
X
2.3 Computerized System .............................................................................................................. 6
2.4 Databases .................................................................................................................................. 6
2.4.1 TYPESOFDATABASES ...................................................................................................................................... 6
2.4.2 APPLICATION ADVANTAGES OF DATABASES .................................................................................................... 7
2.5 Database Management System ............................................................................................... 9
2.5.1 ADVANTAGES OF A DBMS ............................................................................................................................... 9
2.6 Structured Query Language (SQL) ..................................................................................... 10
2.7 Visual Basic ............................................................................................................................ 10
2.8 Literature Conclusion ........................................................................................................... 12
CHAPTER THERE ..................................................................................................................... 13
METHODOLOGY ...................................................................................................................... 13
3.0 Introduction ........................................................................................................................... 13
3.1 Target population .................................................................................................................. 13
3.2 Sampling selection ................................................................................................................. 13
3.3 Data collection tools ............................................................................................................... 13
3.3.1 INTERVIEWS ................................................................................................................................................... 13
3.3 .2 QUESTIONNAIRES ........................................................................................................................................... 14
3.3.3 OBSERVATION ................................................................................................................................................ 15
3.4 Development Methodology ................................................................................................... 15
3.5 Conclusion .............................................................................................................................. 16
CHAPTER FOUR ....................................................................................................................... 17
SYSTEM ANALYSIS, DESIGN AND IMPLEMENTATION ............................................... 17
4.0 Introduction ........................................................................................................................... 17
4.1 Fact finding analysis .............................................................................................................. 17
4.1.1 SCOPE REGARDING OCCUPATION OF RESPONDENTS ................................................................................... 17
4.1.2 VIEWS ABOUT PROCEDURES FOR ORGANIZED CLIENT REGISTRATION FOLLOW UP ................................... 18
Design and Implementation of Focal Persons' Details Information Management System by Kiggundu Eryeza
Xl
4.1.3 RESPONDENTS VIEW ABOUT THE IMPACT OF THE DESIGNED SYSTEM ON COST OF OPERATION ................ 19
4.2 System and requirement analysis ......................................................................................... 21
4.2.1 USERREQUIREMENTS ..................................................................................................................................... 21
4.2.1.1 Hardware requirements .............................................................................................. 21
4.2.1.2 Software requirements ............................................................................................... 23
4.3 System Design ........................................................................................................................ 23
4.3.1 PROPOSED SYSTEM ......................................................................................................................................... 23
4.3.2 ARCHITECTURAL CONTEXT LEVEL DESIGN ................................................................................................... 23
4.3.3DATA FLOW DIAGRAM (DFD) ........................................................................................................................ 25
4.4 Database Design ..................................................................................................................... 26
4.4.1 CONCEPTUAL DESIGN .................................................................................................................................... 26
4.4.2 LOGICAL DESIGN ............................................................................................................................................ 27
4.4.3 PHYSICAL DESIGN .......................................................................................................................................... 28
4.5 Implementation ...................................................................................................................... 30
4.5.1 SYSTEM TESTING ............................................................................................................................................ 31
4.6 Presentation of Results .......................................................................................................... 31
4.6.1 SECURITY ....................................................................................................................................................... 32
4.6.2 OTHER INTERFACES ........................................................................................................................................ 32
CHAPTER FIVE ......................................................................................................................... 33
DISCUSSION, CONCLUSION AND RECOMMENDATIONS ............................................ 33
5.0 Int1·oduction ........................................................................................................................... 33
5.1 Discussion ............................................................................................................................... 33
5.2 Conclusion .............................................................................................................................. 34
5.3 Recommendations .................................................................................................................. 34
5.3.1 LIMITATIONS OF THE STUDY ....................................................................................................................... 34
5.3 .2 FUTURE WORKS .............................................................................................................................................. 3 5
APPENDICES .............................................................................................................................. 36
APPENDIX A ............................................................................................................................... 36
ABSTRACT
The Information Management System changes the way we do organizations. That's inescapable conclusion of many organization's seeking to use Information Management System technology to gain a competitive advantage in an ever more Information Management System -based organization environment. Increasingly an Animation Management System is seen as an approp1iate way for organizations use to capture data, organize information and store information in order to facilitate easy access and modification. Of course, information management system technology has always had an impact on the way the organizations operate companies are increasingly adopting to use of information management system technology to organize and store data, and to enhance their core company processes and most organizations with more than a handful of employees use a manual system for keeping files and phone calls to share data. What makes the information management systems such a major organization issue is the way they capture information, organizes information, analyzes information, compiles information, manipulates information and stores information and makes previously unimaginable levels of data management and ability of sharing data. When a Non-govemmental organization such as Trials Uganda uses the information management system, for capturing focal persons' details it takes place in a micro second and clients can do an exercise in the shortest possible time. If an NGO is to survive, let alone prosper, in the information management system technology it needs to examine what it does and how it does it closely and identifies ways to make its organization processes adoptable to the information management system