MANAGEMENT INFORMATION SYSTEM FOR KIAMBU COFFEE FACTORY

ABSTRACT

Having a good information system is essential to perform efficiently in a competitive environment; the organization 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 none 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. V In this research I found out that data storage in tuost 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

TABLE OF CONTENTS

DECLARATION 2

APPROVAL 3

DEDICATION 4

ACKNOWLEDGEMENT 5

ABSTRACT 6

TABLE OF CONTENTS 7

ABBREVIATIONS 12

CHAPTERONE 13

INTRODUCTION 13

1.0 INTRODUCTORY INFORMATION 13

1.1 BACKGROUND 101 IL STUDY 14

1.2 PI~oBLEM S1ATEMEN1 15

1.3 GENERAL OBJLC~rIvE 15

1.4 SPECIFIC OBJECTIvEs OF TIlE STUDY 16

1 .5 SCo~ OF TI IL Si i)Y 16

1.6 SIGNIFICANcE 16

CHAPTER TWO 19

LITERATURE REVIEW 19

2.0 INTRODUCTION 19

2.1 MANAGEMENT INFORMATION SYSTEM 19

2.2 THE CHALLENGE OF INFORMATION SYSTEMS; KEY MANAGEMENT ISSUES 20

2.3 DATABAsE MANAGEMFNT INFORMATION SYSTEM 20

2.3. 1 Relational Database 20

8

2.4 DATA SECURITY .21

2.4.1 Use approved sojiware by ICT department 22

2.4.2 Password Policies 22

2.4.3 Virus protection policies 22

2.4.3 Firewall Protection 22

CHAPTER THREE 23

METHODOLOGY 23

3.0 INTRODUCTION 23

3.1 FI~ASIBILITY STUDY 23

3.2 \4EFIIODS OF DATA COLLECTION 25

3.2.1 Questionnaires 25

3.2.2 Observation 25

3.4 S~ S~~M DEsIGN 26

3.5 PROGRAMMING 27

3.6 SYsTEM IMPLEMENTATION 28

3.7 ACrIvITI~s 28

3. 7. 1 Planning and work task schedule 28

3. 7.2 Iinplenient tasks 28

3.7.3 System testing 29

CHAPTER FOUR 31

ANALYSIS OF THE CURRENT SYSTEM 31

4.0 INTRODUCTION 31

4.1 \VL\KNLSS OF TI IL EXIS FING SYSTEM AT KIAMBU COFFEE FACTORY 31

4.2 STRENGTHS OF TIlE CURRENT SYSTEM 32

4.3 REQUI REM ENTS OF THE NEW PROPOSED SYSTEM 32

4.3.1 Hardwa,’e requirements 32

4.3.2 Processing requirements 32

9

4.3.3 Backup and recove .33

4.4 SoFrw~RE REQI IREMENTS 33

4.4.1 V/steal basic 33

4.4.2 Microsojl 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 .~Jodel 38

CHAPTER SIX 39

I)ISCUSSION, RECOMMENDATION AND CONCLuSION 39

6.0 INTRODuCTION 39

6.1 EvALuATION OF TI I E NEW SYSTEM 39

6.2 ChALLENGEs FACED DURING PROJECT DEVELOPMENT 40

6.3 RECOMMENDATIONS 40

6.4 CONCLUSION 41

BIBLIOGRAPHY 42

6.6 FORM VIEWS 43

6.6.1 Splash Screen 43

6.6.2 Logon Sci’een

6.6.3 Main Meicee Form 45

6.6.4 Sample Reports 46

6.6.5 Sample Reports 47

10

APPENDI.X A....__.. - -_.‘.... —.~ —......____ -- -.48