DESIGN AND DEVELOPMENT OF AN E-BILLING SYSTEM

ABSTRACT

The project is to create an application that should provide service to the user, collect user usage records, and generate invoices of each credit expire, each billing cycle depends on the billing type, collect payments and adjust customers' balances.

The e-Billing system has the capacity to illustrate and analyze the basic billing system and the main functionalities that surround the billing system from a business prospective and explains how each interacts to complete the billing cycle.

Also, development of a billing system emulator that is capable of can billing more quickly, accurately and update customer record and enables customer to view bill information.

This Billing system can be deployed in a real world situation. For example, it could be implemented for a telecommunication company to have effective billing of the customer and it could also be deployed as contractor to already existing networks.

Hopefully, at the end of the day the program will be able to satisfied the under listed objectives that would bridge the gap on short coming in the billing system

1.      Services: Service is the entity offered by the company and targeted to the customers.

2.      Accounts: The customer account includes customer contact profile information, account type, login information, and payment method

3.      Ratings: Rating is the process of converting usage records from one form to another, like converting usage units to its cost.

4.      Payments: Each customer in the system has an account balance, which affects any invoices requested by the customer and any payments done by the customer.

5.      Invoices: It is the entity generated by the billing system to inform the customer that he must pay for his service usage or ordering

TABLE OF CONTENTS

CHAPTER ONE: INTRODUCTION                                                                               

1.1      Background Information

1.2           Statements of Problem

1.3      Aims and Objectives   

1.4           Methodology

1.4.1     Deployment

1.5        Significance of Study  

1.6           Limitations

1.7      Organization of Report

CHAPTER TWO: LITERATURE REVIEW                                                                 

2.1 Introduction

2.2 Brief History

2.3 Past Project On The Billing System

2.4 Problem Of Existing System

2.5 Characterstic Of The Proposed System

2.6 The Billing System

2.7 Billing Types

2.8 Structures For Tariff And Charging

2.9 Database  

2.9.1 Database Server

2.9.2 Relational Database Management System

2.10 Programming

2.10.1 Object-Oriented Programming

CHAPTER THREE:            ANALYSIS AND DESIGN

3.1      Introduction

3.2      System Analysis

3.3      The E-Billing And Invoice System Emulator Overview

3.4      Requirements Specification

3.4.1   Functional Requirements

3.4.2   Non-Functional Requirements

3.4.3   User Requirements      

3.4.4   System Requirements

3.5      System Design 

3.5.1   System Modeling

3.5.1.1 Use Case

3.5.1.2 Sequence Diagram

3.5.1.3 Activity Flow Diagram

3.5.1.4 Class Diagram

3.5.2   Database Design

3.5.2.1 The User Info Table   

3.5.2.2 Data Plans Table

3.5.2.3 Logs Table

3.5      Summary         

CHAPTER FOUR: SYSTEM IMPLEMENTATION AND TESTING           

4.1      Introduction

4.2      The System Requirements       

4.2.1   Software Requirement

4.2.2   Hardware Requirements          

4.3      Software Implementation

4.4      Software Testing

4.5             Database Implementation

4.6          Summary        

CHAPTER FIVE: CONCLUSION AND RECOMMENDATION

5.1     Summary         

5.2      Achievements  

5.3      Challenges And Constraints

5.4      Conclusion

5.5      Recommendation

List of Figures

List of Tables

Reference

Appendix

CHAPTER ONE

INTRODUCTION

E-billing is the delivery of electronic bills to end consumers (B2C) and providing a payment option for them [1] and it can simply be explained as a technology which enables the replacement of paper with electronic documents delivered through email or a website [8].

Telecommunication Billing is a process of collecting credit usage, aggregating it, applying required charges and finally generating invoices for the customers.Telecom Billing process also includes receiving and recording payments from the customers.[2]The billing process involves receiving billing records from various networks, determining the billing rates associated with the billing records, calculating the cost for each billing record, aggregating these records periodically to generate invoices, sending invoices to the customer, and collecting payments received from the customer[2].

1.1       BACKGROUND INFORMATION

What is the billing system?

The billing systems process the usage of network equipment that is used during the service usage into a single Call Detail Record (CDR) [1]. In GSM 1900, traditionally in North America, the mobile user pays for both incoming and outgoing calls. The reason being that one subscriber cannot tell if the other subscriber is a mobile subscriber because of the American integrated numbering plan [2].  GSM specifications do not govern tariffs or packages because each operator decides this. This project will be focusing on billing system and the main difference between common and basic billing system usually used in telecommunication. It will involve analyzing the basic billing system from a management and business point of view and describing the basic functionalities.

We can divide the system into five parts as follows [1]:

1.      Services: Service is the entity offered by the company and targeted to the customers.

2.      Accounts: The customer account includes customer contact profile information, account type, login information, and payment method

3.      Ratings: Rating is the process of converting usage records from one form to another, like converting usage units to its cost.

4.      Payments: Each customer in the system has an account balance, which affects any invoices requested by the customer and any payments done by the customer.

5.      Invoices: It is the entity generated by the billing system to inform the customer that he must pay for his service usage or ordering.

1.3        STATEMENTS OF PROBLEM

·          Get Full Material