Tanima Sadhukhan

XII (Science)

16
Informatics Practices
 ACKNOWLEDGEMENT

I would like to express my heartfelt gratitude

to all those who have contributed to the
completion of this project. Firstly, I extend my
deepest appreciation to Mrs. Poulami Seal
mam (PGT in Computer Science), as my project
supervisor, for her invaluable guidance,
support, and encouragement throughout the
entire duration of this project, Secondly I
would like to thanks to my parents and sister
for appreciating ma every moment and I
would also like to thank my Principal mam Mrs.
Susmita Paul who helped me to learn a lot
about this project.

(1)
 CERTIFICATE

This is to certify that “Tanima Sadhukhan” of Class 12

Science has successfully completed her project file on
‘Informatics practices (code 065) ’ under guidance and
supervision of Mrs Poulami Seal (PGT on Computer
Science) .I am satisfied with her initiative and efforts
for the completion of project file as a part of
curriculum of CBSE Class XII AISSCE (2024-25).

__________________________________ ____________________________________
Signature of External Examiner Signature of Internal Examiner

____________________________________________

Principal’s Signature

(2)
 DECLARATION

Tanima Sadhukhan , bearing roll no , a student of Class XII School

hereby declare that I own the full responsibility for the information,
results etc. provided in this project titled "Sweet Shop Management
System". It has been developed successfully by using the Data
Handling concepts like data management, data visualization etc.
provided in the programming language Python at Shri Santoshi Maa
School School in complete fulfillment of project curriculum of Central
Board of Secondary Education CBSE of Informatics Practices (065)
conducted by CBSE, New Delhi for the academic session 2024-25.

I also declare that this project work has neither been submitted to
any other board nor published at any time by me in the past.

Tanima Sadhukhan
Roll No:
Class 12
Shri Santoshi Maa Aademy

(3)
 INDEX
SLNO. TOPIC PAGE
NO.
1) Acknowledgement 1
2) Certificate 2
3) Declaration 3
4) Introduction 4
5) Project Statement 5
6) Objectives 6
7) Project Scope 7
8) Software Requirements and 8
Specifications
9) Overview of Python 9
10) Data Flow Diagram 10
11) Project Menus 11
12) CSV File 12
13) Source Code 13-17

14) Output 17-23

15) Conclusion 24
16) Bibliography 25
 INTRODUCTION

“The Sweet Shop Management System” project is prepared

to simplify and make efficient the managerial and
organizational process of business ventures/startups. in
recent years the demand for sweets has been on the rise.
There is a wide variety of sweets for different festivals and
occasions , and keeping a track of all customer orders,
making any changes, order delegations, etc. can be difficult
and stressful ,so to reduce the burden of workload for
managing various customers orders, we have developed this
python program on a sweet shop. This program includes
mainly four functions ;
Add: this function helps to add the details of the sweets which
includes their id, name, category, weight and price.
Display: this helps you to display the overall details for the
sweets.
Edit: this enables us to edit any typing errors. In this, we could
edit the sweet name, sweet id, price etc.
Delete: this function helps to delete any sweet name , price ,
etc.

(4)
 Problem Statement

For any business Data Management is one of the most

important department that must be well managed in order to
run daily business activity smoothly. But mostly business are
not able to manage Data as they do not have good
computerized system. As a result they lacks in
 Security of data, documents related to business
transactions.
 Unable to keep single copy of data at single location
which increases data complexity.
 Managing data consistency.
 Accessing and referencing or search data quickly
 Unable to analyze data as there is no mechanism to
visualize data .

(5)
 Objectives
The objective of project is to build an application program to:
• Provide function to manage data on sweet in shop more
efficiently.
• Provide searching facility based on various factors.
• Reduce time and cost to control and manage data .
• Reduce paperwork.
• Increased accuracy and reliability.
• Increased Data Consistency.
• Increased Data security.
This application program can be used easily by non-
programming personals.

(6)
 Project Scope
Managing all products, sufficient stocks, sale and purchase
records and analyzing sales is a tedious job for any business.
To do it more effectively and correctly a good data
management is required. This is provided by our application
which have following scope,
 ensures effective inventory control.
 manage daily sales records easily and precisely.
 can perform sales analysis of various products.
 user friendly interface.
 very easy to use.
 High level security of data.

(7)
 System Requirements and Specifications

Software Requirements
Operating System Window-10 and later versions (32bit,64bit)
Language - Python
Plateform - Python IDLE 3.7 (min)
Database – CSV
Plotting - Matplotlib
Hardware Requirements
Processor Pentium Dual Core(min) 32bitor64bit
Hard-Disk 160GB (min)
RAM 1G8 (min)
Input/output Requirements
Input Mouse (any)
Input ,Keyboard (any)
Output : Monitor
Output : Printer

(8)
 OVERVIEW OF PYTHON
Python is a general purpose, dynamic, high-level, and
interpreted programming language. It supports Object
Oriented programming approach to develop applications. It is
simple and easy to learn and provides lots of high-level data
structures. Guido Van Rossum is known as the founder of
Python programming
Features of Python:
 Python is a high level language. It is a free and open
source language.
 It is an interpreted language, as Python programs are
