Parcel Services Management Information System for Regional Limited, Kenya

TABLE OF CONTENT

DECLARATION

APPROVAL

DEDICATION

ACKNOWLEDGEMENT

TABLE OF CONTENT w

LIST OF TABLES

LIST OF FIGURES VII

ABSTRACT 

CHAPTER ONE 1

GENERAL INTRODUCTION 1

1.0 INTRODUCTION

1.1 BACKGROuND OF CASE STUDY 2

1.2 STATEMENT OF THE PROBLEM 2

1.3 OBJECTIVE OF THE STUDY 3

1.3.1 General Objective

1.3.2 Specific objectives of the study 4

L4 SCOPE OF THE STUDY

1.5 JUSTIFICATION OF THE STUDY 4

1.6 LIMITATIONS OF THE STUDY

1.7 CONCLUSION 6

CHAPTER 2

LITERATURE REVIEW 7

2.1 INTRODUCTION 7

2.2 INFORMATION SYSTEM 7

2.3 INFORMATION TECHNOLOGY 8

2.4 DATABASE MANAGEMENT SYSTEM 9

2.4~1 Database 9

2.4.2 Database Management Systems 11

2.5 TOOLS USED 12

2.5.1 Visual basic programming language 12

2.5.2 Microsoft Access (Ms Access) 14

2.5.3 crystal Reports 14

2.6 SYSTEM DEVELOPMENT LIFE CYCLE. (SDLC) 16

2.7 CONCLUSION 17

CHAPTER 3 18

SYSTEM ANALYSIS 18

3.1 INTRODUCTION 18

3.2 PRo~EDu~ OF THE 5T1J]jy 18

3.3 POPuLATION OF THE AREA OF STUDY 19

3.4 DATA COLLECTION METHODS 19

3.4.1 Primary methods 19

IV

3.4.2 Secondary methods22

3.5 ANALYSIS OF THE CURRENT SYSTEM 22

3.5.1 . Strengths of current system.

3.5.2 Weakness of current system 24

3.6 SYSTEM SPECIFICATION 24

3.6.1 system Requirement 24

3.6.2 Security Requirements of the New System 25

3.6.3 Functional requirement 26

3.6.4 Nonfunctional requirement 26

3.7 Conclusion

CHAPTER FOUR

SYSTEM DESIGN 29

4.1 INTRODUCTION 29

4.2 E-R (ENTITY RELATIONSHIP) MODEL 29

4.~ C~NTt~x~r DIAt~1~M 30

4.4 DFD FOR TilE NEW SYSTEM 31

4 C fl m n * r’ fl or.-, -ii 1..J L~.1 14DJ-~. j~. ~J

4.6 RELATIONAL SCHEMA 36

4.7 I~~iu~i.ci~ DESIGN 37

4.8 CONCLUSION 37

CHAPTER FIVE 38

SYSTEM IMPLEMENTATION 38

5.1 INTRODUCTION

5.2 PROGRAM TESTING

5.3 Ti~.&r~rr~ 40

5.4 PROJECT IMPLEMENTATION 40

5.4.1 System Implementation 40

5.5 USER INTERFACE 40

5.6 SYSTEM CHANGE OVER  49

5.6.1. Parallel changeover 49

5.6.2. Significant location (pilot) changeover so

5.6.3. Phased approach so

5.7MMNTEN~CF 51

5.8 CONCLUSION

CHAPTER 5i~ 52

RECOMMENDATIONS AND CONCLUSION 52

6.1 INTRODUCTION 52

6.2 RECOMMENDATIONS 52

6.3 CONCLUSION

GLOSSARY 54

APPENDIX 1

APPENDIX 2 58

APPENDIX 3 60

BIBLIOGRAPHY 61