An Online Web Basei) E-billing Water System Case Study: National Water and Sewerage Corporation (Nwsc)

ABSTRACT Along with the changes in the world’s technology. Water became the backbone of industrialization and almost all the activities we carry out rely on Water supply and demands of customers also change as well which has become more demanding and knowledgeable than ever before.’Water is life’S. Consumers ~sho consume Waler units and Water senices today are aeti~e and more critical in Water sen ice deli~ery. ihis in turn made the management to shill their focus on the clients or customers so as to register success in the business today. For a good performance, quality services are the most important exereises for an> Organization. Organiiations like NWSC has kept the standard of their sen ice and try to maintain their customer in the market by pros iding satisfactory sen ices as expected ofthem. 1 here are a number of problems being faced by the service provider (NWSC). Customers themsel~ es are seriously complaining to the services provider (NWSC’) of in-accurate meter reading and estimations, resulting in overcharging of customers by the company. Sometimes this ~~ould result in under payment by customers to the company. This study will have to come up ~~ith a “a> of solving the problem by introducing an on line web based water billing system lbr uew in& bills and pay them promptly using credit cards. Phone or ‘isa by the help of internet. This study is aimed at developing a web-base billing system for Water given that Water uses metering and billing manually. this has led to inaccuracy, high operational costs and unnecessary delays. Nonetheless. we as the researchers will recommend the following: Introduction of remote automated Water metering by the company that should be connected to the system in order to have a complete cycle ofwater trade.

TABLE OF CONTENTS

DECIARATION I

APPROVAL ii

DEDICATION iii

ACKNOWLEDGEMENT iv

ABSTRACT ix

CHAPTER ONE........................... .............................................................~ . I

INTRODUCTION I

1 .O lntroduction I

.1 Background I

1.2 Problem Statement 1

1.3 Objectives ofthe Study 2

1.3.1 Specific Objectives 2

1.4 Significance of the Study 2

1.5 Scope ofthe study 3

1.5.1 Geographical scope 3

1.5.2 Content scope 3

1.6 CONCEPTUAL FRAMEWORK 4

CHAPTER ONE 5

LITERATURE REVIEW.. ..... 5

2.0 Introduction 5

2.1 li-Business for Water Utilities 5

2.2 Security threat 6

2.3 Customers Applications online 7

An on line Web based water billing system by Mundu Robert and Aksanti Gisele. Page vi

2.4 User Requirement .7

2.4.1 Variables concerning Users 8

2.4.2 1 ugh-Level Application 1)esign 8

2.5.0 Test and Maintenance 8

2.6 System Implementation 9

CHAPTERNTHREE 10

METHODOGY 10

3.0 Introduction 10

3.1 System Study and In~ estigation 10

3.2 Research Instruments 10

3.2.1 Inteniews 10

3.2.2 Questionnaire 11

3.2.3 Document Reviev~ 11

3.3 Research Procedure 12

3.4 System Anal) sis 12

3.4.1 FXisting System critically analyzed 12

3.4.2 Checking for problems of Existing System 13

3.5 Requirements Analysis 13

3.5.1 1. ser Requirements 13

1.5.2 Functional Requirements 14

3.5.3 Non-functional Requirementi 14

3.5.4 System Requirements 15

I . Software Requirenients 15

2. hardware Requirentents ....... 15

3.6 System Design 15

3.6.1 Data Flow Diagram IS

An on line Web based water billing system by Mundu Robert and Aksanti Gisele. Page vii

3.6.2 Unfit> Relationship i)iag~s . 16

3.7 System Implementation 16

3.7.1 MySQI 16

3.7.2 Database Design 17

3.7.3 Relational Database Design 17

3.8 Validation and Reliabilit> 18

3.9 Ethical Considerations 18

3.10 Data Analysis 19

3.11 Limitation ofthe Study 19

(1IAPTER FOUR .................................... 21

SYSTEM ANALYSiS. DESIGN AND IMPLEMENTATION 21

4.0 Introduction 21

4.1 Physical Design 27

4.2 Data Design 28

4.3 Snapshots of Web Design and Databases 30

CHAPTER FIVE ..... 40

DISCUSSION, RECOMMENDATION AND CONCI4USION 40

5.0 Introduction 40

5.1 Discussion 40

5.2 Limitation ofthe study 41

5.3 Recommendation. 41

5.4 Conclusion 42

5.5  Research Area 43

REFERENCES: bullet these references with numbers 44