DAV PUBLIC SCHOOL , Alkusa , Dhanbad

ACADEMIC SESSION: 2021-22

PROJECT REPORT ON

FASHION STORE
For
AISSCE 2024-25 Examination
[As a part of the COMPUTER SCIENCE Course
(083)]

SUBMITTED BY:
BOARD ROLL NO : 22664236

NAME : MUSKAN KUMARI

CLASS : XII - A

SUBJECT : COMPUTER SCIENCE

SUB CODE : 083

DAV ALkusa December 30, 1899

Certificate
Name : MUSKAN KUMARI

Roll No : 22664236

Institution : DAV Public School , Alkusa , Dhanbad-828116

This is to certify that the student MUSKAN KUMARI of class

XII ‘A’ has completed the entitled : Fashion Store in the
subject : Computer Science with Python (code : 083). The
Project has successfully completed under my guidance and
supervision in particular fulfillment of the curriculum of central
board of secondary education (CBSE) in the academic year
2021-22.

Date: ………………………….
Vikash Kumar

Teacher In-charge

……………………….. ……………………….

Examiner ’s Signature Principal Sign.

MUSKAN KUMARI 2
DAV ALkusa December 30, 1899

ACKNOWLEDGEMENT

I undertook this Project, as the part of my XII- Computer

Science Course. I tried to apply my best of my knowledge and
experience, gained during the study and class work experience.
However, studying Computer Science is generally a quite
complex , It requires a systematic study, insight vision and
professional approach during the design and development. This
opportunity to express my gratitude to the people who have
been instrumental in the successful completion of this project.
I would like to extend my thanks and gratitude to my
School Principal Mr. S. Modak. Who has been continuously
motivating and extending their helping hand to us.

I would like to express my sincere thanks to my Computer

Science teacher Mr. Vikash Kumar, for constant encouragement
and the guidance provided during this project. He critically
reviewed my project and helped in solving each and every
problem, occurred during implementation and development of
the project

I would also like to thank my parents and my friends for the

valuable suggestions and encouraging me during the course of
this project. Finally I would like to thank CBSE for giving me this
opportunity to undertake this project.

MUSKAN KUMARI
Class : 12th ‘A’

MUSKAN KUMARI 3
DAV ALkusa December 30, 1899

TABLE OF CONTENTS

 Introduction
 OBJECTIVES
 SYSTEM DEVELOPMENT LIFE CYCLE
 Software testing
 HARDWARE & SOFTWARE REQUIREMENTS
 Theoretical Background
 Modules and their purpose
 System Design & Development

 Database Design:
 SOURCE CODE
 Requirements
 Bibliography

MUSKAN KUMARI 4
DAV ALkusa December 30, 1899

Fashion Store
INTRODUCTION
The Fashion store management software packages are
here to drive more revenues for store owners. These
software programs can help you manage simple
functions in the store like loyalty program, billing,
inventory management, and many more such operations
to make your store service as flawless and superior for
your customers as possible. The Fashion store
database us a locally designed online database for a
fashion store where the owner can view product list with
its detail and about the store. This database makes it
very easy for owner to search for any product the store.
How Does a Fashion Designer Works with Clothing
Design Software?
Technology has expanded its horizon to every industry, and fashion
designing is no different. Fashion designing tools enable creative
individuals to set up their businesses and easily move to create
garments, shoes, and other accessories for consumers.
Fashion design software covers all facets of design like 2D and 3D
sketching, illustrations and patternmaking to produce a design
blueprint. It further helps designers convey how a functional yet
aesthetically pleasing design would look in real life.

Display Menu: Select the category to display the data

1 : To Add Product ")

2 : To Edit Product ")
3 : To Delete Product ")
4 : To View Product ")
5 : To Purchase Product")
6 : To View Purchases")
7 : To View Stock Detials")
8 : To Sale the item")
9 : To View Sales Detials")
10 : To EXIT

MUSKAN KUMARI 5
DAV ALkusa December 30, 1899

