Design And Implementation of Sms Based Water Billing System

ABSTRACT

is a critical function of most Water Boards especially towards sending the bill to their consumers. Most problems, currently seen, result from the manual processes followed.

Calculation errors, delays in system updating and bill sending, also report tracking issues are the major problems that boards find difficult to find answers for.

This work provides a solution called an SMS-based water billing system to collect, process, and notify consumers about consumption. This will be reliable, efficient, and accurate to suit the requirements of Bagudo local government water board.

The proposed uses evolving Mobile Technologies known as SMS and vogue pay online payment technologies,

over a solution that uses web applications to handle the organization’s day-to-day transactions which will allow the water board to send bills to their consumers via SMS and consumers to pay their bills using ATM cards.

The burden on the billing is lessened and other new features have also been introduced. Consumer interaction with the organization is improved and consumers can easily view their monthly water bills by login into the organization’s website.

TABLE OF CONTENTS

Title page ………………………………………………………………………………..………i
Certification page ………………………………………………………………………………..ii
Dedication ……………………………………………………………………………………….iii
Acknowledgment………………………………………………………………………………iv
Table of contents ……………………………………………………….……………………………v
Abstract ………………………………………………………………………………………….x
CHAPTER ONE: INTRODUCTION
1.1 Introduction ……………………………………………………………………………………1
1.2 Background of the study ………………………………………………………………………1
1.3 Statement of the problem ……………………………………………………………………..2
1.4 Aims and Objectives…………………………………………………………………………..3
1.5 Significance of the study ………………………………………………………………………3
1.6 Scope and Limitation ………………………………………………………………………….4
1.7 Definition of terms …………………………………………………………………………….4
1.7.1 Internet …………………………………………………………………………………….4
1.7.2 Web ……………………………………………………………………………………….4
1.7.3 Web browser ………………………………………………………………………………4

1.7.4 Website ……………………………………………………………………………………5
1.7.5 Web page …………………………………………………………………………………5
1.7.6 Localhost ………………….………………………………………………………………5
1.7.7 Web server ……………………………………………………………………………….5
CHAPTER TWO: LITERATURE REVIEW
2.1 Introduction to billing ……………………………………………………………………….7
2.2 Types of billing ………………………………………………………………………………7
2.3 Classification of bills ………………………………………………………………………..8
2.4 Online billing systems (Electronic bills) ………………………………………………..…..10
2.4.1 Features of online bills ……………………………………………………………………10
2.4.2 Advantages of online billing systems ……………………………………………………..11
2.4.3 Disadvantages of online billing systems ………………………………………………….12
2.5 Short message service (SMS) …………………………………………………………….…12
2.5.1 Types of short message service (SMS) ……………………………………………………13
2.6 Water meter …………………………………………………………………………………14
2.6.1 Meter reading (MR) ……………………………………………………………………….14
2.7 Review of some existing water billing systems ……………………………………………..14
2.8 Software tools ……………………………………………………………………………….15
2.8.1 Hypertext markup language (HTML) ……………………………………………………15
2.8.2 Hypertext preprocessor (PHP) …………………………………………………………..16
2.8.3 Apache HTTP server ……………………………………………………………………….18
2.8.4 Mysql …………………………………………………………………………………….19
2.8.5 Java script ………………………………………………………………………………..20
2.8.6 Wamp server ……………………………………………………………………………..21
CHAPTER THREE: SYSTEM ANALYSIS
3.1 Introduction ………………………………………………………………………………..23
3.2 Requirement analysis ………………………………………………………………………23
3.2.1 Hardware requirements …………………………………………………………………..24
3.2.2 Software requirements ………………………………………………………………..…24
3.2.3 Preferred requirements ……………………………………………………………..……24
3.3 Analysis of the current system ……………………………………………………..………25
3.3.1 Analysis of the input …………………………………………………………….………26
3.3.2 Analysis of the output ………………………………………………………….………..26
3.3.3 Analysis of the existing system procedure ………………………………….……………27
3.4 Files maintained ……………………………………………………………….…………..27
3.5 Web-design methodology …………………………………………………….……………28
3.5.1 Mission statement ………………………………………………………….……………28
3.5.2 Audience modeling ………………………………………………………..…………….28
3.5.3 Conceptual modeling ……………………………………………………..……………..29
3.5.4 Implementation design phase ………………………………………….………………..29
3.5.5 Implementation phase ……………………………………………….…………………..31
3.6 Expectations of the new system …………………………………………………………..31
CHAPTER FOUR: SYSTEM DESIGN AND IMPLEMENTATION
4.1 Introduction ………………………………………………………………………………33
4.2 System design …………………………………………………….………………………33
4.3 Description of the proposed system …………………………..…………………………..34
4.3.1 Steps of design process ……………………………………..…………………………..35
4.3.2 System flow design ……………………………………..………………………………39
4.3.3 Data flow diagram ………………………………………..……………………………..43
4.3.4 Use case ………………………………………………..………………………………..44
4.3.5 Database design ………………………………………..………………………………..46
4.4 System implementation ………………………………..………………………………….50
4.4.1 Login page …………………………………………..…………………………………..50
4.4.2 Registration page …………………………………..……………………………………51
4.4.3 Consumer home page ……………………………..…………………………………….52
4.4.4 Password resetting page ………………………………………………………………….52
4.4.5 Feedback page ……………………………………………………………………………53
4.4.6 Cashiers page …………………………………..………………………………………..54
4.4.7 Administrator control panel …………………..…………………………………………54
4.5 System testing ………………………………………………………………………………55
4.5.1 Testing method ……………………………………………………………………………56
4.5.2 Test plan …………………………………………………………………………………..56
4.5.3 Types of testing ………………………………………………..…………………….……57
CHAPTER FIVE: SUMMARY, CONCLUSION, AND RECOMMENDATION
5.1 Summary ……………………………………………………..……………………………59
5.2 Conclusion …………………………………………………..……………………………..61
5.3 Recommendation …………………………………………..………………………………62
5.4 Suggestions for further research …………………………………………………………….62
5.5 References ………………………………………………….………………………………..64

