ACADEMIC YEAR : 2024-25

PROJECT REPORT ON
GROCERY SHOP MANAGEMENT SYSTEM

ROLL NO :
NAME :
CLASS : XII
SUBJECT : INFORMATICS PRACTICES
SUB CODE : 065

1
 CERTIFICATE

This is to certify that __________________________ has successfully

completed the project Work entitled GROCERY SHOP MANAGEMENT in the subject

INFORMATICS PRACTICES (065) laid down in the regulations of CBSE for the

purpose of Practical Examination in Class XII to be held in PADMAVATHI

VIDYALAYA , SULLURUPETA

Examiner:

Name: _______________

Signature:

TABLE OF CONTENTS [ T O C ]

2
SER DESCRIPTION PAGE NO

01 ACKNOWLEDGEMENT 04

02 INTRODUCTION 05

03 OBJECTIVES OF THE PROJECT 05

04 PROPOSED SYSTEM 06

05 SYSTEM DEVELOPMENT LIFE CYCLE (SDLC) 07

06 PHASES OF SYSTEM DEVELOPMENT LIFE CYCLE 08

07 FLOW CHART 15

08 SOURCE CODE 16

09 OUTPUT 19

10 TESTING 20

11 HARDWARE AND SOFTWARE REQUIREMENTS 23

12 BIBLIOGRAPHY 24

3
 ACKNOWLEDGEMENT

Apart from the efforts of me, the success of any project depends largely on the
encouragement and guidelines of many others. I take this opportunity to express my
gratitude to the people who have been instrumental in the successful completion of
this project.

I express deep sense of gratitude to almighty God for giving me strength for the
successful completion of the project.

I express my heartfelt gratitude to my parents for constant encouragement while

carrying out this project.

I gratefully acknowledge the contribution of the individuals who contributed in

bringing this project up to this level, who continues to look after me despite my flaws,

I express my deep sense of gratitude to the luminary The Principal who has
been continuously motivating and extending their helping hand to us.

I express my sincere thanks to the academician The Vice for constant

encouragement and the guidance provided during this project

I am overwhelmed to express my thanks to The Administrative Officer for

providing me an infrastructure and moral support while carrying out this project in the
school.

My sincere thanks to my teacher ,Master In-charge, A guide, Mentor , who

critically reviewed my project and helped in solving each and every problem, occurred
during implementation of the project

The guidance and support received from all the members who contributed and
who are contributing to this project, was vital for the success of the project. I am
grateful for their constant support and help.

4
PROJECT ON GROCERY SHOP MANAGEMENT SYSTEM

INTRODUCTION

This software is used to maintain the shop customer detail, product details,

Worker detail maintain the shop in updated and maintain records of in and out data

of shop

OBJECTIVES OF THE PROJECT

The objective of this project is to let the students apply the programming

knowledge into a real- world situation/problem and exposed the students how

programming skills helps in developing a good software.

1. Write programs utilizing modern software tools.

2. Apply object oriented programming principles effectively when developing small

to medium sized projects.

3. Write effective procedural code to solve small to medium sized problems.

4. Students will demonstrate a breadth of knowledge in INFORMATICS

PRACTICES, as exemplified in the areas of systems, theory and software

development.

5. Students will demonstrate ability to conduct a research or applied

INFORMATICS PRACTICES project, requiring writing and presentation skills

which exemplify scholarly style in INFORMATICS PRACTICES

5
PROPOSED SYSTEM

Today one cannot afford to rely on the fallible human beings of be really wants

to stand against today’s merciless competition where not to wise saying “to err is

human” no longer valid, it’s outdated to rationalize your mistake. So, to keep pace

with time, to bring about the best result without malfunctioning and greater efficiency

so to replace the unending heaps of flies with a much sophisticated hard disk of the

computer.

One has to use the data management software. Software has been an ascent

in atomization various organisations. Many software products working are now in

markets, which have helped in making the organizations work easier and efficiently.

Data management initially had to maintain a lot of ledgers and a lot of paper work has

to be done but now software product on this organization has made their work faster

and easier. Now only this software has to be loaded on the computer and work can be

done.

This prevents a lot of time and money. The work becomes fully automated and

any information regarding the organization can be obtained by clicking the button.

Moreover, now it’s an age of computers of and automating such an organization gives

the better look.

6
SYSTEM DEVELOPMENT LIFE CYCLE (SDLC)

The systems development life cycle is a project management technique that

divides complex projects into smaller, more easily managed segments or phases.
Segmenting projects allows managers to verify the successful completion of project
phases before allocating resources to subsequent phases.
Software development projects typically include initiation, planning, design,
development, testing, implementation, and maintenance phases. However, the
phases may be divided differently depending on the organization involved.
For example, initial project activities might be designated as request,
requirements-definition, and planning phases, or initiation, concept-development, and
planning phases. End users of the system under development should be involved in
reviewing the output of each phase to ensure the system is being built to deliver the
needed functionality.

7
 HARDWARE AND SOFTWARE REQUIREMENTS

I.OPERATING SYSTEM : WINDOWS 10 AND ABOVE

II. PROCESSOR : PENTIUM(ANY) OR AMD

ATHALON(3800+- 4200+ DUAL CORE)

