SDL MINI PROJECT

REPORT
ON

Store Management System

and Data Analysis
Submitted By:
Shraddha Gohel
Pooja Gaidhani
Ankita Jethva

Branch : T. E. Computer (2018-2019)

Guided By: Prof. K. P. Birla

Department of Computer Engineering

K. K. Wagh Institute of Engineering Education & Research
Hirabai Haridas Vidyanagari, Amrutdham, Panchavati,
Nahik – 422 003.

Affiliated to Savitribai Phule Pune University

 K. K. WAGH INSTITUTE OF ENGINEERING
EDUCATION & RESEARCH
NASIK.

CERTIFICATE
This is to certify that

Shraddha Gohel
Pooja Gaidhani
Ankita Jethva

Has Successfully completed

SDL Mini Project on

Store Management System and Data Analysis

Towards the Partial Fulfilment Of Bachelor’s

Degree In Computer Engineering

Of Savitribai Phule Pune University

During Academic Year 2018 – 2019

Prof. K. P. Birla Prof. Dr. S. S.Sane Prof. Dr. K. N. Nandurkar

[Mini Project Guide] [H.O.D] [Principal]
 I. TITLE
Store Management System and Data
Analysis

1
 II. ABSTRACT
The most difficult work for a shopkeeper is to manage his
data. Main difficulty comes with the shop’s proprietor to
manage his data of sales, purchases and stock. This in turn
leads to not having proper records of data and do analysis of
your profit or loss. There are lot of solutions to this problem
but still there is no efficiency to store and display records
according to user’s wish. This system is made for the
proprietor of the shop to help manage his daily data set and
do analysis of the data stored by him. Pandas is a way with
which data analysis can be done and visualize the data with
the help of graphs. Graphs make it easier for a person to
understand his or her data than a data set. Hence the
application is made to fulfill the requirements mentioned
above.

KEYWORDS
Python, GUI, Pandas, PyQt5, Data Analysis, Data
Management, MySQL

2
 III. INTRODUCTION

A shopkeeper/proprietor wants to store data of his daily

sales, purchases and stock. He sells all the products that are
required for construction like cement, steel, wall tiles, etc.
He also wants to understand his daily sales and purchases
with the help of graphs. A desktop application is made to
manage his data and do data analysis of his data to
understand his sales and purchases.

3
IV.LETTER OF
SPONSORSHIP

4
5
 V.PROBLEM
STATEMENT

Hari Om Ceramic’s wholesaler and retailer wants sells

all type of cement steel, all kinds of tiles and sanitary
products. He wants to keep the record of all the records
sold, bought and wants to do data analysis. A desktop
application is to be made for storing and analysing his
sales and stock.

6
 VI. OBJECTIVES
 To develop a Desktop application for handling
purchase, sales and stock of the Shop
 To provide the facility of updating and managing the
previous data
 To visualize the data in the software for future
management of sales and purchases

7
 VII. OUTCOMES
 The proprietor will be able to keep track of all records
previously stored and newly added
 The proprietor will be able to visualize the data to know
his purchases and sale

8
 VIII. SOFTWARE AND
HARDWARE
REQUIREMENTS

Hardware: Any Desktop or Laptop having processor

of 2 GB RAM and minimum 50 MB hard disk space.

Software: Python 3.7, PyCharm IDE, PyQt5,

MySQL, pyuic, Qt Designer, Windows 7, 8, 10 and
Linux.

9
 IX. PLAN WITH
TIMELINE

 18/08/2019 to 25/08/2019: Discussion of the project

and Agreement on the project with client
 26/08/2019 to 05/09/2019: Requirement analysis and
modelling of the software
 06/09/2019 to 15/09/2019: Connect the GUI with the
database and testing of the software
 17/09/2019: Adding modification to the project and
making it more user friendly
 25/09/2019: Delivering the project to the Proprietor
 01/10/2019: Feedback from the sponsor
 05/10/2019: Completion Certificate from the