executed by an interpreter.
 Python programs are easy to understand as they have a
clearly defined syntax and relatively simple structure.
 Python is portable and platform independent, means it
can run on various operating systems and hardware
platforms.
• Python has a rich library of predefined functions.
 Python is also helpful in web development. Many popular
web services and applications are built using Python,
 Python uses indentation for blocks and nested blocks.

(9)
DATA FIOW DIAGRAM

CSV File

(10)
 PROJECT MENUS

Sweet Management System is divided into

following modules:
 Update menu : This module helps you to
modify available sweet data.
 Delete menu: This module helps you to delete
data of sweets.
 Bill menu: This menu is used to manage sell
information.
 Add menu : This module helps you to add
sweet data.
 Show the chart menu : This module is used to
generate purchase bills , available sweets and
visualize data by plotting charts.

(11)
 CSV File
1) CSV File of Sweet

2) CSV File of Customer

(12)
 PROJECT CODE

import matplotlib.pyplot as plt

import pandas as pd
import random
def addSweet(df):
code=int(input("Enter the sweet code"))
name=(input("Enter the name of the sweet"))
cost=int(input("Enter the cost per kg"))
qty=float(input("Enter the quantity in kgs"))
ig=input("Enter the main
ingradient")loc[code]=[name,cost,qty,ig]
print("\nAdded successully \n")
df.to_csv("sweets.csv")
print(df)
print("*"*50)
print("\t\t Krishna Sweet Shop")
print("*"*50)

(13)
df=pd.read_csv('sweets.csv',index_col='Code')
bf=pd.read_csv('customer.csv',index_col='billid')
while True:
print("press 1 - Add a New sweet")
print("press 2 - Show all")
print("press 3 - Search")
print("press 4 - Delete")
print("press 5 - Update")
print("press 6 - Create Bill")
print("press 7 - Show Chart Of Sweets")
print("press 8 - Show Chart Of Bills")
print("press 9 - To Quit")
n=int(input("Enter your choice :"))
if n == 1:
addSweet(df)
elif n == 2:
print("\n","*"*50)
print(df)
print("*"*50)
elif n == 3:
code=int(input("Enter the sweet code :"))
if code in df.index:
print(df.loc[code])
(14)
print("\n")
else:
print("No Sweet found with this code")
elif n == 4:
code =int(input("Enter the sweet code to be deleted :"))
if code in df.index:
df.drop(code,inplace=True)
df.to_csv("sweets.csv")
print(df)
print("\nDeleted\n")
print(df)
else:
print("No sweet found with this code ")
elif n == 5:
code =int(input("Enter the sweet code to be updated :"))
if code in df.index:
name = input("Enter the updated name of the sweet :")
cost = int(input("Enter updated cost per kg :"))
qty = float(input("Enter the quantity in kgs :"))
ig = input("Enter the main ingradient :")
df.loc[code]=[name,cost,qty,ig]
print("\nUpdated\n")
df.to_csv("sweets.csv")
(15)
print(df)
else:
print("No sweet found with this code")
elif n == 6:
print("Available Sweets")
print("\n","*" *50)
print(df)
print("*" * 50)
code= int(input("Enter the code of the sweet to be purchased"))
if code in df.index:
qty=int(input("Enter the quantity to be purchased :"))
amt= qty * df.loc[code,"Cost"]
print("Your Due Ammount is " ,amt)
name = input("Enter customer Name : ")
bdate =input("Enter Billing Date : ")
bf =pd.read_csv("customer.csv",index_col="billid")
bf.loc[random.randint(1000,9999)]=[name,bdate,amt,df.loc[code,"
Name"]]
bf.to_csv("customer.csv")
print("\n Customer Added successully \n")
bf.to_csv("customer.csv")
print(bf)

(16)
elif n == 7:
plt.bar(df["Name"],df["Cost"],color="violet")
plt.title("Rate list of sweets")
plt.show()
elif n == 8:
bf =pd.read_csv("customer.csv",index_col='billid')
plt.bar(bf["Name"],bf["order_amt"],color="violet")
plt.title("sold sweets")
plt.show()
elif n == 9:
print("Thanks for Visiting")
print("Data Uploded !!!")
break

________________

(17)
 OUTPUT
1) Add a New Sweet

2) Show all

(18)
3) Search

3) Delete

(19)
5) Update

(20)
6) To Create Bill

(21)
7) The Chart Of Sweet

8) The Chart Of Bills

(22)
9) To Quit

_________________
(23)
 CONCLUSION

Through this project on developing a sweet Shop

management system the technicalities in the
managerial process involved in operating a
business/shop. The project on sweet shop management
system has been developed using Python Idle . It is a
high level, open source and general programming
language. We learned that computerized method of
data management system saves time, cost and manual
effort of collecting and organizing data as various details
and information can be accessed ,edited, and analyzed
which leads to efficiency in work. We also gained
knowledge on various python codes and commands that
can be utilized in the creation of a managerial database

(24)
 BIBLIOGRAPHY

1) https://www.wikipedia.org/

2)https://www.youtube.com/

3)Sumita Arora Informatics Practices Class 12.

4)NCERT Class 12 Informatics Practices Book.

(25)

_______________________________________________