III. MOTHERBOARD : 1.845 OR 915,995 FOR PENTIUM 0R MSI

K9MM-V VIA K8M800+8237R PLUS

CHIPSET FOR AMD ATHALON

IV. RAM : 512MB+

V. Hard disk : SATA 40 GB OR ABOVE

VI. CD/DVD r/w multi drive combo: (If back up required)

VII. FLOPPY DRIVE 1.44 MB : (If Backup required)

VIII. MONITOR 14.1 or 15 -17 inch

IX. Key board and mouse

X. Printer : (if print is required – [Hard copy])

SOFTWARE REQUIREMENTS:

I. Windows OS
II. Python
III. mysql

8
 FLOW CHART

python-Mysql connecting

software login with username &password

ask user to enter his choice

your need will be fulfilled by python by

interfacing with mysql
SOURCE CODE

9
 Source Code:
import mysql.connector as sql
conn=sql.connect(host='localhost',user='root',passwd='manager'
,database='grocery_shop')
if conn.is_connected():
print('successfully connected')
c=conn.cursor()

print('grocery shop management system')

print('1.login')
print('2.exit')
choice=int(input('enter your choice:'))
if choice==1:
user_name=input('enter your user name=')
password=input('enter your password=')
while user_name=='nitin' and password=='nitin123':
print('connected successfully')

print('grocery shop')
print('1.customer details')
print('2.product details')
print('3.worker details')
print('4.see all customer details')
print('5.see all product details')
print('6.see all worker details')
print('7.see one customer details')
print('8.see one product details')
print('9.see one worker details')
print('10.stocks')
print('11.pie chart for avalibility of stock')

10
 choice=int(input('enter the choice'))
if choice==1:
cust_name=input('enter your name=')
phone_no=int(input('enter your phone number='))
cost=float(input('enter your cost='))
sql_insert="insert into customer_details
values("+str(phone_no)+",'"+(cust_name)+"',"+str(cost)+")"
c.execute(sql_insert)
conn.commit()
print('data is updated')

elif choice==2:
product_name=input('enter product name=')
product_cost=float(input('enter the cost='))
sql_insert="insert into product_details
values(""'"+(product_name)+"',"+str(product_cost)+")"
c.execute(sql_insert)
conn.commit()
print('data is updated')

elif choice==3:
worker_name=input('enter your name=')
worker_work=input('enter your work=')
worker_age=int(input('enter your age='))
worker_salary=float(input('enter your salary='))
phone_no =int(input('enter your phone number='))
sql_insert="insert into worker_details values("
"'"+(worker_name)+"',"
"'"+(worker_work)+"',"+str(worker_age)+","+str(worker_salary)+
","+str(phone_no)+ ")"
c.execute(sql_insert)
conn.commit()
print('data is updated')

11
 elif choice==4:
t=conn.cursor()
t.execute('select*from customer_details')
record=t.fetchall()
for i in record:
print(i)

elif choice==5:
t=conn.cursor()
t.execute('select*from product_details')
record=t.fetchall()
for i in record:
print(i)

elif choice==6:
t=conn.cursor()
t.execute('select*from worker_details')
record=t.fetchall()
for i in record:
print(i)

elif choice==7:
a=input('enter your name')
t='select*from customer_details where
cust_name=("{}")'.format(a)
c.execute(t)
v=c.fetchall()
for i in v:
print(v)

elif choice==8:

12
 a=input('enter your product_name')
t='select*from product_details where
product_name=("{}")'.format(a)
c.execute(t)
v=c.fetchall()
for i in v:
print(v)

elif choice==9:
a=input('enter your name')
t='select*from worker_details where
worker_name=("{}")'.format(a)
c.execute(t)
v=c.fetchall()
for i in v:
print(v)

elif choice==10:

print('******************************************')
f=open('test.txt','r')
data=f.read()
print(data)
f.close()

print('******************************************')

elif choice==11:
import matplotlib.pyplot as plt
items=('shoes','stationary','watch','house
use','food items')
avalibility=[156,200,103,206,196]

colors=['red','yellowgreen','blue','gold','lightcoral']

13
 plt.pie(avalibility,labels=items,colors=colors)
plt.title('avalibility of items in shop')
plt.show()

else:
print('wrong password, try again ')

if choice==2:
exit()

14
OUTPUT

15
16
17
18
Testing

Software Testing is an empirical investigation conducted to provide

stakeholders with information about the quality of the product or service under test[1]
, with respect to the context in which it is intended to operate. Software Testing also
provides an objective, independent view of the software to allow the business to
appreciate and understand the risks at implementation of the software. Test
techniques include, but are not limited to, the process of executing a program or
application with the intent of finding software bugs.
It can also be stated as the process of validating and verifying that a software
program/application/product meets the business and technical requirements that
guided its design and development, so that it works as expected and can be
implemented with the same characteristics. Software Testing, depending on the
testing method employed, can be implemented at any time in the development
process, however the most test effort is employed after the requirements have been
defined and coding process has been completed.

BIBLIOGRAPHY

1. INFORMATICS PRACTICES With Python - Class XII By : Sumita

Arora
2. Website: https://www.w3resource.com
***

19