Zimbabwe National Water Authority Electronic Record Support System.

TABLE OF CONTENTS

CHAPTER ONE: INTRODUCTION .................................................................................... 1

1.1 INTRODUCTION ........................................................................................................... 1

1.2 BACKGROUND OF THE STUDY ................................................................................ 1

1.2.1 Background of the Organization ............................................................................... 1

1.2.2 Organizational Structure ........................................................................................... 3

1.2.3 Vision ........................................................................................................................ 4

1.2.4 Mission Statement ..................................................................................................... 4

1.3 PROBLEM DEFINITION ............................................................................................... 4

1.4 AIM .................................................................................................................................. 5

1.5 OBJECTIVES .................................................................................................................. 5

1.6 INSTRUMENTS USED .................................................................................................. 6

1.7 JUSTIFICATION AND RATIONALE ........................................................................... 6

1.8 CONCLUSION ................................................................................................................ 6

CHAPTER TWO: PLANNING PHASE ............................................................................... 7

2.1 INTRODUCTION ........................................................................................................... 7

2.2 BUSINESS VALUE ........................................................................................................ 7

2.3 ANALYZE FEASIBILITY ............................................................................................. 8

2.3.1 Technical Feasibility ................................................................................................. 8

2.3.2 Economic Feasibility .............................................................................................. 10

2.3.3 Social Feasibility ..................................................................................................... 15

2.3.4 Operational Feasibility ............................................................................................ 15

2.4 RISK ANALYSIS .......................................................................................................... 15

2.5 STAKEHOLDER ANALYSIS ...................................................................................... 17

2.6 WORK PLAN ................................................................................................................ 18

2.7 CONCLUSION .............................................................................................................. 19

CHAPTER THREE: ANALYSIS PHASE .......................................................................... 20

3.1. INTRODUCTION ........................................................................................................ 20

3.2 INFORMATION GATHERING METHODOLOGIES ................................................ 20

3.2.1 Interviews ................................................................................................................ 20

3.2.2 Questionnaires ......................................................................................................... 21

3.2.3 On-Site Observation ................................................................................................ 22

3.3 ANALYSIS OF EXISTING SYSTEM ......................................................................... 24

3.4 PROCESS ANALYSIS ................................................................................................. 24

3.5 DATA ANALYSIS ........................................................................................................ 26

3.6 WEAKNESSES OF CURRENT SYSTEM .................................................................. 28

3.7 EVALUATE ALTERNATIVES ................................................................................... 28

3.7.1 Outsourcing ............................................................................................................. 28

3.7.2 Improvement ........................................................................................................... 29

3.7.3 In-house Development ............................................................................................ 29

3.7.4 Recommended Alternative ...................................................................................... 30

3.8 REQUIREMENTS ANALYSIS .................................................................................... 30

3.8.1 Functional Requirements ........................................................................................ 30

3.8.2 Non-functional requirements .................................................................................. 32

3.9 CONCLUSION .............................................................................................................. 33

CHAPTER FOUR: DESIGN PHASE .................................................................................. 34

4.1 INTRODUCTION ......................................................................................................... 34

4.2 SYSTEM DESIGN ........................................................................................................ 34

4.2.1 How the New System (ZINWAER) Works ............................................................ 34

4.2.2 Context Diagram ..................................................................................................... 35

4.2.3 Data Flow Diagram ................................................................................................. 37

4.3 ARCHITECTURAL DESIGN ....................................................................................... 38

4.4 PHYSICAL DESIGN .................................................................................................... 39

4.5 DATABASE DESIGN .................................................................................................. 39

4.5.1 Database Architecture ............................................................................................. 40

4.5.2 Database Tables ...................................................................................................... 41

4.5.3 Enhanced Entity Relationship Diagram .................................................................. 44

4.6 PROGRAM DESIGN .................................................................................................... 47

4.6.1 Package Diagram .................................................................................................... 47

4.6.2 Sequence Diagram .................................................................................................. 48

4.6.2 Class Diagram ......................................................................................................... 49

4.7 INTERFACE DESIGN .................................................................................................. 50

4.7.1 Main Menu .............................................................................................................. 50

4.7.2 User Login .............................................................................................................. 51

4.7.3 Adding New Users .................................................................................................. 51

4.7.4 File System Administration .................................................................................... 52

4.7.5 Booking out and returning of Files: ........................................................................ 54

4.8 PSEUDO CODE ............................................................................................................ 54

4.9 SECURITY DESIGN .................................................................................................... 55

4.9.1 Physical Security ..................................................................................................... 55

4.9.2 Network Security .................................................................................................... 55

4.9.3 Operational Security ............................................................................................... 56

4.10 CONCLUSION ............................................................................................................ 56

CHAPTER FIVE: IMPLEMENTATION PHASE ............................................................. 57

5.1 INTRODUCTION ......................................................................................................... 57

5.2 CODING ........................................................................................................................ 57

5.3 TESTING ....................................................................................................................... 57

