A PROJECT REPORT ON
CABLE OPERATING MANAGEMENT SYSTEM
BY:-
ACKNOWLEDGEMENT
INDEX
1. INTR0DUCTION
2. SYNOPSIS
3. COMPANY PROFILE
4. PROJECT PROFILE
5. STUDY OF EXISTING SYSTEM
STUDY OF EXISTING SYSTEM
PROBLEM TO EXISTING SYSTEM
6. PROPOSED SYSTEM
7. SYSTEM ANALYSIS
8. SYSTEM DESIGN
9. CONCLUSION
INTRODUCTION
Cable Operator Management System is integrated and automation software for
cable operators. Cable operators will distribute TV channels to their customers
for that they charge some money monthly.
The objectives of the system are to make the cable accounting automated and
simpler then it is done manually. The connections accounts and transactions
are entered on computers and saved on computers and can be accessed as in
the form of the reports and can be updated very easily on computers.
In this system there are many accounts in the number of hundreds to
thousands. So, It is quite difficult to manage their accounts and transactions in
account books.
Also new trend of Pay Channels came, so the management of this Pay
Channels also can be done in this automated cable system.
By using this COM System they can know about their equipment's located on
which areas. How many active / non active customers are there? all these
details they can view it by using the reports. MIS reports were generated for
the month of collections, expenses, pending amount, complaints area wise and
date wise, month wise.
SYNOPSIS
• PROJECT TITLE :- Cable Operating Management System
• COMPANY NAME :-
• TECHNOLOGY :- VISUAL BASIC 6.0/ MS Access
• TEAM MEMBERS :- Qasim Arthuna
Burhanuddin Sikandar
• OBJECTIVES / AIMS :- The objectives of the system are to make the cable
accounting automated and simpler then it is done manually. The connections
accounts and transactions are entered on computers and saved on computers and
can be accessed as in the form of the reports and can be updated very easily on
computer.
To automate the manual system
To make the system User-friendly
Proper Validation technique to be used
Reports should be designed as it gives perfect view of required data
Proper security to the data for the access
Report Printing Facilities
INTRODUCTION TO COMPANY
• COMPANY NAME :- QB CABLE VISION
• COMPANY ADDRESS :- 523,KONDHWA KHURD,PUNE,411048
• ESTABLISHED IN :- YEAR 2000
ABOUT US :-
QB CABLE VISION is the organization which provides cable
services within the area of Kondhwa and area surrounded by Kondhwa. Mr.
Qasim Arthuna and Mr. Burhanuddin Sikander handle the company. The
company has more than 5000 connections in that area and it is started since 19
years back.
These companies had 3000 connections before two partners of Kodhwa
merged into QB CALBE Vision and strengthen the company. In near future
they are adding more connections by merging two other cable operators and
the total connections increase up to 6000.
Hardware and Software Specifications
v Hardware Specifications
Processor :
RAM :
Hard Disk :
Monitor :
Printer : Inkjet Printer
TV Tuner Card :
v Software Specifications
Operating System: Windows 10
Front End : Visual Basic 6.0
Back End : M.S. Access 2007
Report Designer : Crystal Reports (CRW32 4.6.1.116)
STUDY OF EXISTING SYSTEM
All the work cable operator used to maintain manually in books,vouchers,
collection cards etc.
Till yet they are using the manual system to maintain the connections
accounts and transactions manually. They are keeping the account books
for the transactions and connections. It is too tedious and complex task
for them to maintain more than 5000 accounts and each month they have
many transactions done. They are providing yearly and also monthly
connections on pay scheme. So it makes it more complex task.
They had tried to prepare software for accounting in FoxPro, but it is not
giving satisfactory results. So they still use that manual system. Also pay
channel trend causes more problems to keep the data of pay channels
record.
Problem with the Existing System
The Existing system being manual is slow and moreover its very
difficult to access the reports of connections and transactions. Thus
for accurate and fast retrieval of reports the system was to be
automated.
By automating there will not be any problems for keeping account
books for the transactions and connections. View of data is more
simply visualized. Security of the data and access to data to be
maintained efficiently. The system has to be more users friendly. The
updating must be automated and the reports of the system must be as
the user requirements.
It also take much more time to maintain such record, and it take high
amount of additional effort to keep and maintain such record.
Possibility of errors is likely in documents because of human handling
of data.
As few of things are handled manually, some formalities are not
actually prepared.
Proposed System
The objectives of the system are to make the cable accounting automated
and simpler then it is done manually. The connections accounts and
transactions are entered on computers and saved on computers and can
be accessed as in the form of the reports and can be updated very easily
on computers.
In this system there are many accounts in the number of hundreds to
thousands. So, It is quite difficult to manage their accounts and
transactions in account books.
Also new trend of Pay Channels came, so the management of this Pay
Channels also can be done in this automated cable system.
The attention to the objectives:
To automate the manual system
To make the system User-friendly
Proper Validation technique to be used
Reports should be designed as it gives perfect view of required data
Proper security to the data for the access
Report Printing Facilities
FEATURES OF PROPOSED SYSTEM
v Powerful Reporting Facility
The system provides efficient reports for the user to view data. Different types of reports are available to retrieve
data from the tables having a very good design and visualizations. Facility of printing reports is available.
v Direct Updating
The updating in the table while executing the system is done directly that user doesn’t have to update manually.
Deletions and Updating by Cancellation Date and Due Date is made automated.
v User-friendliness and better Visualization of Information
Maximum efforts have been made to make the system user-friendly. The information has been displayed in a very
simple manner so that the user can gain maximum of information and interpret it easily.
v Security
The entire users have been provided their login name and passwords. For security no other user can enter in the
system to access the data other than the partners of the organization or the employee who is the user of the system.
v Additional Channels’ Management
. The additional module of channels’ is provided in the system and the reports on due of channels and on pay
channels are provided in the system. To print the list of channels reports are added
v New Transaction File
At each new transaction year the new transaction file is made. And the whole record of last 5 years is kept in other
file. The records are directly deleted if the connection is cancelled from that temporary record file.
v Informational Messages
The system gives the informational messages at each updating and errors in validation and also in deletion. So
that the user can easily find that which error occurs and Is updating is done in the table or not.
LIMITATIONS OF PROPOSED SYSTEM
Computers have to be brought and installed which could be costly for
some organisations.
Implementation of the system calls for employment a person has
knowledge about computers.
A customized software has to be made according to system
requirements, which might be costly.
Once the data lose, there is no guaranty of data recovery will be made.
THE HARDWARE AND SOFTWARE REQUIREMENTS
MINIMUM HARDWARE CONFIGURATION :-
PROCESSOR 64 BIT
RAM (MIN 1GB)
PRINTER
HARDISK
CD-ROM
SOFTWARE REQUIRED :-
VISUAL BASIC 6.0
MICROSOFT ACCESS 2007
Requirement Analysis
FACT GATHERING TECHNIQUES
1. Interviewing :-
Interviewing allows information from individual or existing group who are generally the current
users of existing system or potential users of the proposed system. They may be manager or employees of
the firm itself who provide the data for the proposed system and who will be affected. It allows the analyst
to analyze and discover areas of misunderstanding, indication of Resistance to proposed system.
SOME OF THE QUESTIONS ASKED WERE:
1.What was the problem of Existing System?
2.What are the changes you require in new system?
3.What language would you like to build project?
4.What should be the BACKEND tools?
5.What should be the FRONTEND tools?
6.What are the overall CONNECTIONS of company?
7.What are the FREE CHANNELS?
8.What are the PAID CHANNELS?
9.How the final Bill is calculated?
FACT GATHERING TECHNIQUES
2. Questionnaires :-
Questionnaires were used as a supplement to interviews. More people can be reached
and answers can be corroborated. Questionnaires can be considered as a structure interview form.
Since the cost involved in developing and distributing was very high the following.
Points were kept in mind while designing questionnaires.
1) The objective of the questionnaires must be made clear.
2) The structure must be useful for the study.
3) Questions must be easily and unambiguously understood.
4) The respondent must be carefully selected.
5) The responses received must be analyzed scientifically.
Some of the questions included in questionnaires were:
1) What are the major problems in the existing system?
2) What are the minor problems in the existing system?
3) What is the requirement for the new system?
4) What will be the benefit of the proposed system over the existing system?
5) What is the monthly and yearly income and expense of the company?
DETAILED DESIGN
ENTITY REALATIONSHIP DIAGRAM (ERD)
DETAILED DESIGN
ENTITY REALATIONSHIP DIAGRAM (ERD)
DETAILED DESIGN
DATA FLOW DIAGRAM (DFD)
DETAILED DESIGN
DATA FLOW DIAGRAM (DFD)
DETAILED DESIGN
SYSTEM DESIGN
CONCLUSION
THANK YOU….