Abstract:.
The project contains following modules:-
1. Product Management: This module is used to add,
update and delete the products. Product management
modules enable us to maintain a sophisticated list of
products. Managing products is akin to managing a small
business within a bigger business.
1. All Details
2. Product Name
3. Product Brand
4. Product For
5. Product Season
6. Product ID

2. Purchase Management: This module is used to

manage the purchase system. It helps you to maintain
masters for various suppliers and their contacts, track
purchase, get complete purchase rate histories etc. it
systematically records all the details pertaining to various
suppliers, purchase orders purchase returns and much more.
3. Sales Management: This module is used to manage
the sale of the products. It allows you with effective control
to your sales. It easily creates a new sales order out of
different sales, generating new sales order and can filter the
order as per the requirement.
4. Database setup: This module is used to setup the
database in the system for the first time.

MUSKAN KUMARI 6
DAV ALkusa December 30, 1899

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 computer

science, as exemplified in the areas of systems, theory and

software development.

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

Computer Science project, requiring writing and presentation skills

which exemplify scholarly style in computer science.

MUSKAN KUMARI 7
DAV ALkusa December 30, 1899

SYSTEM DEVELOPMENT LIFE CYCLE (SDLC)

The systems development life cycle is a project management technique that

divides complex projects into smaller, more easily managed. 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.

TESTING METHODS
Software testing methods are traditionally divided into black box testing
and white box testing.
BLACK BOX TESTING
Black box testing treats the software as a "black box," without any
knowledge of internal implementation.
WHITE BOX TESTING
White box testing, by contrast to black box testing, is when the tester
has access to the internal data structures and algorithms (and the code that
implement these)

MUSKAN KUMARI 8
DAV ALkusa December 30, 1899

HARDWARE AND SOFTWARE REQUIREMENTS

HARDWARE SPECIFICATION:-

1) PROCESSOR : Dual Core and above

2) RAM : 512MB+

3) Hard disk : 40 GB OR ABOVE

4) Printer : To print the required documents

5) Compact Drive

6) MONITOR 14.1 or 15 -17 inch

7) Key board and mouse

SOFTWARE SPECIFICATION:-

1) Operating System : Windows 10

2) Platform : Python IDLE 3.7 ( Front End )
3) Database : MySQL ( Back End )
4) Languages : Python
5) Microsoft Office : For Documentation & presentation
. of output.

MUSKAN KUMARI 9
DAV ALkusa December 30, 1899

Theoretical Background
Python is a general-purpose interpreted, interactive, object-oriented, and high-level
programming language. It was created by Guido van Rossum during 1985- 1990.
Like Perl, Python source code is also available under the GNU General Public
License (GPL). This tutorial gives enough understanding on Python
programming language.

Why to Learn Python?

Python is a high-level, interpreted, interactive and object-oriented scripting
language. Python is designed to be highly readable. It uses English keywords
frequently where as other languages use punctuation, and it has fewer syntactical
constructions than other languages.

Python is a MUST for students and working professionals to become a great

Software Engineer specially when they are working in Web Development Domain. I
will list down some of the key advantages of learning Python:
 Python is Interpreted
 Python is Interactive
 Python is Object-Oriented.
 Python is a Beginner's Language

Characteristics of Python
Following are important characteristics of Python Programming −
 It supports functional and structured programming methods as well as OOP.
 It can be used as a scripting language or can be compiled to byte-code for
building large applications.
 It provides very high-level dynamic data types and supports dynamic type
checking.
 It supports automatic garbage collection.
 It can be easily integrated with C, C++, COM, ActiveX, CORBA, and Java.

1
MUSKAN KUMARI
0
DAV ALkusa December 30, 1899

What is Database?
Introduction and Concepts:
A database is a collection of information related to a particular subject or purpose, such as tracking
customer orders or maintaining a product collection. Using any RDBMS application software like MS
SQL Server, MySQL, Oracle, Sybase etc, you can manage all your information from a single database
file. Within the file, divide your data into separate storage containers called tables. You may and
retrieve the data using queries.