5.3.1 Unit Testing ............................................................................................................ 58

5.3.2 Module Testing ....................................................................................................... 58

5.3.3 System Testing ........................................................................................................ 59

5.3.4 Acceptance Testing ................................................................................................. 59

5.3.5 System vs. Objectives ............................................................................................. 60

5.4 INSTALLATION .......................................................................................................... 61

5.4.1 Data Migration ........................................................................................................ 62

5.4.2 Steps in installation ................................................................................................. 62

5.4.3 System User Training ............................................................................................. 64

5.4.4 System Conversion ................................................................................................. 65

5.5 MAINTENANCE PROCESS ........................................................................................ 68

5.5.1 Adaptive maintenance ............................................................................................. 68

5.5.2 Corrective maintenance .......................................................................................... 68

5.5.3 Perfective maintenance ........................................................................................... 69

5.6 RECOMMENDATIONS FOR FUTURE WORK ........................................................ 69

5.7 CONCLUSION .............................................................................................................. 69

BIBLIOGRAPHY .................................................................................................................. 70

APPENDICES ........................................................................................................................ 71

APPENDIX A: USER MANUAL ....................................................................................... 71

APPENDIX B: MANAGEMENT QUESTIONNAIRE ...................................................... 84

APPENDIX C: INTERVIEW CHECKLIST ....................................................................... 86

APPENDIX D: OBSERVATION SCORE SHEET ............................................................ 87

APPENDIX E: CODE SNIPPET ........................................................................................ 89

LIST OF TABLES

Table 2.1 Hardware Requirements of the proposed system……………………………….…..9

Table 2.2 Software……………………………………………………………………..……. 10

Table 2.3 Cost Benefit Analysis of the Proposed System…......................................................11

Table 2.4 Payback Period of the Proposed System……………………………………….......13

Table 2.5 NPV of the Proposed System……………………………………………………....14

Table 2.6 Time allocation and breakdown of processes for the proposed system

development…………………………………………………………………………………. 18

Table 2.7 Gantt Chat for the Proposed System……………………………………………….19

Table 4.1 Markout Cards……..................................................................................................42

Table 4.2 Markout Cards History……………………………………………………………..42

Table 4.3 Record List………………………………………………………………………....43

Table 4.4 SystemLoginLogBook……………………………………………………………..43

Table 4.5 ZinwaUsers………………………………………………………………………...43

Table 4.6 Conversations……………………………………………………………………... 44

Table 4.7 ProcurementTeam …………………………………………………………………44

Table 5.1 Testing Process…………………………………………………………………….60

LIST OF FIGURES

Fig 1.1 ZINWA Catchments………………………………………………………………….. 2

Fig 1.2 Organogram of the Organization...……………………………………………………..3

Fig 3.1 ZINWA Records Department Markout Card……………………………………...….23

Fig 3.2 ZINWA File in the Records Department……………………………………………...23

Fig 3.3 ZINWA Records Department Opened Search Index Entries…………………………23

Fig 3.4 Activity Diagram of the Current system………………………………………………25

Fig 3.5 Context Diagram of the Current system………………………………………………26

Fig 3.6 ZINWA Data Flow Diagram for the Current System…………………………………27

Fig 3.7 Use Case Diagram for the Current System……………………………………….…...31

Fig 4.1 Context Diagram for the new system…………………………………………………36

Fig 4.2 Data Flow Diagram of the new system……………………………………………….37

Fig 4.3 Architectural Design Diagram ……………………………………………………….38

Fig 4.4 Physical Design of the new system ………………………………………………….39

Fig 4.5 ANSI-SPARC Architecture ………………………………………………………….40

Fig 4.6 Enhanced Entity Relationship Diagram ……………………………………………...46

Fig 4.7 Package Diagram of the New System ………………………………………………...47

Fig 4.8 Sequence Diagram of the new system ………………………………………………..48

Fig 4.9 Class Diagram of the new system …………………………………………………….49

Fig 4.10 Main Menu ………………………………………………………………………….50

Fig 4.11 New system Login Form ……………………………………………………………51

Fig 4.12 System Users Form …………………………………………………………………51

Fig 4.13 Add/Update Pop up Form …………………………………………………………...52

Fig 4.14 File System Administration …………………………………………………………53

Fig 4.15 Adding and Updating File Profile …………………………………………………...53

Fig 4.16 Booking out and returning of files …………………………………………………..54

Fig 5.1 Testing Process …………………................................................................................57

Fig 5.2 Booking out and returning files ………………………………………………………61

Fig 5.3 System logs …………………………………………………………………………..61

Fig 5.4 Wamp Server Installation …………………………………………………………….62

Fig 5.5 Select Wamp Server installation folder ………………………………………………62

Fig 5.6 MySQL Connector Installation ………………………………………………………63

Fig 5.7 MySQL Connector Installation ………………………………………………………63

Fig 5.8 MySQL Connector Installation ……………………………………………………...64

Fig 5.9 Four System Conversion Methods …………………………………………………...65