RADIANT CENTRAL CHILDREN
ACADEMY
Academic Year : 2024-25
PROJECT REPORT ON
BILL MANAGEMENT
ROLL NO. :
NAME : ANUSHKA
MAURYA
CLASS : XII – B
SUBJECT : COMPUTER
SCIENCE
SUB CODE : 083
PROJECT GUIDE : MR. DILEEP YADAV,
RADIANT CENTRAL
CHILDREN ACADEMY,
JALALPUR, AMBEDKAR
NAGAR
CERTIFICATE
CLASS : XII – B YEAR :
2024-25
This is certify that Investigatory Project is
successfully completed by Anushka
Maurya of class : XII-B
Roll No.: for the academic year
2024-2025 in the school computer lab.
Head Teacher External
Internal Examiner
Signature: Examiner: (Subject
Teacher):
Date: / / Department of :
Computer Science
Principal:
ACKNOWLEDGEMENT
I, Anushka Maurya of class : XII-
B, Roll No:
would like to express my
sincere gratitude to my computer
science teacher Mr. Dileep Yadav,
PGT COMPUTER SCIENCE, for his
vital support, guidance and
encouragement – without which this
project would not have come forth.
I would also like to express my
gratitude to my school Radiant
Academy for letting me use the
school laboratory.
INDEX
Brief Overview of project
Need of Computerization
Software and hardware
requirement
Advantage of Project
Limitations of Project
Source Code of Project
Output Screening
Future Enhancement of Project
Bibliography
BRIEF OVERVIEW
Bill management system is developed using
python. While using this bill management
system we con easily calculate total bill of the
customer. Moreover, the total bill is calculated
including service charge and state tax.
All you have to do is to just fill the questions
asked by the computer with item and
quantities. The program will display your total
bill with number of items purchased.
There is no error and warning content in this
project. This design is so simple that user won't
find it difficult to use and navigate
INPUT DATA AND VALIDATION OF
PROJECT
All the fields such as sales payments discounts
are validated and do not take invalid values.
Each form of sales, discounts, stock cannot
accept the blank values.
Avoiding errors in data.
Controlling amount of given data.
SOFTWARE AND HARDWARE
REQUIREMENTS
Data file handling: It has been effectively used
in the program. The database is a collection of
interrelated data to serve multiple applications.
That is database programs create files of
information. So we see that files are worked with
most, inside the program.
DBMS: The software required for the management
of data is called as DBMS. It has 3 models:
1.Relation model
2.Hierarchical model
3.Network model
1. RELATIONAL MODEL: It’s based on the
concept on relation. Relation is the table that
consists of rows and columns. The rows of the
table are called tuple and the columns of the
table are called attribute. Numbers of rows in the
table is called as cardinality. Number of columns
in the table is called as degree.
2. HIERARCHICAL MODEL: In this type of model,
we have multiple records for each record. A
particular record has one parent record. No chide
record can exist without parent record. In this,
the records are organized in tree.
3. NETWORK MODEL: In this, the data is
represented by collection of records and
relationship is represented by (ink or association.
CHARACTERISTICS OF
DBMS
o It reduces the redundancy.
o Reduction of data in inconsistency.
o Data sharing.
o Data standardization.
DIFFERENT TYPES OF FILES: -BASED
ON ACCESS
oSequential file.
oSerial file.
oRandom (direct access) file
BASED ON STORAGE- Text file &
Binary File.
Need of computerization
Bill management is a python based project
and we have developed bill management
system using mysql and mysql connector.
It is easy to operate and understand by
users. The calculations of bills is done in a
short period of time and it's not time
consuming. It ensures accurate records
and minimizes the inevitable and costly
errors with manual data enter.
This accurate data helps to provide
accurate performance and payroll data.
Most bill management system is built
around highly secure system and highly
reliable and secure and can help prevent
time theft and administrative costs
stemming. With just few clicks we can
generate accurate reports on hours
worked.
Software programs constantly evolve. A
program used today may be obsolete
within several years. Being trained on
today's software does not guarantee it will
be used when you are ready to go out into
the field. Understanding calculations is
timeless, as is computer competency.
Software, however, shifts rapidly.
MERITS
It generates the report on the number of
items purchased by customer.
Provides filter report on payments,
Inventory and products.
We can easily export PDF on products
sold.
Applications can also provide excel export
for sales and discounts.
It deals with monitoring the information
and transaction of products.
It increases the efficiency of managing
sales and discount.
It has higher efficiency of editing, odding
and updating.
Demerits
Excel export has not been developed for
products sold.
The transactions ore executed in offline
mode only.
Online transactions for sales, discounts, or
other data modifications are not possible.
Offline reports of sales, products, discounts
and stocks cannot be generated due to
batch mode execution.
Future enhancements
The process of gathering information, diagnosing
the problems, then interpreting facts is known as
System analysis. It also includes recommending
system improvements needed, based on the same
data.
The system is observed as a whole; the inputs
need to be identified firstly before turning them
and then the system is subjected to study as a
whole to identify the problem areas.
Although tunings any system as a whole is a
complex procedure, but tuning individual
statements is not the best as something that is
correct for one input may hurt another inputs
performance.
The solutions are given as a proposal. The
suggestion is revised on user request and optimal
changes are made. This loop terminates as soon as
the user is gratified with the proposal.
So on the whole, system analysis is done to
improve the system performance by monitoring it
and obtaining the best throughput possible from
it. Therefore system analysis plays a crucial role in
designing any system.
Bibliography
Sumitaarora
Sultan chand
https://www.w3schools.com
https://dev.mysql.com
Radiant Academy
Investigatory Project on
Bill Management
Submitted by : Anushka Maurya
Class : XII-B
Roll No. :
