ACKNOWLEDGEMENT
I would like to express a deep sense of thanks and gratitude to my
Computer Teacher Mrs. Sylvia Soruparani for guiding me immensely
through the course of project. She always evinced keen interest in my
work. Her constructive advice and constant motivation have been
responsible for the successful completion of project. My sincere thanks
to our beloved principal, Dr. Deepa V for extending every possible
support for the completion of project. Heartful thanks to my parents
and Friends for the support.
INDEX
[Link]. Content Page No.
1 Introduction
2 Source Code
3 MYSQL Databases
4 Outputs
5 Requirements
6 Bibliography
INTRODUCTION
The traditional bookstores that once stood as cultural hubs are
now undergoing a metamorphosis in the face of technological
advancements. The need for an efficient and seamless Book
Store Management System becomes increasingly evident. This
project aims not just to streamline the operations of bookstores
but to usher them into a new era of digital competence and
customer satisfaction.
1. Changes in Bookstores:
Bookstores are no longer just physical spaces; they are evolving
into multidimensional entities that seamlessly blend the
tangible and intangible aspects of literary experiences. The
Book Store Management System project emerges as a beacon
guiding bookstores through this transformative journey. It
acknowledges the evolving landscape of literature consumption
while preserving the essence of the traditional bookstore
experience.
2. Need of Project:
In the digital age, where information travels at the speed of
light, bookstores must adapt or risk becoming relics of the past.
he Book Store Management System project recognizes the need
for innovation in the management and operation of bookstores.
It seeks to address the challenges faced by bookstore owners,
managers, and customers alike.
2.1 Operational Efficiency: One of the primary objectives
of the project is to enhance the operational efficiency of
bookstores. Traditional inventory management systems,
manual record-keeping, and outdated sales processes often
lead to inefficiencies and errors. The Book Store Management
System aims to automate these processes, reducing the
likelihood of human errors and allowing bookstore staff to focus
on providing an enriched customer experience.
2.2. Digital Integration: The Book Store Management
System will facilitate online sales, e-book integration, and
customer engagement through digital channels, ensuring that
bookstores rem0ain relevant and accessible in an increasingly
virtual world Book Store Management 7
3. Features and Functionalities:
Book Store Management System project are a junction of
features and functionalities designed to cater to the diverse
needs of modern bookstores.
3.1. Inventory Management: Efficient inventory
management lies at the heart of a successful bookstore. The
project will implement a sophisticated inventory system that
tracks stock levels in real-time, automatically updating the
database with each sale or restock. This not only minimizes the
risk of stockouts or overstocking but also provides valuable
insights into popular genres, authors, and trends.
3.2. E- Commerce Integration: The project aims to
integrate an e-commerce platform seamlessly with the existing
bookstore infrastructure, allowing customers to browse,
purchase, and receive their favorite books with the click of a
button.
3.3. Analysis: Data-driven decision-making is a
cornerstone of success in any industry. The Book Store
Management System will provide detailed reports and analytics
on sales trends, and inventory turnover. This information
empowers bookstore owners and managers to make informed
decisions, optimize stock levels, and tailor their offerings to
meet the evolving demands of their customer base.
4. Benefits of the Book Store Management System:
The implementation of the Book Store Management System is
not merely a technological upgrade; it is a strategic investment
that yields a multitude of benefits for both bookstore owners
and customers.
4.1. Improved Customer Experience: Customers can
expect quicker transactions, a more extensive selection of
books, and a seamless transition between the physical and
digital aspects of the bookstore. Book Store Management 8
4.2. Operational Efficiency: The project's emphasis on
automation reduces the burden on bookstore staff, allowing
them to focus on providing exceptional service rather than
getting bogged down by administrative tasks. This not only
increases productivity but also contributes to a more positive
and engaging work environment.
4.3. Data Oriented Decision: The reporting and analytics
tools embedded in the system empower bookstore owners to
make informed decisions based on real-time data. Whether it's
adjusting inventory levels, optimizing pricing strategies, the
system provides the insights needed to stay ahead in a
competitive market.
5. Challenges and Consideration:
While the Book Store Management System promises a myriad of
benefits, its implementation is not without challenges.
Addressing these challenges is crucial to ensuring the successful
adoption and integration of the system into existing bookstore
operations.
5.1. Resistance to Change: The transition from traditional
manual processes to a digital management system may be met
with resistance from bookstore staff accustomed to established
routines. Effective training programs, clear communication of
benefits, and ongoing support are essential in overcoming this
resistance and fostering a positive attitude towards the new
system.
5.2. Cost Of Implementation: While the long-term benefits
of the Book Store Management System are substantial, there is
an initial cost associated with its implementation. Bookstore
owners must carefully weigh these costs against the anticipated
benefits to make informed decisions about the system's
implementation.
SOURCE CODE
import [Link]
DB=[Link](host="localhost",user="root",password="tit
an@123",database="inkspire")
C=[Link]()
#table available_books
[Link]("create table if not exists Available_books ( Book_Name
varchar(20), Genere varchar(20),Quantity int, Author varchar(20),
Publication varchar(20), Price int)")
[Link]()
#table sell_rec
[Link]('create table if not exists sell_rec( customer_name
varchar(20), ph_no bigint, book_name varchar(20) ,price int, qty int)')
[Link]()
#table signup
[Link]("create table if not exists signup (Username
varchar(25),password varchar(10))")
[Link]()
#table staff_details
[Link]('create table IF NOT EXISTS staff_details(name
varchar(20),Gender varchar(1), age int, ph_no bigint, address
varchar(50))')
[Link]()
#ADMIN FUNCTIONS
def ADD():
book=input("Enter Book Name: ")
genre=input("Genre:")
quantity=int(input("Enter quantity:"))
author=input("Enter author name:")
publication=input("Enter publication house:")
price=int(input("Enter the price:"))
[Link]("INSERT INTO available_books
values('{}','{}',{},'{}','{}',{})".format(book,genre,quantity,author,publicati
on,price))
[Link]()
print("""++++++++++++++++++++++++SUCCESSFULLY
ADDED++++++++++++++++++++++++""")
n=input("Want To add?(y/n): ")
if n=='y':
ADD()
if n=='n':
Staff()
def NewStaff():
fname=str(input("Enter Fullname:"))
gender=str(input("Gender(M/F/O):"))
age=int(input("Age:"))
phno=int(input("Staff phone no.:"))
add=str(input("Address:"))
[Link](("INSERT INTO staff_details
values('{}','{}',{},{},'{}')".format(fname,gender,age,phno,add)))
[Link]()
print("""++++++++++++++++++++++++++++++STAFF IS SUCCESSFULLY
ADDED++++++++++++++++++++++++++++++""")
n=input("Want To add?(y/n): ")
if n=='y':
NewStaff()
if n=='n':
Staff()
def RemoveStaff():
n=(input("Staff Name to Remove: "))
[Link]("DELETE FROM staff_details WHERE Name=('{}')
".format(n))
[Link]()
print("Above Employee is promoted to Customer")
n=input("Want To continue?(y/n): ")
if n=='y':
RemoveStaff()
if n=='n':
Staff()
def StaffDetails():
q= "Select * from staff_details"
[Link](q)
output =[Link]()
for x in output:
print("************************************")
print("Name of Employ:", x[0])
print("Gender of Employ:", x[1])
print("Age of Employ:", x[2])
print("Phone No of Employ", x[3])
print("Address of Employ:", x[4])
print("************************************")
n=input("Want To continue?(y/n): ")
if n=='y':
StaffDetails()
if n=='n':
Staff()
def SellRec():
[Link]("select * from sell_rec")
for u in C:
print("*********************************************")
print("Buyer Name: ",u[0])
print("Buyer Mobile Number: ",u[1])
print("Book Purchased: ",u[2])
print("Quantity Brought: ",u[3])
print("Price of Book: ",u[4])
print("**********************************************")
n=input("Want To continue?(y/n):")
if n=='y':
SellRec()
if n=='n':
Staff()
def DelRec():
bb=input("Are you sure(Y/N):").upper()
if bb=="Y":
[Link]("delete from sell_rec")
[Link]()
n=input("Want To continue?(y/n):")
if n=='y':
DelRec()
if n=='n':
Staff()
def TotalIncome():
[Link]("select sum(price) from sell_rec")
for x in C:
print("Total Sell Till Date",x)
n=input("Want To add?(y/n):")
if n=='y':
TotalIncome()
if n=='n':
Staff()
def AvailablefS():
[Link]("select * from available_books order by book_name")
output =[Link]()
for v in output:
print("****************************************************")
print("Book Name: ",v[0])
print("Book Genre: ",v[1])
print("Book Available: ",v[2])
print("Book Author: ",v[3])
print("Publication House: ",v[4])
print("Book Price: ", v[5])
print("****************************************************")
n=input("Want To continue?(y/n):")
if n=='y':
AvailablefS()
if n=='n':
Staff()
#USER FUNCTIONS
def AvailablefU():
[Link]("select * from available_books order by book_name")
for v in C:
print("****************************************************")
print("Book Name: ",v[0])
print("Book Genre: ",v[1])
print("Book Available: ",v[2])
print("Book Author: ",v[3])
print("Publication House: ",v[4])
print("Book Price: ", v[5])
print("****************************************************")
n=input("Want To continue?(y/n):")
if n=='y':
AvailablefU()
if n=='n':
Buyer()
def StaffDetailfU():
spl_statement= "Select * from staff_details"
[Link](spl_statement)
output =[Link]()
for x in output:
print("************************************")
print("Name of Employ:", x[0])
print("Gender of Employ:", x[1])
print("Age of Employ:", x[2])
print("Phone No of Employ", x[3])
print("Address of Employ:", x[4])
print("************************************")
n=input("Want To Continue?(y/n):")
if n=='y':
StaffDetailfU()
if n=='n':
Buyer()
def Purchase():
print("AVAILABLE BOOKS...")
[Link]("select * from available_Books ")
for v in C:
print("****************************************************")
print("Book Name: ",v[0])
print("Book Genre: ",v[1])
print("Book Available: ",v[2])
print("Book Author: ",v[3])
print("Publication House: ",v[4])
print("Book Price: ", v[5])
print("****************************************************")
cusname=str(input("Enter customer name:"))
phno=int(input("Enter phone number:"))
book=str(input("Enter Book Name:"))
price=int(input("Enter the price:"))
n=int(input("Enter quantity:"))
[Link]("select quantity from available_books where
Book_Name='"+book+"'")
k=[Link]()
if max(k)<n:
print(n,"Books are not available!!!!")
else:
[Link]("select book_name from available_books where
Book_Name='"+book+"'")
log=[Link]()
if log is not None:
[Link]("insert into Sell_rec
values('"+cusname+"','"+str(phno)+"','"+book+"','"+str(n)+"','"+str(price)+"')"
)
[Link]("update Available_Books set quantity=quantity-
'"+str(n)+"' where Book_Name='"+book+"'")
[Link]()
print("""++++++++++++++++++++++++BOOK HAS BEEN
SOLD++++++++++++++++++++++++""")
else:
print("BOOK IS NOT AVAILABLE!!!!!!!")
n=input("Want To Continue?(y/n):")
if n=='y':
Purchase()
if n=='n':
Buyer()
def UsingName():
o=input("Enter Book to search:")
[Link]("select book_name from available_books where
book_name ='"+o+"'")
t=[Link]()
if t != None:
print("""++++++++++++++++++++++BOOK IS IN
STOCK++++++++++++++++++++++""")
else:
print("BOOK IS NOT IN STOCK!!!!!!!")
n=input("Want To Continue?(y/n):")
if n=='y':
UsingName()
if n=='n':
Buyer()
def UsingGenre():
g=input("Enter genre to search:")
[Link]("select genre from available_books where genre=
'{}'".format(g,))
poll=[Link]()
if poll !=[]:
print("""++++++++++++++++++++++BOOK IS IN
STOCK++++++++++++++++++++++""")
[Link]("select * from available_books where
genre='{}'".format(g,))
for v in C:
print("*******************************************")
print("Book Name: ",v[0])
print("Book Genre: ",v[1])
print("Book Available: ",v[2])
print("Book Author: ",v[3])
print("Publication House: ",v[4])
print("Book Price: ", v[5])
print("*******************************************")
else:
print("BOOKS OF SUCH GENRE ARE NOT AVAILABLE!!!!!!!!!")
n=input("Want To Continue?(y/n):")
if n=='y':
UsingGenre()
if n=='n':
Buyer()
def UsingAuthor():
o=input("Enter Book's Author to search:")
[Link]("select book_name from available_books where Author
='"+o+"'")
t=[Link]()
if t != None:
print("""++++++++++++++++++++++BOOK IS IN
STOCK++++++++++++++++++++++""")
else:
print("BOOK IS NOT IN STOCK!!!!!!!")
n=input("Want To Continue?(y/n):")
if n=='y':
UsingGenre()
if n=='n':
Buyer()
def Staff():
print(""" 1:Add Books
[Link] Details
[Link] Record
[Link] Income after the Latest Reset
5. See Available Book
6. Exit""")
n=int(input("Enter Your Choice: "))
#To Add Books into the database
if n==1:
ADD()
#Choice For New Staff, Fire staff, View Staff
if n==2:
print(""" 1:New staff entry)
2:Remove staff
3:Existing staff details""")
ch=int(input("Enter your choice: "))
if ch==1:
NewStaff()
#REMOVE STAFF
if ch==2:
RemoveStaff()
#EXISTING STAFF DETAILS
if ch==3:
StaffDetails()
#To See Selling histroy & altering it
if n==3:
print(""" 1:Sell history details
2:Reset Sell history""")
ty=int(input("Enter your choice:"))
if ty==1:
SellRec()
if ty==2:
DelRec()
#To view total Total Income
if n==4:
TotalIncome()
#Viewing Available Book As Staff
if n==5:
AvailablefS()
#Break
if n==6:
return
def Buyer():
#USER Choices
print(""" [Link] Books
[Link] Books
[Link] Books
[Link] Details
5. Exit""")
r=int(input("Enter Your Choice: "))
#TO PURCHASE BOOK
if r==1:
Purchase()
#Searching of books using Name,Genre,Author
if r==2:
print(""" 1:Search by name
2:Search by genre
3:Search by author""")
l=int(input("Search by What : "))
#Searching Using Name of Book
if l==1:
UsingName()
#Searching Using Genre of Book
if l==2:
UsingGenre()
#Searching Using Author Name
if l==3:
UsingAuthor()
#To See Available Books
if r==3:
AvailablefU()
#To See Present Staff Details
if r==4:
StaffDetailfU()
#MAIN PROGRAM
print("**********************************************Welcome To Book
Store***************************************************")
while 1:
a=int(input("""Enter as Employee: 1
Enter as User: 2
Exit : 3
Enter : """ ))
if a==1:
Staff()
if a==2:
print("""****************BOOK SHOP*********************
1. Signup
2. login""")
s=int(input("Enter Your Choice: "))
#Sign-Up
if s==1:
user_name=input("USERNAME(ex: abcd1234): ")
password=input("PASSWORD: ")
[Link]("insert into signup
values('"+user_name+"','"+password+"')")
[Link]()
print("Sign Up Completed")
#Log in
else:
user2= input("Enter Your Username: ")
[Link]("select username from Signup where
username='{}'".format(user2,))
b=[Link]()
if b ==None:
print("************************incorrect
username********************")
b1=input("Enter Your Password: ")
[Link]("select password from signup where
password='{}'".format(b1,))
a2=[Link]()
if a2 ==None:
print("************************incorrect
password********************")
else:
print("************************Login successful********************")
Buyer()
if a==3:
break
MYSQL DATABASES
OUTPUT
REQUIREMENTS
HARDWARES
Processor:
Minimum: Dual-core processor (Intel i3 or equivalent)
Recommended: Quad-core processor (Intel i5 or equivalent) for
better performance.
Memory (RAM):
Minimum: 4 GB RAM
Recommended: 8 GB RAM or more for smoother operation,
especially when running a database server.
SOFTWARES
1. Python (Latest Stable Version).
2. MySQL (Latest Stable Version).
3. BCrypt Module – For Hashing Passwords.
4. Re Module – Validating Email formats.
5. Getpass Module – For Handling Passwords Input.
6. MySQL Connector Module – For connecting Python and
MySQL.
BIBLIOGRAPHY
Books
1. Computer science with Python (Sumita Arora).
2. Computer Science NCERT Textbook.
Web Resources
1. Python Software Foundation. (n.d.). Python Documentation.
Retrieved from [Link]
Official documentation for Python programming language.
2. Oracle. (n.d.). MySQL Documentation. Retrieved from
[Link]
Comprehensive guide to MySQL commands, syntax, and
configuration.
Libraries and Frameworks
1. The MySQL Team. MySQL Connector for Python. Available at
[Link]
Documentation and installation instructions for MySQL Connector,
used for database connectivity in Python.
2. Pallets Projects. Flask Documentation. Retrieved from
[Link]
Used if the project involves web-based management of bank
records.