INTRODUCTION

It is obvious that without technology there is no https://innaija.com.ng/current-projects/design-and-implementation-of-sms-based-water-billing-system/modernization, and https://innaija.com.ng/current-projects/design-and-implementation-of-sms-based-water-billing-system/modernization, in turn, brings about improvement in the quality of our lives. The invention of the computer and some other related devices has no doubt brought improvement in the quality of life.

With the introduction of computer many software was invented and has made those things, which seem not to be possible, a reality.

SMS Based Water Billing Software is a special program designed to store and manages the records of all the billing activities of the Bagudo water board. It helps to save the record of consumers, cashiers, and monthly bills. It also helps to send consumers monthly bills via SMS.

REFERENCES

Achebe. I. D. (2002): Comparative Studies on Web Design Methodologies: [online] Accessedfrom: http://www.dsic.upv.es/~west2001/iwwost01/. Retrieved on 3rd March, 2014
ClickSUMO (2011) SMS is still king article by clickSUMO. Available athttp://www.clicksumo.com/sms-is-still-king/
Check Free Research Services. (August 2007). Consumer Billing and Payment Trends 2002- 2007; the Volume of Electronic BillPayments Exceeds Check Bill Payments for the FirstTime.
Chris Wease (Feb 27, 2013). Billing and Collection System. Seminar Presentation Lead byTWI.Chris Wease, National Sales. Trends in Billing & Payment Technology Sponsor:NCAWWA.
Department Audit Commission Hong Kong (25 March 2008). Customer Care and BillingSystem of the Water Supplies Report No. 50, available on the website athttp://www.aud.gov.hk.
David R. Brooks (2007), Guide to HTML, JavaScript and PHP For Scientists and Engineers,doc. Ing. Ondřej Přibyl, (2011). System Analysis and Design of ITS, Available athttp://zolotarev.fd.cvut.cz/sni/. Retrieved 2014-07-2.
Electronic bill presentment and payment (In English). Available athttp://www.webopedia.com/term/e/. Retrieved 2014-02-13.

StudentsandScholarship Team.