SIKKIM MANIPAL UNIVERSITY<\/p>\n
SYNOPSIS<\/p>\n
ON<\/p>\n
\u201cMTNL BILLING SYSTEM\u201d<\/p>\n
Submitted in partial fulfillment of the requirements for qualifying<\/p>\n
MSC(IT)<\/p>\n
SUBMITTED BY<\/p>\n
NAME :<\/p>\n
ENROLLMENT NO :<\/p>\n
UNDER SUPERVISION OF:<\/p>\n
TITLE OF THE PROJECT<\/p>\n
OBJECTIVES OF STUDY<\/p>\n
Objective<\/p>\n
This project is designed to achieve the following objectives:<\/p>\n
To make the processing of MTNL Billing system easier & faster. Also to generate various types of reports requested by the user of the application. It contains the following features:<\/p>\n
The whole system should be menu driven & the main menu should be displayed automatically as soon as the user logon succeeds.<\/p>\n
The software must have a user-friendly interface & appealing appearance to ease the work of the end users.<\/p>\n
The system should be able:
\n\u2022 To maintain consumers details
\n\u2022 To maintain bills paid by the consumers
\n\u2022 To add complaints, to assign complaints to the engineers and update the status of the complaints.
\n\u2022 To add new installations and connections.
\n\u2022 Update disconnections.<\/p>\n
Above all the software system should be able to eliminate all the paper work required in implementation the task of data maintenance, which previously was tedious, time consuming and error prone.<\/p>\n
PROBLEM STATEMENT<\/p>\n
This is a Project work undertaken in context of partial fulfillment of the BCA.
\nMTNL has recognized that IT is the key to future business success. IT is being implemented as the backbone for running customer friendly services. Several IT systems and accounting and billing systems are already operational at MTNL.
\nExisting MTNL billing system had problems right from the beginning. Not only has the billing system worked erratically since, but also following the launch of services the subscribers (not many to begin with) were also not issued bills for months together. All due to some software problems,” the sources noted.
\nThe billing system was working slowly and it was not possible to generate automatic disconnection list due to non-payment, complaint details etc. with the result that timely disconnection was not possible. All these factors resulted in heavy outstanding.
\nApart from this, many subscribers continued to make heavy calls and then migrate to other mobile operators, leaving heavy outstanding amounts with MTNL.
\nThey pointed out the problems in the billing system that continued and these include delayed implementation of roaming module, provisioning of credit control and service interface which continues to throw up sporadic mistakes in billing generation.
\nThe present system also does not allow for monitoring of cases with outstanding payments, automatic generation of payment reminders, automatic disconnection and reconnections.
\nWith the result, the outstanding dues of MTNL have only mounted.<\/p>\n
TOOLS\/PLATFORMS, HARDWARE & SOFTWARE REQUIREMENTS<\/p>\n
HARDWARE:
\nProcessor : Pentium 2.4 GHz or above
\nMemory : 256 MB RAM or above
\nCache Memory : 128 KB or above
\nHard Disk : 3 GB or above [at least 3 MB free space required]
\nFloppy Disk : 3.5\u201d with 1.44 MB capacity
\n[at least one drive labeled A: required]<\/p>\n
SOFTWARE:
\nOperating System : Windows 95\/98, Win NT, Win 2000.
\nFont-End Tool : VISUAL BASIC .NET
\nBack End Tool : SQL SERVER<\/p>\n
FRONT END:
\n\u2022 Visual Basic .NET is one of the languages that are directed towards meeting the objectives of the .NET initiative of creating distributed applications.
\n\u2022 Visual Basic .NET is a powerful object-oriented language that provides features such as abstraction, encapsulation, inheritance, and polymorphism.<\/p>\n
Features of Visual Basic .NET
\n\u2022 Some of the key features of Visual Basic .NET are as follows:
\no Inheritance
\no Constructors and destructors
\no Overloading
\no Overriding
\no Structured exception handling
\no Multithreading<\/p>\n
SQL SERVER<\/p>\n
Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. It provides an environment used to generate databases that can be accessed from workstations, the web, or other media such as a personal digital assistant (PDA). Microsoft SQL Server is probably the most accessible and the most documented enterprise database environment right now. This also means that you can learn it a little quicker than most other database environments on the market.<\/p>\n
METHODOLOGY AND TOOLS USED<\/p>\n
Advent of computers in the last two decades, every organization is going under the process of computerization. The computerization has many benefits. Primarily, a computer is helpful in four major aspects of any kind of organization:
\nTime Efficiency
\nCost Effective
\nHuge data storage capacity and
\nSimple operation<\/p>\n
Moreover, with the advent of the Internet technologies, World have changed lot call it the social web. Through the dot COM bubble and bust, one trend has never wavered. Every year, millions more people around the world are using the internet to interact in more ways then ever before to date, find old classmates, check on medical elements and cures, to read and express alternative views of the news, and even to give live sales help online, and in so many other areas.<\/p>\n
We have several alternative suggestions about the project category like: desktop application, web-based application, OOPs application, Networking, RDBMS etc. Out of available one we have opted Web based application based on client server architecture. The proposed system falls into the category of Multimedia. A web based system has two types of pages one is static web pages and another are dynamic web pages, which are saved on web server and can be seen by sending request to web server through HTTP protocol.<\/p>\n
Static web pages: – Static web pages are easy to spot sometimes we can pick them out by just looking at the content of the page. The content (text, images, hyperlinks, and so on) and appearance of static web pages is always the same regardless of who visits the page, or how and when they arrive at the page, or any other factors.<\/p>\n
Dynamic web pages: – The dynamic web pages are web pages, which we can interact like a time is shown on the page or we are sending information through web form, online chat, sending mail on net etc all the action this action performed with the help of dynamic web pages.<\/p>\n
Web Server: – Web server are software that manage web pages and make them available to client browser via local network or over the internet. In the case of the internet, the web server and browser are usually on two different machines, possibly many miles apart. However, in a local situation you can set up machine that runs the web server software, and then use a browser on the same machine to look at its web pages.<\/p>\n","protected":false},"excerpt":{"rendered":"
SIKKIM MANIPAL UNIVERSITY SYNOPSIS ON \u201cMTNL BILLING SYSTEM\u201d Submitted in partial fulfillment of the requirements for qualifying MSC(IT) SUBMITTED BY NAME : ENROLLMENT NO.<\/p>\n","protected":false},"author":1,"featured_media":578,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[731,732],"tags":[733,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730],"yoast_head":"\n