Proprietor

10
 X.FUNCTIONAL
REQUIREMENTS

1. An executable file to be used to install the software

on the system
2. The user needs to login to use the software.
3. If the user does not have an account, he has to create
an account with a unique username.
4. After logging in the user will see a window with
which he will be able to enter his purchase and
sales.
5. Stock will be updated according to the invoice entry
entered.
6. The software is integrated with the database to
record all the data

11
 XI. NON FUNCTIONAL
REQUIREMENTS

1. The software shall be secured properly so no other

than the shop’s workers and proprietor can access it.
2. The Software is easy to use and easily accessible
3. The software does not consume much memory of the
system
4. No fake data should be entered.
5. Any null values cannot be inserted in the database.
6. The software is interoperable.

12
XII. BLOCK DIAGRAM

13
XIII. USE CASE DIAGRAM

14
XIV. DATABASE/DATASET

15
 XV. TEST CASES

Test Expected
Actual Result Status
Case Result
If user exists, then
User The user is able to
validation Pass
Validation login if the user exist
successful
The login is
If password correct,
successful if Pass
Login successful
Password password is correct
Validation If password
The user will not
incorrect, then login Fail
able to login
unsuccessful
Test Case 1: Login Validation
16
 Test
Expected Result Actual Result Status
Case
If user exists, then The user is not able
Existing cannot create account. to create a new
Pass
Username If not then create new account if it is
user existing
The account is
Password If password matches
created only when Pass
Matching then create account
password matches

Test Case 2: Creating new Account

17
 XV. CONCLUSION

Thus, we successfully created software for Hari Om

Ceramics using Python. This software validates data
set or previous records that can be used to analyze the
sales and purchases. This software also shows weekly,
monthly and yearly sales and purchases analysis and
can compare the sales and purchases with the help of
Graphs.

18
 XVI. REFERENCES

1. Python Documentation:
https://docs.python.org

2. PyQt5 Tutorials:
https://build-system.fman.io › pyqt5-tutorial

3. MySQL Tutorials:
https://www.tutorialspoint.com › mysql

4. Tutorials from GitHub:

https://github.com/TPayneExperience/LLP_026_
MySQL_PyQT_Example

USEFUL LINKS
1. Stack Overflow:
https://stackoverflow.com/questions/

2. Plotting graphs:
https://www.kaggle.com/residentmario/univariat
e-plotting-with-pandas
19
 LETTER ON
XVIII.

FEEDBACK AND
COMPLETION
CERTIFICATE

20
21
22
 XIX. FUTURE SCOPE

 The software can be further developed to manage

online transactions, e-mailing, billing, etc.
 Accuracy, memory management and security can be
further provided to make the application more accurate
and better

23
SNAPSHOTS

24
25
26
 Report Documentation & Accounting Page

Report Code: CS-TE-SDL Mini Project Report Number: TE A 21, 23, 26

2019-2020

Address (Details):
Computer Department, K. K. Wagh Institute of Engineering Education & Research,
Hirabai Haridas Vidyanagari, Amrutdham, Nashik
Pin – 422 003

Report Title: Store Management System and Data Analysis

Author Details (Year, Branch, Roll):
Author [with Address, phone, E-mail]:
Address: B-3, Rupak Society, Vise Mala, College Road, Year: 2019– 2020
Nashik - 422005
Branch: Computer Engineering
E-mail : [email protected]
Roll: 23, 21, 26
Time Covered
(From – To) Date Of Report Page Count
Type Of Report: FINAL 29-09-2019 (DD-MM-YYYY)
23
TO 16-10–2019
06-10-2019

Key Words:

Report Checked By: Report Checked Date: Guides Complete

Name: Total Copies

Prof. K. P. Birla 1

Abstract:

A shopkeeper’s most difficult task is to maintain the records of his purchases and sales.
It is also difficult for them to do data analysis with the records they have. This software
is made for them to manage their records and do data analysis with the help of this
software.

27