A
MINI PROJECT REPORT
ON
“Grocery Shop Management
System ”
Submitted by
YOGESH KALE
SHUBHAM KADAM
TEJAS SARODE
Guided by
BAAAAAAA
TO
DEPARTMENT OF COMPUTER ENGINEERING
GRAMIN TECHNICAL & MANAGEMENT
CAMPUS,VISHNUPURI, NANDED-431606
MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION
(MSBTE), MUMBAI
ACADEMIC YEAR 2025-26
I
A
PROJECT REPORT
ON
“Grocery Shop Management
System “
Submitted by
Harsh
GUIDE BY
Dahiphale P.B
TO
In Partial Fulfillment for the Award of the Diploma In
DEPARTMENT OF COMPUTER ENGINEERING
GRAMIN TECHNICAL & MANAGEMENT CAMPUS,
VISHNUPURI, NANDED - 431606
ACADEMIC YEAR 2025-26
II
CERTIFICATE
This is to certified that the project entitled
“Grocery Shop Management
System “
Being submitted by Mr. to State Board Of Technical Education Mumbai as a partial
fulfillment of award of Diploma in COMPUTER ENGINEERING is record of Bonafide
work carried out by his / her under supervision and guidance of Ms. Sarwat Banikar The
assigned project is performed satisfactorily in the academic year 2023-24.
Mrs. Dahiphale P.B Mr. Wahi G.S
Guide Head of Department
Dr. Pawar V. S.
Principal
III
ACKNOWLEDGEMENT
I take this opportunity to express my deep sense of gratitude to words Mrs.
Dahiphale P.B Course in charge of Database Management System who has
been a constantsource of inspiration to us and without her valuable guidance this
work couldnot possible.
I am thankful to all faculty members of my department also for their
guidance,support and encouragement for the accomplishment of our micro-project. I
would like to thankful to Mr. Wahi G.S HOD of COMPUTER ENGINEERING
(Polytechnic) for his valuable comments and suggestion for me to improve my
creativity regarding project work.
I also express my sincere thanks to my friends for their assistance and comments for
the betterment of this micro project.
Sincerely:
IV
Department of Computer Engineering
VISION MISSION
The Department of Department of Computer
Computer Engineering will Engineering will be role
be one of the National model for Computer
leaders, catering dynamic IT Engineers by:
knowledge to serve society 1. Exposing the learners
and the globe at large. to latest tools and
technologies in the
िवhाथ Ŏ यांना मािहती व field of Computer,
तंTyान ƗेTाचे काळानुV प hardware and
yान देउन संगणक अिभयांिTकी software.
िवभाग राʼŌ ीय नेतृȕाचा एक १. संगणक हाड´ वेअर व
भाग असेल.
सॉ4वेअर ƗेTातील अ hावत
तंTyान व साधने
िव ȯाथ Ŏ यांना िशकवणे.
2. Providing fruitful
learning environment,
enhancing problem
solving skills amongst
the learners, to make
them successful.
२. िवhाȚाōचा यश4ीसाठी
फलदायी शैƗिणक वातावरण
तयार कVन wांljामधील Ůʲ
सोडवǻाचे कौश ʞ
ि करणे..
3. Support society by
participating in and
extending technological
services.
३. समाजाला लागणा“या
संगणकीय तांिT क सेवा
पुरवून समाजाचा आधार बनणे.
V
ANNUEXURE II
Evaluation Sheet for the Micro Project
Academic Year: 2023 - 2024 Name of faculty: Mrs. Dahiphale P.B
Course: CO Course code:CO3I Semester: 3rd Semester
Title of Project: Grocery Shop Management System
Cos addressed by 6 the Micro Project:
A. “Design Normalized database on given data.”
B. “Create and Manage database using SQL Command.”
C.
D.
Major Learning Outcomes achieved by doing the Project:
a. Practical Outcomes: 1. Perform following GUI based database software
using GUI only. 2. Create and execute DDL commands using SQL. 3.
Create and execute DML commands using SQL.
b. Unit Outcomes in cognitive domain: “1d. Draw the E-R diagram of the given
database and identify relationship Between the entities.” “ 2c. Design SQL
Queries to create relational database and apply in the given data
constraints.”
c. Outcomes in Affective Domain:
Comments / Suggestions about team work/ leadership/ internship/ inter-personal
communication (if any)
Roll Student Name Marks out of 6 Marks out of 4 Total out of
No. for for performance 10
performance in in
group activity oral/presentation
02 Vaibhav Gangadhar
Jawadwar
(Name & Signature of faculty)
VI
Index
Sr. no. Points Page no.
1 Abstract 02
2 Introduction 03
3 What is SQL in DBMS 04
4 What is Grocery Shop Management System 06
5 Functionalities of Grocery Shop Management 08
System
6 Modules of Grocery Shop Management System 09
7 Keys Used in the Database
12
8 Basic Commands used in the Database. 14
Entity Relationship Diagram (ER) for Grocery
9 18
shop management system
Implementation of Grocery Shop Management
10 19
System
11 Advantages & Disadvantages 24
12 Conclusion 25
13 Future scope 26
14 References 27
1
GT&MC, Vishnupuri, Nanded.
Abstract
The purpose of Grocery Shop Management System is to automate the existing manual system by
the help of computerized equipment's and full-fledged computer software fulfilling their
requirements, so that their valuable data/information can be stored for a longer period with easy
accessing and manipulation of the same. The required software and hardware are easily available
and easy to work with. Grocery Shop Management System, as described above, can lead to error
free secure, reliable and fast management system. It can assist the user in concentrating on their
other activities rather to concentrate on the record keeping.
2
GT&MC, Vishnupuri, Nanded.
Introduction
The "Grocery Shop Management System" has been developed to override the problems
prevailing in the practicing manual system. This software is supported to eliminate and, in some
cases, reduce the hardships faced by this existing system. Every organization, whether big or
small, has challenges to overcome and managing the information of Product, Customer, Product
Type, Stock, Supplier. Every Grocery Shop Management System has different Customer needs,
therefore we design exclusive employee management systems that are adapted to your
managerial requirements. This is designed to assist in strategic planning, and will help you ensure
that your organization is equipped with the right level of information and details for your future
goals. The Grocery Shop Management System is a comprehensive and efficient software solution
designed to streamline and enhance the operations of grocery stores and supermarkets. In today's
fast-paced retail industry, managing inventory, sales, and customer information has become a
complex task. To meet the demands of modern retail, this system leverages the power of a
relational database management system, SQL (Structured Query Language), to provide a robust
and organized solution for grocery store owners and managers.
3
GT&MC, Vishnupuri, Nanded.
Advantages & Disadvantages
Advantages: -
Efficient Inventory Management: It allows for precise tracking of inventory levels,
reducing overstocking and understocking issues, which can help minimize waste and
maximize profits.
Automated Sales Processing: The system streamlines the sales process, reducing the
chance of manual errors in calculations, billing, and inventory management.
Data Accuracy: SQL databases ensure data accuracy and consistency, reducing the risk
of data errors that can occur with manual record-keeping.
Data Analysis: The system provides tools for generating reports and data analysis,
enabling store owners to make informed decisions about pricing, promotions, and
inventory management.
Customer Relationship Management: Maintaining customer data helps build better
relationships and allows for targeted marketing and loyalty programs.
Disadvantages: -
Cost: Implementing and maintaining a Grocery Shop Management System can be costly,
including initial software and hardware expenses, as well as ongoing maintenance and
training costs.
Complexity: Complex systems may require significant time and effort to set up and
maintain, especially for small businesses with limited resources.
Employee Training: Staff may need training to use the system effectively, and there
might be a learning curve associated with new technologies.
Data Loss Risks: While SQL databases are generally reliable, there is still a risk of data
loss due to hardware failures, software issues, or human errors.
4
GT&MC, Vishnupuri, Nanded.
Conclusion
The company/shops wished to replace their manual method with a new database system to bring
their order system online. Companies may automate their ordering procedures with the
help of online systems and databases, as everyone knows, thus developing a database system
for a firm will make ordering suitable, useful, and trouble-free. The redundancies and
irregularities in the tables are remove dusing the normalization procedure. We'll begin database
construction once all of the tables have been standardized and are redundancy-free. SQL is used
to build tables and attributes in this database, as well as to apply constraints to characteristics
such as designating the Primary Key and Foreign Key.
5
GT&MC, Vishnupuri, Nanded.
References
1. [Link]
2. [Link]
science/supermarket-management-system-database-design/21396589
3. [Link]
for-grocery-management-system/#google_vignette
4. [Link]
6
GT&MC, Vishnupuri, Nanded.
Thank You
7
GT&MC, Vishnupuri, Nanded.