Management Information System for Kiambu Coffee Factory

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