A table is a collection of data about a specific topic, such as products or suppliers. Using a separate
table for each topic means you can store that data only once, which makes your database more
efficient and reduces data-entry errors. Table organises data into columns (called fields) and rows
(called records).

A Primary key is one or more fields whose value or values uniquely identify each record in a table. In
a relationship, a primary key is used to refer to specific record in one table from another table. A
primary key is called foreign key when it is referred to from another table.

To find and retrieve just the data that meets conditions you specify, including data from multiple
tables, create a query. A query can also update or delete multiple records at the same time, and
perform built-in or custom calculations on your data.

Role of RDBMS Application Program:

 Creating of a table, addition, deletion, modification of records.
 Retrieving data collectively or selectively.
 The data stored can be sorted or indexed at the user's discretion and direction.
 Various reports can be produced from the system. These may be either standardized report
or that may be specifically generated according to specific user definition.
 Mathematical functions can be performed and the data stored in the database can be
manipulated with these functions to perform the desired calculations.
 To maintain data integrity and database use.

The DBMS interprets and processes users' requests to retrieve information from a database. In most
cases, a query request will have to penetrate several layers of software in the DBMS and operating
system before the physical database can be accessed. The DBMS responds to a query by invoking the
appropriate subprograms, each of which performs its special function to interpret the query, or to
locate the desired data in the database and present it in the desired order.

1
MUSKAN KUMARI
1
DAV ALkusa December 30, 1899

What is My SQL ?

The management of data in a database system is done by means of a general-purpose software

package called a Database Management System (DBMS). Some commercially available RDBMS are
MS SQL Server, MS ACCESS, INGRES, ORACLE, and Sybase.

MySQL, the most popular Open Source SQL database management system, is developed,
distributed, and supported by Oracle Corporation. MySQL is named after co-founder Monty
Widenius's daughter, My. The name of the MySQL Dolphin (our logo) is “Sakila,”.

 MySQL is a database management system.

 MySQL is based on SQL.
 MySQL software is Open Source.
 The MySQL Database Server is very fast, reliable, and easy to use.
 MySQL Server works in client/server or embedded systems.

The Main Features of MySQL

 Written in C and C++.

 Works on many different platforms.
 Uses multi-layered server design with independent modules.
 Provides transactional and nontransactional storage engines.
 Designed to make it relatively easy to add other storage engines. This is useful if you want to
provide an SQL interface for an in-house database.
 Uses a very fast thread-based memory allocation system.
 Executes very fast joins using an optimized nested-loop join.
 Implements SQL functions using a highly optimized class library that should be as fast as
possible. Usually there is no memory allocation at all after query initialization.
 Provides the server as a separate program for use in a client/server networked environment,
and as a library that can be embedded (linked) into standalone applications. Such
applications can be used in isolation or in environments where no network is available.
 Password security by encryption of all password traffic when you connect to a server.
 Support for large databases. We use MySQL Server with databases that contain 50 million
records. We also know of users who use MySQL Server with 200,000 tables and about
5,000,000,000 rows.
 MySQL client programs can be written in many languages. A client library written in
C is available for clients written in C or C++, or for any language that provides C
bindings.
 APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl are available,
enabling MySQL clients to be written in many languages.
 The Connector/ODBC (MyODBC) interface provides MySQL support for client
programs that use ODBC (Open Database Connectivity) connections.

1
MUSKAN KUMARI
2
DAV ALkusa December 30, 1899

System Design & Development

Database Design:
An important aspect of system design is the design of data storage structure. To begin with a logical
model of data structure is developed first. A database is a container object which contains tables,
queries, reports and data validation policies enforcement rules or contraints etc. . A logical data
often represented as a records are kept in different tables after reducing anomalies and
redundancies. The goodness of data base design lies in the table structure and its relationship.

