17.Project-SuperMarket Billing System
17.Project-SuperMarket Billing System
17.Project-SuperMarket Billing System
Jaipur
Project on
By
Ankita Aggrawal
Neha Chaturvedi
Devendra Singh Sisodia
(Students of MCA IV- Semester, Group No. 20)
Under
Mr. Vijay Singh Rathore
Assistant Professor
IIIM
Synopsis
of
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.
Modules
We will use 5 modules in this project. These are as follows:
Module 1: Login–Id
This module is made for the login of users. We know that we have 3 users so
login-id is for:
1. Administrator
2. Data Entry Operator
3. Bill Calculating Operator
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
SOFTWARE REQUIREMENTS
SPECIFICATION
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.
Feasibility Study
“Feasibility Study” is a test of the system according to its workability, impact
of the organization, ability to meet user needs and effective use of the
resources.
We can test our system by different type of the feasibilities. There are 5 types
of the feasibilities which are discussed here. These are as follows:
1. Technical Feasibility:
A study of resources availability that may affect the ability to achieve an
acceptable system. This evaluation determines whether the technology needed
for the proposed system is available or not. This system can be made in any
language that support good user interface and easy database handling.
Technical needs may include:
2. Economical Feasibility:
In this we consider following costs:
1. The cost to conduct a full system investigation.
2. The cost of hardware and software for class of application being
considered.
3. The benefit in the form of the reduced cost.
3. 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.
4. Schedule Feasibility:
Time evaluation is most important consideration in development of the project.
So the project is concerned should be completed with fixed in scheduled time
as far as company is concerned. New system is not so much big so it is easy to
make in few days.
5. Behavioral Feasibility:
People are inherently resisted to change and a computer means “change is the
only certainty”. An estimate should be made of how strong a reaction the user
staff in going to have towards development of new system. Thus special efforts
can be made to educate and train the staff.
SCREEN SHOTS
Project on Supermarket Billing System
Coding
Private Sub Command1_Click()
Unload Me
End Sub
Change Password
Coding
Dim db As Database
Dim rs As Recordset
Dim style As VbMsgBoxStyle
Dim result As VbMsgBoxResult
Purchase Product
Coding
Dim style As VbMsgBoxStyle
Dim result As VbMsgBoxResult
Dim db As Database
Dim rs As Recordset
Dim db1 As Database
Dim db4 As Database
Dim db2 As Database
Dim rs2 As Recordset
Dim rs1 As Recordset
Dim rs3 As Recordset
Dim rs4 As Recordset
Dim rs6 As Recordset
rs3.MoveNext
Wend
End Sub
End Sub
Private Sub Command2_Click()
rs2.AddNew
rs2!product = Text7.Text
rs2!dealer = Text1.Text
rs2!dealerprice = Text2.Text
rs2!quantity = Text3.Text
rs2!Weight = Text4.Text
rs2!sellingprice = Text6.Text
rs2.Update
result = MsgBox("Saved Successfully.", style, "Supermarket Billing 1.0")
Unload Me
Load Form10
Form10.Show
Form10.Move 0, 0
End Sub
'rs2!code = Text1.Text
rs2!Weight = Text2.Text
rs2!price = Text3.Text
rs2!quantity = Text4.Text
rs2!totalprice = Text5.Text
rs2!Date = Text8.Text
rs2!Time = Text9.Text
rs2.Update
Beep
Beep
rs4.AddNew
rs4!customernumber = Text7.Text
rs4!customername = Text10.Text
rs4!itemnumber = Text6.Text
rs4!product = Combo1.Text
'rs4!code = Text1.Text
rs4!Weight = Text2.Text
rs4!price = Text3.Text
rs4!quantity = Text4.Text
rs4!totalprice = Text5.Text
rs4!Date = Text8.Text
rs4!Time = Text9.Text
rs4.Update
List1.AddItem Text6.Text
List2.AddItem Combo1.Text
'List3.AddItem Text1.Text
List4.AddItem Text2.Text
List5.AddItem Text3.Text
List6.AddItem Text4.Text
List7.AddItem Text5.Text
b=0
For a = 0 To List7.ListCount - 1
b = b + Val(List7.List(a))
Label19.Caption = b
Next a
i=i+1
Text6.Text = i
End Sub
i=1
Text6.Text = i
j=0
Text7.Text = j
End Sub
Private Sub Label5_Click()
End Sub
+
Login
Coding
Dim db As Database
Dim rs As Recordset
Dim style As VbMsgBoxStyle
Dim result As VbMsgBoxResult