TABLE OF CONTENTS
DECLARATION 2
APPROVAL 3
DEDICATION 4
ACKNOWLEDGEMENT 5
ABSTRACT 6
TABLE OF CONTENTS 7
ABBREVIATIONS 12
CHAPTER ONE 13
INTRODUCTION 13
1.0 1N~I RODUCTORY INFORMATION 13
1,1 BAcKGROuND TO TIE STUDY 14
1.2 PROBLIiM STATEMuN’r 15
1.3 GENERAL OBJEcTIvIz 15
1.4 SPEcIFic OI3,IEc1~Ivus OF TIlE STUDY 16
1.5 Sco~u OF TIlE STUDY 16
1.6 SIGNIFICANcE 16
CHAPTERTWO 19
LITERATURE REVIEW 19
2.0 INTRODUCTION 19
2.1 MANAGEMENT INFORMATION SYSTEM 19
2.2 THE CIIALLENGE OF INFORMATION SYSTEMS; KEY MANAGEMENT ISSUES 20
2.3 DATABASE MANAGEMENT INFORMATION SYSTEM 20
2.3.1 Relational Database 20
8
2.4 DATA SEcu~~ rY .21
2.4.1 Use approved so/hvare by ICT department 22
2.4.2 Password Policies 22
2.4.3 Virus protection policies 22
2.4.3 Firewall Protection 22
CHAPTERTHREE 23
METHODOLOGY 23
3.0 INTRODUCTION 23
3.1 FEAsIBILI ry S’ruoy 23
3.2 METhoDs OF D,\ IA CoLLECTIoN 25
3.2. 1 Questionnaires 25
3.2.2 Observation 25
3.4 S~si’~~~ DEsIGN 26
3,5 PROGRAMMING 27
3.6 SYsTEM 1MPLEMI~N’I’ATIoN 28
3.7 ACTIvi’riEs’ 28
3. 7.1 Planning and work task schedule 28
3.7.2 Jnzplemeiit tasks 28
3.7.3 System testing 29
CHAPTER FOUR 31
ANALYSIS OF THE CURRENT SYSTEM 31
4.0 INTRODUCFION 31
4.1 WEAKNEss OF TIlE EXISTING SYSTEM AT KIAMBU COFFEE FACTORY 31
4.2 STRENG’I’I IS OF TI IE CURRENT SYSTEM 32
4.3 REQUI REM ENTS OF TI IE NEW PROPOSED SYSTEM 32
4.3.1 Hardware requirements 32
4.3.2 Processing requirements 32
9
4.3.3 Backup and recovel3’ .33
4.4 SoF~rw~E REQuIREMENTs 33
4.4.1 Visual basic’ 33
4.4.2 Microso/i access 34
3.6.3 Antivirus 34
4.5 Security Requirements 34
CHAPTER FIVE 36
SYSTEM DESIGN 36
5.0 SYsTEM DEsIGN 36
5.1 ENTITY RELATIONShIP MODEL 36
5.1.1 Entity Relationship Model 37
5.1.2 Conceptual Data Model 38
CHAPTER SIX 39
DISCUSSION, RECOMMENDATION AND CONCLUSION 39
6.0 INTRO[)~ (‘lION 39
6.1 EvAU ATION OF TIlL NEW SYSTEM 39
6.2 CIIALLENGE5 FACED DURING PROJECT DEVELOPMENT 40
6.3 RECOMMENDATIONS 40
6.4 CONCLuSION 41
BIBLIOGRAPIIY 42
6.6 FORM VIEWS 43
6.6.1 Splash Screen 43
6.6.2 Logon Screen 44
6.6.3 Maui Meiiii Eoriii 45
6.6.4 Sample Reports 46
6.6.5 Sample Reports 47
ABSTRACT Having a good information system is essential to perform efficiently in a competitive environment; the organisation with better information system has a distinct advantage. It’s upon this background that, this study of building a management information system for Kiambu Coffee Factory is based. The objective of this study was to design a system of information management that is suitable in that, there is efficiency, security and the reduction of the work load where in this it is done manually that is the storage and the retrieving of files. The methodology involved in this study included data collection example Feasibility study, interviews, system design (that is used to give the requirements needed for the system to perform), Programming for the development of the system, and the implementation. In this research I found out that data storage ~ in most factories has not been modernized and up to date. Due to this fact there is a big problem of collection of data, storage and security. This is where I contributed to help’ solve the problem by designing and implementing an interactive computer system that has passwords for security, a database for the accurate and efficient storage of data. In conclusion this field of study has not been exhaustedly researched and developed and due to the evolving technology I would urge future researchers to help perfect on the 6 storage, retrieval and security of information ‘mostly in organizations and complex companies like factories.