17-01-2013, 03:45 PM
Supermarket Billing System
![Adobe Acrobat PDF .pdf](https://seminarproject.net/images/attachtypes/pdf.gif)
Introduction
The project is on Supermarket Billing. Supermarket is the place where
customers come to purchase their daily using products and pay for that. So
there is a need to calculate how many products are sold and to generate the bill
for the customer.
In our project we have 3 users. First is the data entry operator who will enter
the products in database. Second one is the administrator who will decide the
taxes and commissions on the products and can see the report of any product.
Third one is the bill calculating operator who will calculate the bill and print.
Objective
“To make software fast in processing, with good user interface so that user
can change it and it should be used for a long time without error and
maintenance.”
Work Flow
Work in the Supermarket will be done in the following way:
1. The product will come in the store.
2. Data entry operator will enter the information of the product in
database.
3. The Administrator will enter the taxes and commissions for each
product.
4. The customer will come and take the basket with him/her and choose
the product and took it to the counter.
5. The bill calculating operator will check the products with the bar code
detecting machine then it will match with product-id then it will show
its information and price and the bill will be calculated and total
payment will shown.
6. Customer will pay for the products.
7. All the products will be packed and delivered to the customer.
Database
Database is used to store data on the computer and fast retrieval of the data so
we use Oracle 8i. We will make database by entering values in different tables
like tables for the login-id, products in the store, etc.
Programming Languages
We will use following languages for the coding:
Front End: Visual Basic 6
Back End: Microsoft Access
Description of the Existing System
Many Supermarkets use this type of billing system for a decade. It is also
improved many times according to requirements of sellers and customers. It
does the same work that is calculating the bill, gives it to the customer and
maintain proper database. They are accurate in calculation and printing, they
also generate records.
A new concept is also added in the billing system is that they also maintain
relationships with the customers who purchase more products from the store
regularly. System also concerns their requirements and gives them more
commission. It also shows the overall profit and profit on a particular product
and give repots which items are required and which have cross their expiry
date.
Advantages of the Proposed System
To reduce the bottlenecks of the existing system there is a need to develop a
new system. The new system should concern the requirements of the customer
and the sellers. It has the following qualities:
1. Reduction in processing cost.
2. Error reduction.
3. Automatic posting.
4. Improve reporting.
5. Automatic production of the documents and Reports.
6. Faster response time.
7. Ability to meet user requirements.
8. Flexibility.
9. Reduced dependency.
10.Improves resource uses.
11.Reduction in use of the paper.
12.Reduction in Man Power.
Front-End Selection:
Front-End means a language that is used
for user interface designing and coding. Front-End should have following
qualities:
It must have a graphical user interface that assist employees that are not
from some IT background.
Scalability and Extensibility
Robustness
According to the organization requirements and culture.
Must provide excellent reporting features with good printing support.
Platform independent.
Easy to deploy and maintain.
Event driven programming.
Front-End must support some popular Back-End like MS Access, SQL
Server and Oracle.
Operational Feasibility:
In this feasibility we consider following points:
1. What changes will be brought with the system.
2. What new skills will be required? Do the existing staff members have
these skills? If not, can they be trained in due course of time?
In the new system we made some major changes for the staff members so that
they have to be trained to use the newly added facilities. These major changes
are possible and give a new era in the Supermarket in production and sales
management.