Database Installation
import mysql.connector
password=input('To Continue Enter Your Password:')
mydb=mysql.connector.connect(host="localhost",user="root",passw
d=password)
mycursor=mydb.cursor()
try:
mycursor.execute('create database fashion')
except:
pass
mycursor.execute('use fashion')
mycursor.execute('create table product(product_id char(4) Primary
Key, PName varchar(20) not null, brand varchar(10), Product_for
varchar(6),season varchar(6),rate int(5) not null)')
mycursor.execute('create table purchase(purchase_id char(6) not
null,item_id char(4) references product(product_id),no_of_items
int(3) not null,amount int(7),Purchase_date date)')
mycursor.execute('create table stock(item_id char(4) references
product(product_id),Instock int(3) not null,status varchar(10) not
null)')
mycursor.execute('create table sales(sale_id char(6) Primary
key,item_id char(4) references product(product_id),no_of_item_sold
int(3) not null,sale_rate int(5) not null,amount int(7) not
null,date_of_sale date)')

1
MUSKAN KUMARI
3
DAV ALkusa December 30, 1899

mydb.close()

The software project is distributed with a backup copy of a Database named fashion with
required tables. Some dummy records are present in the tables for testing purposes, which
can be deleted before inserting real data. The project is automatically creating tables in the
MySQL RDBMS of your computer system.

Note: The PC must have MySQL server with user (root) and password (kvuc) . If root
password is any other password, it can be changed by running MySQL Server Instance
Configure Wizard.

Start Program  MySQL MySQL Server MySQL Server Instance Config Wizard

Provide current password of root and new password as “kvuc” , this will change the root
password.

We have to create the database ‘ stock’ , and the tables created are:-

 product
 purchase
 sales
 stock

Note: For Python-MySQL connectivity, following data have been used:-

Host- localhost, user- root, database- fashion

1
MUSKAN KUMARI
4
DAV ALkusa December 30, 1899

Table Design:
The database of Library System contains 4 tables. The tables are normalized to minimize the
redundancies of data and enforcing the validation rules of the organization. Most of the tables are
designed to store master records. The tables and their structure are given below.

1
MUSKAN KUMARI
5
DAV ALkusa December 30, 1899

1
MUSKAN KUMARI
6
DAV ALkusa December 30, 1899

SOURCE CODE

import os
import platform
import mysql.connector
import datetime

password=input('To Continue Enter Your Password:')

try:

