Web based electric billing System (2) (1)
Web based electric billing System (2) (1)
INSTITUTE OF TECHNOLOGY
SCHOOL OF COMPUTING
DEPARTMENT OF COMPUTER SCINCE
Name Id
1. Besufekad Terefe…………DDU1002161
2. Bikila Mitiku……………. DDU1001890
3. Haftia Adisalem…………..R/1796/09
4. Helen Solomon………….. DDU1001651
5. Henok Megersa ……………...DDU1001604
i
1.12.3 Economic Feasibility (Cost Benefit Analysis) .......................................................... 7
1.12.4 Schedule Feasibility .................................................................................................. 8
CHAPTER TWO ............................................................................................................................ 9
2. Requirement Elicitation ........................................................................................................... 9
2.1 Overview of existing system ............................................................................................ 9
2.2 Existing system ................................................................................................................ 9
2.2.1 Existing System Description ..................................................................................... 9
2.2.2 Supplementary Requirements ................................................................................... 9
2.3 Advantages Existing system........................................................................................... 10
2.4 Disadvantages Existing system ...................................................................................... 10
2.5 Proposed Solution .......................................................................................................... 11
2.6 Prefered solution ............................................................................................................ 11
2.7 Domain modelling with CRC card ................................................................................. 12
2.8 Essential Use Case diagram ........................................................................................... 13
2.8.1 Actor Identification ................................................................................................. 13
2.8.2 Use Case Identification ........................................................................................... 13
2.8.3 Use Case Diagram................................................................................................... 13
2.9 Use Case Description ..................................................................................................... 14
2.10 Essential User Interface Prototyping .............................................................................. 21
CHAPTER THREE ...................................................................................................................... 22
3. SYSTEM ANALYSIS ....................................................................................................... 22
3.1 Overview of New system ............................................................................................... 22
3.2 System requirement ........................................................................................................ 22
3.2.1 Functional Requirements ........................................................................................ 22
3.2.2 Non-Functional Requirements ................................................................................ 23
3.3 System modelling ........................................................................................................... 24
3.3.1 System use case diagram ........................................................................................ 24
3.3.2 System use case diagram documentation ................................................................ 24
3.4 Sequence diagram .......................................................................................................... 35
3.5 Activity diagram ............................................................................................................. 43
3.6 Class diagram ................................................................................................................. 50
ii
CHAPTER FOUR ......................................................................................................................... 52
4. SYSTEM DESIGN ................................................................................................................ 52
4.1 Design goal ..................................................................................................................... 52
4.2 System Architecture ....................................................................................................... 53
4.3 Sub-system Decomposition ............................................................................................ 53
4.4 State chart diagram ......................................................................................................... 54
4.5 Collaboration Diagram ................................................................................................... 55
4.6 Deployment Diagram ..................................................................................................... 58
4.7 Persistent data storage and management ........................................................................ 59
4.8 Graphical user interface Design ..................................................................................... 60
CHAPTER FIVE .......................................................................................................................... 62
5. CONCLUSION AND RECOMMENDATIONS .................................................................. 62
5.1 Conclusion...................................................................................................................... 62
5.2 Recommendation ............................................................................................................ 62
Reference ................................................................................................................................... 63
iii
Acronyms and Abbreviations
Cases
iv
List of Tables
Table 1.1 Budget of the project....................................................................................................... 7
Table 1.2 schedule plan................................................................................................................... 8
v
List of figure
Figure 2. 1 use case diagram of existing system ........................................................................... 14
vi
Figure 3. 29 activity Diagram for Generate Bill ........................................................................... 48
Figure 3. 30 Activity Diagram for Generate Report ..................................................................... 48
Figure 3. 31Activity Diagram for Assign Service ........................................................................ 48
Figure 3. 32 Activity Diagram for Stop Service ........................................................................... 49
Figure 3. 33 Activity Diagram for View bill ................................................................................ 49
Figure 3. 34Activity Diagram for View users .............................................................................. 49
Figure 3. 35Activity Diagram for Add News ............................................................................... 50
Figure 3. 36 Activity Diagram for Import .................................................................................... 50
Figure 3. 37 class diagram ............................................................................................................ 51
vii
CHAPTER ONE
1. INTRODUCTION
Now a day our world is globalized with the help of technologies and other applications. For that
reason developed and some developing countries are using the application and other computer
technologies to be part of the globalized world. Many organization and individuals have their
computer based applications for the purpose of running their business, to perform different activity.
The purpose of this proposed project is to establish the method electric power billing service for
the city community. As well to establish the specification pertaining to the design and maintenance
of decentralized treatment and full service as well as facilities within the city service boundary.
Many problems that exist in Dire dawa city electric power billing system to finish their works
properly and the organization are currently facing a some challenge among thus there are losing
of data because for the current system there is not such suitable to store and retrieve data. And also
time consuming process for the customers by going to the organizations to bill. In addition to this
the current system is not user-friendly and not accurate to read data from everywhere because it is
window based. Generally, this all recommend us to develop web based billing system to make the
operation easy, accurate, flexible and to prevent data loss.
1
1.4 Objective of the project
2
In order to pay the bill online the user must have CBE account with balance and that is
integrated with electric utility providers.
The system doesn’t read the distance.
It is Web based system.
1.7 Constraint
While doing this project we faced different types of problems that obstacles our work in order to
finish work timely. Some of these problems are listed below.
1.8 Methodology
Reading documents:
To have detailed awareness about our project we used documents such as books. During the
Analysis of documents, we give a special consideration to those documents which can bring more
features to our system.
Questioners :
We would conduct questioners for the Dire Dawa city electric power utility to study the existing
system and develop the new system.
3
includes the overall features of OOSAD. The other reason is that using object-oriented
programming we can write clear, more reliable, more easily maintained programs.
Waterfall
Prototyping
Incremental
Iterative
Spiral.
From those developments methodology’s we will use incremental model. In this model, each
module passes through the requirements, design, implementation and testing phases. A
working version of software is produced during the first module, so we have working software
early on during the software life cycle. Each subsequent release of the module adds function
to the previous release. The process continues till the complete system is achieved.
Additionally we choose the incremental model because it has advantages we listed below.
4
Advantages of Incremental model:
This model is more flexible, less costly to change scope and requirements.
Easier to manage risk because risky pieces are identified and handled during it’s
incremental.
5
1.9.2 Programming Language
HTML: for describing webpage and interface application.
JS: designing to add interactivity to HTML through validation.
CSS: we have used it add style to HTML elements for decoration and attractively.
PHP 5.5.12: we used it as a server script because of it run on different platform like
Linux, windows, and on other servers like Apache server.
time,
money,
power and
Increase efficiency and effectiveness.
1.12 Feasibility
While doing this project, it is fair to see some conditions with regard to cost, clients (end users)
and also about the system developer.
6
1.12.1 Technical Feasibility
At the implementation stage, we will use the latest technology development tools. Such as HTML,
CSS and JavaScript for front end, and WAMP server and PHP as back end which is the most recent
and open source popular technologies to develop web based systems and to design the database.
As the result our system is technically feasible.
Tangible cost:
7
2. Paper 1 packet 130 130
5. Pen 10 5 50
6. Transport 2 10 20
8. CD-RW 2 8 16
Total 12,358
8
CHAPTER TWO
2. Requirement Elicitation
Costumers will pay money for what they use per month. And no payment difference
for the same service.
9
Costumer should get the bill paper for what they are paying.
Some gap is given for a costumer to pay their bill payment. If they didn´t pay within a
given day, it postponed to the next month.
Anyone who wants to use the service must have an identity card with its legal number.
Anyone who wants to use the service must have legal house.
Every customer’s age must be greater than 18.
Every user must pay their payments within the given period of time
The employee stops the service of anyone who don’t pay his/her bill payment
Any user who lost his/her bill paper will inform to the office and can get its copy.
10
Duplication of data occurs when data input in to the system.
Checking the validity of input data is difficult
The services provided by the office are not as fast as possible.
11
The system is accessible anywhere and anytime, as long as administrator have
access to a device with an Internet connection, and the system is great at storing
data
Customer<<actor class>>
Customer id
Customer name
Phone number
Address Admin, employee
Feed back
Transfer Money
Pay Money
Add money
Admin<<actor class>>
Admin id
Name
Address Customer , employee
add account
deactivate account
Report
Employee<<actor class>>
Employee id
Name
12
Address Customer , Admin
add account
deactivate account
Report
13
Figure 2.1 use case diagram of existing system
Section Purpose
Name Current service
Identifier 01
Description It allows the user to see the status of the current service.
Actor Customer
Precondition none
14
Table 2.5 Use case Description for Pay Bill
Section Purpose
Name Pay bill
Identifier 02
Description It allows the customer to pay their bill.
Actor Customer
Precondition The customer must use first.
Section Purpose
Name complain
Identifier 03
Description It allows the customer to report their complaints.
Actor Customer
15
Precondition The customer must take the complain form first.
Alternative flow of If the form filled is not correct again the customer fill it.
events
Section Purpose
Name Deactivate account
Identifier 04
Description It allows the administrator to deactivate the accounts.
Actor Administrator
Precondition The Admin must have users account first.
16
Section Purpose
Name Add account
Identifier 05
Description It allows the administrator to add new employee account.
Actor Administrator
Precondition The administrator must take customer.
Alternative flow of The system shows an error message or incorrectness of any employee
events data then stay on step2.
Section Purpose
Name report
Identifier 06
Description It allows the administrator and the employee to see reports.
Actor Administrator and Employee
Precondition The administrator and the employee must login first.
17
Table 2.10 Use case Description for View Complaint
Section Purpose
Name take complaint
Identifier 07
Description It allows administrator and employee to view complaints of users.
Actor Administrator and Employee
Precondition Administrator and employee must have access first.
Section Purpose
Name check bill
Identifier 08
Description It allows the employee to generate the bill.
Actor Employee
Precondition The employee must have access first.
Alternative flow of The system shows an error message for incorrectness of the current
events metre reading then stay on step2.
18
Table 2.12 Use Case Description for Generate Report
Section Purpose
Name make report
Identifier 09
Description It allows the employee to generate the report.
Actor Employee
Precondition The employee must have authority first.
Section Purpose
Name Assign service
Identifier 10
Description It allows the employee to assign services.
Actor Employee
Precondition The employee must have access first.
19
1. The employee takes the 2.TheSystem displays the deactivated
assign service form services
3. The employee assign the 4.The system assigns metre number
required service from the list for the new service
sand fill the metre number and
press assign button.
Alternative flow of The system shows an empty select menu if there are no deactivated
events services in the system.
Post condition The user service assigned.
Section Purpose
Name View bill
Identifier 10
Description It allows the employee to view all bills information.
Actor Employee
Precondition The employee must have the authority.
20
Post condition Employee viewed all bill information.
21
CHAPTER THREE
3. SYSTEM ANALYSIS
System analysis is the process of understanding and identifying basic requirements that the
system need and should do. System analysis documentation discuss the over view of the new
system, this topic explain functions provided by the system and its operational constraint. These
system requirements can be seen in two different perspectives, one is what the system should do
and the other is what it needs in order to accomplish its work.
3.2System requirement
3.2.1 Functional Requirements
A functional requirement specifies what the proposed system should do. And describe the
interactions between the system and its environment (Booch, 1994). For example, functional
requirement of our system is must assign customer bill account and make accessible for a user,
allow the employees to manage data easily and allow the administrator to control account. The
main requirement that used to handle are observable tasks or processes that must be performed
by the system:
22
3.2.2 Non-Functional Requirements
It describes user-visible aspects of the system that are not directly related with the functional
behaviour of the system. Non-functional requirements include quantitative constraints, such as:-
Response time (i.e., how fast the system reacts to user commands) or
Accuracy (i.e., how precise).
Performance
User Interface
The forms prepared for the information are easy to user they can easily understand.
The system should include attractive interfaces and should replace existing system.
The system should be secure because the admin page and user page is developed
separately by different language
The system should be secure and must use encryption to protect the databases. Users
need to be authenticated before having access to any personal data.
23
3.3 System modelling
3.3.1 System use case diagram
Section Purpose
Name Register
Identifier 1
Description The customer will create an account for himself.
Actor Customer
Precondition The customer must have valid identity and house number.
User action System response
24
Basic flow of events 1. The customer will click on 2. The system will display
register tab of the main registration form.
window. 4. The system will check entered data
3.the customer will fill all the and then display successful creation
information’s and click ok. of account and gives privilege for the
customer.
Alternative flow of 1. The system verifies and informs to re-enter again if incorrect
Events information is given and stay on step2.
Post-condition Account will be created for the customer.
Section Purpose
Name Login
Identifier 2
Description It allow the actor enter to their page.
Actor Administrator, Employee and customer
Precondition The actor must have correct user name and Password.
Alternative flow of The system shows an error message for incorrectness of the username
events and password then resume to step2.
25
Section Purpose
Name Current service
Identifier 3
Description It allows the user to see the status of the current service.
Actor Customer
Precondition The user must login first.
Section Purpose
Name Pay bill
Identifier 4
Description It allow the customer to pay their bill.
Actor Customer
Precondition The customer must login first.
26
Table 3. 5 Use Case Description for Send Complaint
Section Purpose
Name Send complaint
Identifier 5
Description It allows the customer to send their complaints.
Actor Customer
Precondition The customer must login first.
Alternative flow of The system shows an error message if no data is inserted then stay on
events step2.
Section Purpose
Name Change password
Identifier 6
Description It allow the system users to change their passwords.
Actor Administrator, customer and employee
Precondition Any of the actors must login first.
27
1. User clicks the change 2.TheSystem displays change
password button password form
3. User fills his/her old 4. System checks the entered password
password and new password And displays success message
Alternative flow of The system shows an error message for incorrectness of the entered old
events password and the new password confirmation then resume to step2.
Section Purpose
Name Deactivate account
Identifier 7
Description It allows the administrator to deactivate the accounts.
Actor Administrator
Precondition The administrator must login first.
Section Purpose
Name Add account
Identifier 8
28
Description It allows the administrator to add new employee account.
Actor Administrator
Precondition The administrator must login first.
Alternative flow of The system shows an error message or incorrectness of any employee
events data then stay on step2.
Section Purpose
Name View report
Identifier 9
Description It allows the administrator and the employee to see reports.
Actor Administrator and Employee
Precondition The administrator and the employee must login first.
29
Section Purpose
Name View complaint
Identifier 10
Description It allows administrator and employee to view complaints of users.
Actor Administrator and Employee
Precondition Administrator and employee must login first.
Section Purpose
Name Generate bill
Identifier 11
Description It allows the employee to generate the bill.
Actor Employee
Precondition The employee must login first.
Alternative flow of The system shows an error message for incorrectness of the current
events metre reading then stay on step2.
30
Post condition Bill generated.
Section Purpose
Name Generate report
Identifier 12
Description It allows the employee to generate the report.
Actor Employee
Precondition The employee must login first.
Section Purpose
Name Assign service
Identifier 13
Description It allow the employee to assign services.
Actor Employee
Precondition The employee must login first.
31
1. The employee clicks the 2.TheSystem displays the deactivated
assign service button services
3. The employee clicks the 4.The system assigns metre number
required service from the list for the new service
sand fill the metre number and
press assign button.
Alternative flow of The system shows an empty select menu if there are no deactivated
events services in the system.
Post condition The user service assigned.
Section Purpose
Name Stop service
Identifier 14
Description It allows the employee to stop the working services.
Actor Employee
Precondition The employee must login first.
Alternative flow of The system shows an empty table if there is no any services in the
events system.
Post condition The system blocks the service.
32
Section Purpose
Name View bill
Identifier 15
Description It allows the employee to view all bills information.
Actor Employee
Precondition The employee must login first.
Section Purpose
Name View users
Identifier 16
Description It allows the employee to view all users information.
Actor Employee
Precondition The employee must login first.
33
1. Employee clicks the view 2.TheSystem displays all users detail
users button
3.Employee view the all users
Information
Alternative flow of The system shows an empty table if there is no users in the system.
events
Post condition Employee viewed all users’ information.
Section Purpose
Name import
Identifier 17
Description It allows the employee to import user id and house number.
Actor Employee
Precondition The employee must login first.
34
Table 3.18 Use Case Description for Logout
Section Purpose
Name Logout
Identifier 18
Description It allow the all the actors to leave out their pages.
Actor Administrator, Employee and customer
Precondition They must login first.
SD for register
register form
customer home page database
form controler
click register
button()
display()
validate()
if valid()
fills forms and click ok()
check
integrity()
integrity status()
store()
success message()
if not valid()
error message()
35
Figure 3. 2 Sequence Diagram for Register
SD for login
admin/
admin/
login DB employee/
employee/ home page login form
controler account customer
customer
page
clicks login
button()
display()
send()
validate()
user autunticated()
if invalid()
incorrect()
customer
customer system database
database
page
36
SD for pay bill
display()
enter credit card number()
validate()
if valid()
send()
validate()
update ()
pay()
if invalid()
incorrect()
success message()
display()
fills and click ok()
validate()
if valid()
send()
success()
if not valid()
incorrect()
37
SD for change password
admin/ change
admin/employee/ form
employee/ password databse
customer page controler
customer form
display()
check()
validate()
save()
success()
if not valid()
incorrect()
admin account
admin databse
page table
display()
success message()
38
SD for add account
add
admin form
admin account databse
page controler
form
display()
if not valid()
incorrect()
employee/
employee/
admin system database
database
admin
page
retrive()
display the report status()
39
SD for view complaint
employee/
employee/
admin system database
database
admin
page
employee generate
employee system Database
page bill form
validate()
save()
success message()
if not valid()
error message()
40
SD for generate report
employee bill
employee Database
page information
initiate() retrive()
success message()
employee deactivated
employee databse
page service
display()
success()
41
SD for stop service
employee active
employee databse
page service
display()
success()
employee
employee system database
database
page
retrive()
display all users()
42
SD for view users
employee
employee system database
database
page
retrive()
dis play all use rs()
register
registration form
no
registration
form==valid
yes
store in DB
43
Figure 3. 18 Activity Diagram for Register
login
no
Username and
password==DB
yes
customer login
current service
view from DB
customer login
add service
no
Add service
form==valid
yes
store in DB
44
customer login
pay bill
no
Pay bill
form==valid
yes
update DB
customer login
send complaint
complaint form
no
Complaint
form==valid
yes
save in to DB
45
customer/employee/
admin login
change password
no
The form==valid
yes
save in to DB
admin login
deactivate account
account table
deactivate
update DB
46
admin login
add account
no
Account
form==valid
yes
save in to DB
employee/admin
login
view report
view from DB
employee/admin
login
view complaint
view from DB
47
employee login
generate bill
update in to DB
employee login
generate report
update in to DB
employee login
assign service
update in to DB
48
employee login
stop service
update in to DB
employee login
view bill
retrive from DB
employee login
view users
retrive from DB
49
employee login
add news
no
Add news
form==valid
yes
store in DB
employee login
import
import form
no
Import
form==valid
yes
store in DB
51
CHAPTER FOUR
4. SYSTEM DESIGN
System design is the transformation of the analysis model into a system design model. During
system design, developers define the design goals of the project and decompose the system into
smaller subsystems that can be realized by individual teams. The result of system design is a model
that includes a clear description of each of these strategies, subsystem decomposition, and a UML
deployment diagram representing the hardware/software mapping of the system. This chapter
mainly concerned with the design part of all about the billing system.
Security:- Since the system hold an important information (data), the system require strong
security features to protect that valuable information i.e. not allow other users or unauthorized
users to access data that has no the right to access it.
Performance: - They should have a fast response time (real time) with maximum throughput. In
the case of the timetabling subsystem, the system should be more reliable in order to satisfy the
constraints than fast response time.
Maintenance:-The system should be easily extensible to add new functionalities at a later stage.
It should also be easily modifiable to make changes to the features and functionalities.
Fault Tolerance:-The system should be able to give response (error message) When the user
enter incorrect input. This recommends the user to enter correct input.
Throughput:-Since electric billing system has web application it is able to perform many tasks
at any time.
Robustness: - The system has the ability to survive wrong applicant inputs. Besides this end
applicant that use electric billing system site have limited access regarding info about applicant
(like name phone no, email address).
52
Modifiability:-The proposed system able to handle applicant data based on selected service
centre such as electric service.
Usability: - electric billing system provide easy user friendly interface for users of the systems.
Admin,
Employee and
Customer.
53
Admin user account
add account
deactivate account
View complaint
View report
Assign service
View user
Generate report.
Generate bill.
Change password.
View bill
Import
Stop service
View report
Register
Current service
Pay bill
Change password
Send complaint
54
modelling technique, one that focuses on identifying the behaviour within our system, behaviour
specified to the instances of a single class. It tries to show different state that an object passes
through its life span. However, it is not necessary to build state chart for every class in the
system; only state charts of complex objects are necessary to be modelled. State chart diagram
enables us to observe the state of complex that simplifies.
4.5Collaboration Diagram
Collaboration diagram represent a combination of information taken from class, sequence, and
use case diagrams describing both static structure and dynamic behaviour of a system.
55
Collaboration diagram show the message flow between objects in an object oriented (OO)
application, and also imply the basic associations or relationships between classes. The rectangle
represent the various objects involves that make up the application, and the line between the
classes represents the relationships (association, aggregation, composition, dependencies, or
inheritance).Use a collaboration diagram (collaboration diagram: An interaction diagram that
shows, for one system event described by one use case, how a group of objects collaborate with
one another.) to show relationships among object roles such as the set of messages exchanged
among the objects to achieve an operation or result.
9: check ()
6: validate ()
Login form Database
10: response ()
User
Interface (UI)
56
Figure 4. 5 Collaboration diagram for view report
57
Generate report.
Generate report
Form Link
3: Bill Officer/Employee
1: Employee click link ()
Fills the form ()
6: return to step 3 ()
9: 9.response ()
: Employee/Bill officer
4: Report ()
5: validate () 8: check ()
58
appear as nested boxes. A single node in a deployment diagram may conceptually represent
multiple physical nodes, such as a cluster of database servers.
59
Figure 4.8 Persistent data storage
60
Figure 4. 10 User interface for Admin page
61
CHAPTER FIVE
5.2Recommendation
We strongly recommend that one who under goes through this project can succeed, and they pay
attention for Dire Dawa electric power billing. Most of the time has been taken for understanding
the working of existing system, how applications are written in existing system and how a third
party tool can be integrated in this system. The final recommendation towards the target group
who need to work on and improving it can even think of different Billing system entirely developed
for every country. If anybody can their will be functional interface that we didn’t do so using our
project as a source you can improve your own system.
62
Reference
1. G. Booch, Object-Oriented Analysis and Design with Applications,2nd edition, 1994.
2. M. Fowler, UML Distilled: A Brief Guide to the Standard Object, Third Edition.
3. S. Kendal, Object oriented programing using java, 2009.
4. Carlos Coronel, Steven Morris, and Peter Rob, Design, Implementation, and
Management, Ninth Edition, Joe Sabatino.
63
Submitted by:
Approved by:
64