INDEX
1. Brief overview of project.
2. Needs For Computerization
3. Software and Hardware requirement.
4. Advantages of project.
5. Database structure.
6. Python source code
7. Output Screen
8. Bibliography.
BRIEF OVERVIEW OF PROJECT
• The System stores all information of the Mobiles.
• System provides the facility of Mobile Information with their Prices.
• System Provides facility of payment and purchase Products.
• This system has large scope for the mobile shop management system and mobile
information.
• The main objective of the python project on mobile shop management is to
manage the details of product, customer, employ and bill. The project is totally
built on administrative and only the administrator is guaranteed the access. The
purpose of the of the project is to built an application program to reduce the
manual work for managing orders and generating bills. It tracks all the details
about list of products it also prints various reports as per input given by the
users.
NEEDS OF COMPUTERISATION
Over the decade’s computer and phone products purchasing have developed gradually,
changed with time. But nobody knew that a time will come when both these fields
will complement each other so well. Today my mobile shop management has reached
new height by computer aided methods of designing. As a result of which, computer
industry has got its new customer. Computer technology is making waves in the
selling mobile phones. Computer are a vital component of my business booking
counter. Computer aided design (CAD) programs reduce the demand for manual skills.
Those who lag in math can knew breathe a little easier.
Manually figuring of price of mobile insists the knowledge. Software programs
constanty evolve. A program used today may be obsolete within several years. Being
trained on today’s software does not guarantee it will be used when you are ready
to go out into the fields. Understanding calculations is timeless ,as is computer
competency. Software , however, shifts rapidly.
SOFTWARE AND HARDWARE REQUIREMENT
Data file handling has been effectively used in the program. The database is a
collection of interrelated data to serve multiple applications. That is database
programs creates files of information. So we see that files are worked with most
inside the program.
DBMS: The software required for the management of data is called DBMS. It has 3
models:
• Relation model
• Hierarchical model
• Network model
RELATIONAL MODEL: It’s based on the concept of relation. Relation is the
table that consists of rows and columns. The rows of the table are called tuple and
the columns of the table are called attribute. Numbers of rows in the table is
called as cardinality. Number of columns in a table is called as degree.
HIERARCHICAL MODEL: In this type of model, we have multiple record for each
record. A particular record as one parent record. No child record can exist without
parent [Link] this the records are organized in tree.
NETWORK MODEL: In this, the data is represented by collection of records and
relationship is represented by (ink or association.)
ADVANTAGES
1. Increase your productivity.
2. It generates the reports on total sales.
3. Can store massive amounts of information and reduce waste.
4. Get a better understanding of data. Helps sort, organize and search through
information.
5. It has higher efficiency of editing , adding and updating of records.
PYTHON CODING
import [Link] as sq
import [Link] as plt
md=[Link](host="localhost",user="root",password="admin",database="Mobile_Shop_M
anagement",charset='utf8')
cursor=[Link]()
user=input('PLEASE ENTER YOUR USERNAME')
pwd=input('PLEASE ENTER YOUR PASSWORD')
[Link]("select*from login where username="'+user+'" and password="'+pwd+"')
if [Link]() is None:
print("SORRY YOUR PASWORD IS INCORRECT")
quit()
else:
print("~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~")
print("LOGIN SUCCESSFUL")
print("press 1:To add a product")
print("press 2:To view products available")
print("press 3:To add an customer")
print("press 4:To view detils of customer")
print("press 5:To add an employee")
print("press 6:To view details of employee")
print("press 7:To generate a bill")
print("press 8:To view a bill")
print("press 9:To view graphical analysis of sales")
print("press 10:To quit")
choice=int(input("Enter your choice:"))
if choice==1:
ID=int(input("Enter product ID:"))
Com=input("enter company:")
Price=int(input("enter product price:"))
details=input("enter product Details:")
[Link]("insert into PRODUCT_AVAILABLE
values('{}','{}','{}','{}')".format(ID,Com,Price,details))
if [Link]==0:
print("[Link]")
else:
print("data update successfully")
[Link]()
choice=int(input("enter your choice:"))
if choice==2:
product_id=int(input("Enter product id"))
[Link]("select*from PRODUCT_AVAILABLE where product_id
like'"+str(product_id)+"'")
data=[Link]()
for i in data:
print("Product_id:",i[0])
print("Company:",i[1])
print("Product_price:",i[2])
print("Product_details",i[3])
print("======================================================================")
choice=int(input("Enter your choice:"))
if choice==3:
cust_id=input("enter the id of the customer:")
cust_name=input("enter the customer name:")
cust_address=input("enter the customer address:")
phone_no=int(input("enter the phone no of the customer:"))
[Link]("insert into customer
values('{}','{}','{}','{}')".format(cust_id,cust_name,cust_address,phone_no))
print("ENTRY SUCCESSFULLY")
[Link]()
choice=int(input("Enter your choice:"))
if choice==4:
cust_name=input("Enter the customer name")
[Link]("select * fromcustomer where cust_name like'"+
(cust_name)+"'")
data=[Link]()
if data!=0:
for row in data:
print()
print("Here are the customer details")
print()
print("Customer id is:",row[0])
print("Customer name is:",row[1])
print("Customer address is:",row[2])
print("Phone no is:",row[3])
input()
choice=int(input("Enter your choice:"))
else:
print("Customer does not exist")
choice=int(input("Enter your choice:"))
if choice==5:
emp_id=input("Enter Employee ID:")
emp_name=input("Enter new employee name:")
emp_profession=input("Enter employee profession:")
salary=input("Enter salary:")
age=input("Enter age:")
phone_no=input("Enter your phone number:")
[Link]("insert into EMPLOYEE
values('{}','{}','{}','{}','{}','{}')",format(emp_id,emp_name,emp_profession,salary
,age,phone_no))
if [Link]==0:
print("Please try again.")
else:
print("Data updated successfully")
[Link]()
choice=int(input("Enter your choice:"))
if choice==6:
employee_id=input("Enter employee_id")
[Link]("select * from employee where emp_id like '"+
(employee_id)+"'")
data=[Link]()
for i in data:
print("Employee ID:",i[0])
print("Employee Name:",i[1])
print("Profession:",i[2])
print("Salary:",i[3])
print("Age:",i[4])
print("Phone number:",i[5])
print("= = = = = = = = = = = = = = = = = = = = = = = = =")
choice=int(input("Enter your choice:"))
if choice==7:
invoice_no=input("enter the invoice no:")
date_of_purchase=input("enter the date of purchase:")
prod_id=input("enter the product id:")
prod_name=input("enter the product name:")
qty=int(input("enter the quantity of product:"))
prod_price=int(input("enter the price:"))
net_amount=qty*prod_price
[Link]("insert into bill
values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')".format(invoice_no,date_of_purcha
se,prod_name,qty,prod_price,net_amount))
[Link]()
print("ORDER COMPLETED")
a=input("to continue press any key")
choice=int(input("enter your choice"))
if choice==8:
invoice_no=input("enter the invoice no:")
[Link]("select * from bill where invoice_no like'"+
(invoice_no)+"'")
data=[Link]()
for i in data:
print("Invoice number:",i[0])
print("Date of purchase:",i[1])
print("Product ID:",i[2])
print("Quantity:",i[3])
print("Product price:",i[4])
print("Total amount:",i[5])
print("= = = = = = = = = = = = = = = = = = = = = = = = =")
if [Link]==0:
print("Please try again.")
else:
print("Data updated successfully")
[Link]()
choice=int(input("Enter your choice:"))
if choice==9:
c1=[Link]()
quer="select count(*) from product_available where
company='iphone'"
[Link](quer)
x=[Link]()
Ist=list(x)
quer="select count(*) from product_available where
company='samsung'"
[Link](quer)
y=[Link]()
Ist1=list(y)
quer="select count(*) from product_available where company='vivo'"
[Link](quer)
z=[Link]()
Ist2=list(z)
quer="select count(*) from product_available where company='redmi'"
[Link](quer)
w=[Link]()
Ist3=list(w)
Ist=Ist+Ist1+Ist2+Ist3
xyz=["iphone","samsung","vivo","redmi"]
[Link](xyz,Ist5)
[Link]("Product Name")
[Link]("Qty available")
[Link]([1,2,3,4,5])
[Link]("Sales")
[Link]()
choice=int(input("Enter your choice:"))
if choice==10:
print("********** THANK YOU **********")
print("********** VISIT AGAIN **********")
quit()
DATABASE STRUCTURE
The database structure for the following program is:
• Create a database named MOBILE_SHOP_MANAGEMENT
• To make tables in this database , write the following commands:
• Create table Login , product available, Bill, Customer, Employee and
describe:
OUTPUT
LOGIN WINDOW
1. TO ADD A NEW PRODUCT
[Link] VIEW AVAILABLE PRODUCT
[Link] ADD A CUSTOMER
[Link] VIEW CUSTOMER DETAILS
[Link] ADD AN EMPLOYEE
[Link] VIEW EMPLOYEE DETAILS
[Link] GENERATE A BILL
[Link] VIEW A BILL
[Link] GRAPHICAL ANALYSIS OF NUMBER OF PRODUCT SOLD
[Link] QUIT
BIBLIOGRAPHY
[Link] Practices Textbook class12
[Link]://[Link]
[Link]://[Link]
[Link] teacher and friends