mydb=mysql.connector.connect(host="localhost",user="r
oot",

passwd=password,database="fashion")
mycursor=mydb.cursor()
except:
mydb=0
print('Incorrect Password')
exit()
print("*"*80)
print("* * * * * * * * * * Welcome to the Project of
Fashion Store * * * * * * * * * * ")
print("* * * * * * * * * * * Developed by: MUSKAN
KUMARI AND JASIKA SINGH * * * * * * * * * * * * * ")
print("*"*80)
print("")

def AddProduct():
L=[]
stk=[]
pid=input("Enter the Product ID : ")
L.append(pid)
IName=input("Enter the Product Name : ")
L.append(IName)
brnd=input("Enter the Product Brand Name : ")
L.append(brnd)
fr=input("Enter Male/Female/Kids : ")
L.append(fr)
sn=input("Enter Winter/Summer : ")
L.append(sn)
rate=int(input("Enter the Rates for Product :"))
L.append(rate)
product=(L)

1
MUSKAN KUMARI
7
DAV ALkusa December 30, 1899

sql="Insert into product

(product_id,PName,brand,Product_for,Season,rate)value
s(%s,%s,%s,%s,%s,%s)"
mycursor.execute(sql,product)
mydb.commit()
stk.append(pid)
stk.append(0)
stk.append("No")
st=(stk)
sql="insert into stock(item_id, Instock, status)
values(%s,%s,%s)"
mycursor.execute(sql,st)
mydb.commit()
print("One Product inserted ")

def EditProduct():
pid=input("Enter product ID to be edited : ")
sql="select * from product where product_id=%s"
ed=(pid,)
mycursor.execute(sql,ed)
res=mycursor.fetchall()
for x in res:
print(x)
print("")
fld=input("Enter the field which you want to
edit : ")
val=input("Enter the value you want to set :
")
sql="Update product set " + fld +"='" + val +
"' where product_id='" + pid + "'"
sq=sql
mycursor.execute(sql)
print("Editing Don : ")
print("After correction the record is : ")
sql="select * from product where product_id=
%s"
ed=(pid,)
mycursor.execute(sql,ed)
res=mycursor.fetchall()
for x in res:
print(x)
mydb.commit()

1
MUSKAN KUMARI
8
DAV ALkusa December 30, 1899

def DelProduct():
pid=input("Enter the Product)id to be deleted :
")
sql="delete from sales where item_id=%s"
id=(pid,)
mycursor.execute(sql,id)
mydb.commit()
sql="delete from purchase where item_id=%s"
mycursor.execute(sql,id)
mydb.commit()
sql="delete from stock where item_id=%s"
mycursor.execute(sql,id)
mydb.commit()
sql="delete from product where product_id=%s"
mycursor.execute(sql,id)
mydb.commit()
print("One Item Deleted")

def ViewProduct():
print(80*'=')
print("Display Menu: Select the category to
display the data")
print("1. All Details")
print("2. Product Name:")
print("3. Product Brand:")
print("4. Product For:")
print("5. Product Season:")
print("6. Product ID:")
x=0
ch=int(input("Enter your choice to display : "))
if ch==1:
try:
csv=[]
sql="select * from product"
mycursor.execute(sql)
res=mycursor.fetchall()
for x in res:
print(x)
x=1
except:
print('No record found')
elif ch==2:
var='PName'
val=input("Enter the name of Product : ")

1
MUSKAN KUMARI
9
DAV ALkusa December 30, 1899

elif ch==3:
var='brand'
val=input("Enter the name of Brand : ")
elif ch==4:
var='Product_for'
val=input("Enter Male/Femal/Kids : ")
elif ch==5:
var='season'
val=input("Enter the Season : ")
elif ch==6:
var='product_id'
val=input("Enter the Product_id : ")
if x==0:
sql="select * from product where " + var + "
= %s"
sq=sql
tp=(val,)
mycursor.execute(sq,tp)
res=mycursor.fetchall()
for x in res:
print(x)

def PurchaseProduct():
mn=""
dy=""
now=datetime.datetime.now()
purchaseID=str(now.year)+str(now.month)
+str(now.day)
L=[]
Lst=[]
L.append(purchaseID)
itemId=input("Enter Product ID : ")
L.append(itemId)
itemNo=int(input("Enter the number of Items : "))
L.append(itemNo)
sql="select rate from product where product_id=
%s"
pid=(itemId,)
mycursor.execute(sql,pid)
res=mycursor.fetchone()
for x in res:
print("rate is : ", x)
amount=x*itemNo

2
MUSKAN KUMARI
0
DAV ALkusa December 30, 1899

print("Amount is :", amount)

L.append(amount)
mnth=now.month
if mnth<=9:
mn="0"+str(mnth)
else:
mn=str(mnth)
day=now.day
if day<=9:
dy="0"+str(day)
else:
dy=str(day)
dt=str(now.year)+"-"+mn+"-"+dy
L.append(dt)
sql="insert into
purchase(purchase_id,item_id,no_of_items,amount,Purch
ase_date)values(%s,%s,%s,%s,%s)"
mycursor.execute(sql,L)
mydb.commit()
sql="Select Instock from stock where item_id=%s"
mycursor.execute(sql,pid)
res=mycursor.fetchall()
status="No"
for x in res:
print(x)
instock=x[0]+itemNo
if instock>0:
status="Yes"
Lst.append(instock)
Lst.append(status)
Lst.append(itemId)
tp=(Lst)
sql="update stock set instock=%s,status=%s
where item_id=%s"
mycursor.execute(sql,tp)
mydb.commit()
print("1 Item purchased and saved in Database")

def ViewPurchase():
item=input("Enter Product Name : ")
sql="select product.product_id,
product.PName,product.brand,purchase.no_of_items,purc
hase.purchase_date,purchase.amount from product INNER

2
MUSKAN KUMARI
1
DAV ALkusa December 30, 1899

JOIN purchase ON product.product_id=purchase.item_id

and product.PName=%s"
itm=(item,)
mycursor.execute(sql,itm)
res=mycursor.fetchall()
for x in res:
print(x)
def ViewStock():
item=input("Enter Product Name : ")
sql="select
product.product_id,product.PName,stock.Instock,
stock.status from stock, product where
product.product_id=stock.item_id and product.PName=
%s"
itm=(item,)
mycursor.execute(sql,itm)
res=mycursor.fetchall()
for x in res:
print(x)

def SaleProduct():
now=datetime.datetime.now()
saleID=str(now.year)+str(now.day)+str(now.month)
L=[]
L.append(saleID)
itemId=input("Enter Product ID : ")
L.append(itemId)
itemNo=int(input("Enter the number of Items : "))
L.append(itemNo)
sql="select rate from product where product_id=
%s"
pid=(itemId,)
mycursor.execute(sql,pid)
res=mycursor.fetchall()
for x in res:
print("The rate of item is :",x)
dis=int(input("Enter the discount : "))
saleRate=x[0]-(x[0]*dis/100)
L.append(saleRate)
amount=itemNo*saleRate
L.append(amount)
print(L[-1])
mnth=now.month

2
MUSKAN KUMARI
2
DAV ALkusa December 30, 1899

if mnth<=9:
mn="0"+str(mnth)
else:
mn=str(mnth)
day=now.day
if day<=9:
dy="0"+str(day)
else:
dy=str(day)
dt=str(now.year)+"-"+mn+"-"+dy
L.append(dt)
tp=(L)
sql="insert into sales (sale_id,
item_id,no_of_item_sold,sale_rate,amount,date_of_sale
) values(%s,%s,%s,%s,%s,%s)"
mycursor.execute(sql,tp)
mydb.commit()
sql="Select Instock from stock where item_id=
%s"
mycursor.execute(sql,pid)
res=mycursor.fetchall()
for x in res:
print("Total Items in Stock were : ",x)
instock=x[0]-itemNo

if instock>0:
status="Yes"
tp=(instock,status,itemId)
sql="update stock set instock=%s,status=%s
where item_id=%s"
print("Remaining Items in Stock are :
",instock)
mycursor.execute(sql,tp)
mydb.commit()
def ViewSales():
item=input("Enter Product Name : ")
sql="select product.product_id,
product.PName,product.brand,sales.no_of_item_sold,sal
es.date_of_sale,sales.amount from sales, product
where product.product_id=sales.item_id and
product.PName=%s"
itm=(item,)
mycursor.execute(sql,itm)
res=mycursor.fetchall()

2
MUSKAN KUMARI
3
DAV ALkusa December 30, 1899

for x in res:
print(x)
def MenuSet(): #Function For The SFashion Store Sy
print(80*'=','\n')
print("Enter 1 : To Add Product ")
print("Enter 2 : To Edit Product ")
print("Enter 3 : To Delete Product ")
print("Enter 4 : To View Product ")
print("Enter 5 : To Purchase Product")
print("Enter 6 : To View Purchases")
print("Enter 7 : To View Stock Detials")
print("Enter 8 : To Sale the item")
print("Enter 9 : To View Sales Detials")
print("Enter 0 : To EXIT")
try: #Using Exceptions For
Validation
userInput = int(input("Please Select An Above
Option: ")) #Will Take Input From User
except ValueError:
exit("\nHy! That's Not A Number") #Error
Message
else:
print("\n") #Print New Line
if(userInput == 1):
AddProduct()
elif(userInput == 2):
EditProduct()
elif (userInput==3):
DelProduct()
elif (userInput==4):
ViewProduct()
elif (userInput==5):
PurchaseProduct()
elif (userInput==6):
ViewPurchase()
elif (userInput==7):
ViewStock()
elif (userInput==8):
SaleProduct()
elif (userInput==9):
ViewSales()
elif (userInput==0):
exit()
else:

2
MUSKAN KUMARI
4
DAV ALkusa December 30, 1899

print("Enter correct choice. . . ")

MenuSet()

def runAgain():
runAgn = input("\nWant To Run Again Y/n: ")
while(runAgn.lower() == 'y'):
MenuSet()
runAgn = runAgn
runAgain()

2
MUSKAN KUMARI
5
DAV ALkusa December 30, 1899

OUTPUT
>>>
=== RESTART: E:\CLASS XII PYTHON\Final Project\Fashion Store\fashion
store.py ==
To Continue Enter Your Password:kvuc
********************************************************************************
* * * * * * * * * * Welcome to the Project of Fashion Store * * * * * * * * * *
* * * * * * * * * * * Developed by: MUSKAN KUMARI AND JASIKA SINGH * * * * * * *
******
********************************************************************************

Enter 1 : To Add Product

Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials
Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Please Select An Above Option: 1

Enter the Product ID : 105

Enter the Product Name : KURTA
Enter the Product Brand Name : MANYAWAR
Enter Male/Female/Kids : MALE
Enter Winter/Summer : SUMMER
Enter the Rates for Product :1500
One Product inserted

Want To Run Again Y/n: Y

Enter 1 : To Add Product
Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials
Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Please Select An Above Option: 1

Enter the Product ID : 106

Enter the Product Name : LOWER
Enter the Product Brand Name : LEE
Enter Male/Female/Kids : MALE
Enter Winter/Summer : SUMMER
Enter the Rates for Product :350
One Product inserted
Enter 1 : To Add Product
Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product

2
MUSKAN KUMARI
6
DAV ALkusa December 30, 1899

Enter 6 : To View Purchases

Enter 7 : To View Stock Detials
Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Please Select An Above Option: 1

Enter the Product ID : 108

Enter the Product Name : T_SHIRT
Enter the Product Brand Name : POLO
Enter Male/Female/Kids : FEMALE
Enter Winter/Summer : SUMMER
Enter the Rates for Product :352
One Product inserted
Enter 1 : To Add Product
Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials
Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Please Select An Above Option: 1

Enter the Product ID : 109

Enter the Product Name : LEGING
Enter the Product Brand Name : LYRA
Enter Male/Female/Kids : FEMALE
Enter Winter/Summer : WINTER
Enter the Rates for Product :399
One Product inserted
Enter 1 : To Add Product
Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials
Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Please Select An Above Option: 2

Enter product ID to be edited : 109

('109', 'LEGING', 'LYRA', 'FEMALE', 'SUMMER', 399)

Enter the field which you want to edit : season

Enter the value you want to set : winter
Editing Don :
After correction the record is :
('109', 'LEGING', 'LYRA', 'FEMALE', 'winter', 399)

Want To Run Again Y/n: y

Enter 1 : To Add Product
Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases

2
MUSKAN KUMARI
7
DAV ALkusa December 30, 1899

Enter 7 : To View Stock Detials

Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Please Select An Above Option: 4

Display Menu: Select the category to display the data

1. All Details
2. Product Name:
3. Product Brand:
4. Product For:
5. Product Season:
6. Product ID:
Enter your choice to display : 1
('101', 'T Shirt', 'Duck', 'Female', 'Winter', 450)
('102', 'jeans', 'gucci', 'male', 'winter', 5000)
('105', 'KURTA', 'MANYAWAR', 'MALE', 'SUMMER', 1500)
('108', 'T_SHIRT', 'POLO', 'FEMALE', 'SUMMER', 352)
('109', 'LEGING', 'LYRA', 'FEMALE', 'winter', 399)
Enter 1 : To Add Product
Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials
Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Please Select An Above Option: 3

Enter the Product)id to be deleted : 102

One Item Deleted
Enter 1 : To Add Product
Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials
Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Please Select An Above Option: 4

Display Menu: Select the category to display the data

1. All Details
2. Product Name:
3. Product Brand:
4. Product For:
5. Product Season:
6. Product ID:
Enter your choice to display : 2
Enter the name of Product : jeans
Enter 1 : To Add Product
Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials

2
MUSKAN KUMARI
8
DAV ALkusa December 30, 1899

Enter 8 : To Sale the item

Enter 9 : To View Sales Detials
Please Select An Above Option: 4

Display Menu: Select the category to display the data

1. All Details
2. Product Name:
3. Product Brand:
4. Product For:
5. Product Season:
6. Product ID:
Enter your choice to display : 1
('101', 'T Shirt', 'Duck', 'Female', 'Winter', 450)
('105', 'KURTA', 'MANYAWAR', 'MALE', 'SUMMER', 1500)
('108', 'T_SHIRT', 'POLO', 'FEMALE', 'SUMMER', 352)
('109', 'LEGING', 'LYRA', 'FEMALE', 'winter', 399)

>>>
=== RESTART: E:\CLASS XII PYTHON\Final Project\Fashion Store\fashion
store.py ==
To Continue Enter Your Password:kvuc
********************************************************************************
* * * * * * * * * * Welcome to the Project of Fashion Store * * * * * * * * * *
* * * * * * * * * * * Developed by: MUSKAN KUMARI AND JASIKA SINGH * * * * * * *
******
********************************************************************************

================================================================
================

Enter 1 : To Add Product

Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials
Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Enter 0 : To EXIT
Please Select An Above Option: 5

Enter Product ID : 106

Enter the number of Items : 5
rate is : 450
Amount is : 2250
(2,)
1 Item purchased and saved in Database

Want To Run Again Y/n: y

================================================================
================

Enter 1 : To Add Product

Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases

2
MUSKAN KUMARI
9
DAV ALkusa December 30, 1899

Enter 7 : To View Stock Detials

Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Enter 0 : To EXIT
Please Select An Above Option: 6

Enter Product Name : suit

('106', 'Suit', 'Manyawar', 5, datetime.date(2022, 3, 7), 2250)
('106', 'Suit', 'Manyawar', 5, datetime.date(2022, 3, 7), 2250)
================================================================
================

Enter 1 : To Add Product

Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials
Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Enter 0 : To EXIT
Please Select An Above Option: 7

Enter Product Name : suit

('106', 'Suit', 7, 'Yes')
================================================================
================

Enter 1 : To Add Product

Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials
Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Enter 0 : To EXIT
Please Select An Above Option: 8

Enter Product ID : 106

Enter the number of Items : 3
The rate of item is : (450,)
Enter the discount : 12
1188.0
Total Items in Stock were : (7,)
Remaining Items in Stock are : 4
================================================================
================

Enter 1 : To Add Product

Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials

3
MUSKAN KUMARI
0
DAV ALkusa December 30, 1899

Enter 8 : To Sale the item

Enter 9 : To View Sales Detials
Enter 0 : To EXIT
Please Select An Above Option: 9

Enter Product Name : suit

('106', 'Suit', 'Manyawar', 3, datetime.date(2022, 3, 7), 1188)
================================================================
================

Enter 1 : To Add Product

Enter 2 : To Edit Product
Enter 3 : To Delete Product
Enter 4 : To View Product
Enter 5 : To Purchase Product
Enter 6 : To View Purchases
Enter 7 : To View Stock Detials
Enter 8 : To Sale the item
Enter 9 : To View Sales Detials
Enter 0 : To EXIT
Please Select An Above Option: 0

3
MUSKAN KUMARI
1
DAV ALkusa December 30, 1899

BIBLIOGRAPHY
In order to work on this project titled -Fashion- Store Management , the following books
and literature are referred by me during the various phases of development of the project.

1. Computer science With Python - Class XI and XII

By : Sumita Arora
2. Computer science With Python - Class XI and XII
By : Preeti Arora
3. Website: https://www.w3resource.com***
4. Website: http://www.mysql.org/
5. Website: http://www.python.org/
6. Various Websites of Discussion Forum and software development activities.
Other than the above-mentioned books, the suggestions and supervision of
my teacher and my class experience also helped me to develop this software
project.

3
MUSKAN KUMARI
2