KENDRIYA VIDYALAYA NO : 1 RAIPUR

SESSION 2023-2024

COMPUTER SCIENCE PRACTICAL

PROJECT
THEME :- LIBRARY MANAGEMENT
SYSTEM

SUBMITTED BY: SUBMITTED TO:

NAME: VRUSHABH NIPANE Mrs. DIVYA SAHU
CLASS: 12TH A
ROLL NO: 12125
 INDEX

S.NO
TITLE
1 CERTIFICATE

2 DECLARATION

3 ACKNOWLEDGEMENT
4 OBJECTIVE

5 INTRODUCTION

6 CODE FOR PROJECT

7 OUTPUT
8 FUTURE SCOPE

9 CONCLUSION

10 BIBLIOGRAPHY
 Certificate
This is to certify that VRUSHABH NIPANE
student
of class XII A (Sci.) has successfully
prepared the report on the
Project entitled “Library management
system.”
under the guidance of
Mrs. DIVYA SAHU (PGT C.S ).
The report is the result of his efforts &
endeavors.
The report is found worthy of acceptance
as final
Project report for the subject Physics
of class XII (sci.).

Signature of Signature of
physics teacher External Examiner
 Acknowledgment
I would like to express my sincere gratitude to all those who
have contributed to the successful completion of my physics
project. This project, titled [Library management
system.], was undertaken as a part of my academic
curriculum in Class 12th A at Kendriya Vidyalaya No. 1,
Raipur.
First and foremost, I extend my heartfelt appreciation to my
physics teacher Mrs. DIVYA SAHU whose guidance and
support were invaluable throughout the project. Their
expertise and dedication provided me with the necessary
direction to undertake this endeavor.
Finally, I would like to acknowledge the extensive resources
available at Kendriya Vidyalaya No. 1, Raipur, including the
well-equipped laboratory, library, and access to relevant
materials, which greatly contributed to the successful
completion of this project.
Thank you all for your valuable assistance and support.

Vrushabh Nipane
Class 12th A
 Declaration

I hereby declare that the project work

entitled “Library management system”,
submitted to Department of Physics,
Kendriya Vidyalaya No 1 Raipur is prepared
by me .

VRUSHABH NIPANE
12TH A
 THEME: LIBRARY MANAGEMENT
SYSTEM

File imported in python :

• Mysql ( for database connectivity)

Functions used in project :

❑Connect()
❑Cursor()
❑Fetchall()
❑Fetchone()
❑Commit()
Introduction to Library
Management System:

A Library Management System

(LMS) is a comprehensive
software solution designed to
streamline and automate the
operations of a library, making the
process of book management,
borrower tracking, due date
monitoring, and fine calculation
more efficient and user-friendly.
This system benefits both
librarians and library users by
providing a centralized platform to
manage the entire library
ecosystem.
1. Overview: A library serves as a
hub of knowledge, and managing
its resources effectively is crucial.
A well-implemented Library
Management System not only
simplifies administrative tasks but
also enhances the overall library
experience for patrons.
2. Purpose: The primary purpose
of the Library Management
System is to digitize and organize
the day-to-day activities within a
library. It eliminates manual
record-keeping, reduces human
errors, and improves the
accessibility and retrieval of
information.
3. Key Features:
•Book Management: Efficiently
catalog and manage the library's
collection. Each book is assigned a
unique identifier, and details such
as title, author, and available
copies are stored in the system.
•Borrower Tracking: Keep track of
library users by recording their
information, allowing librarians to
monitor borrowing activities and
maintain a record of each patron's
history.
•Due Date Monitoring: Implement
due date reminders to alert both
librarians and users about
upcoming return dates, helping to
manage the library's inventory
effectively.
•Fine Calculation: Automate the
fine calculation process for
overdue books. The system
calculates fines based on
predefined rules, ensuring fairness
and transparency.
•User-Friendly Interface: A user-
friendly interface is crucial for the
success of the system. It allows
librarians to perform their tasks
•efficiently and provides an easy
and intuitive experience for library
users.
4. Components:
•Front-End (User Interface): The
user interface is designed to be
intuitive and accessible. It includes
features such as book search,
borrowing requests, account
management, and fine payment.
•Back-End (Database and Logic):
The back-end manages the
database where information
about books, borrowers, due
dates, and fines is stored. It also
includes the logic for automated
processes such as fine calculation
 and due date monitoring.
5. Benefits:
•Efficiency: Automation of routine
tasks reduces manual workload for
librarians, allowing them to focus on
more critical aspects of library
management.
•Accuracy: The system minimizes errors
associated with manual record-
keeping, ensuring accurate and up-to-
date information about books and
borrowers.
•Accessibility: Library users can
conveniently search for books, place
borrowing requests, and check their
account status from anywhere with an
internet connection.
Python overview:

Python is a high-level, interpreted,

and general-purpose
programming language known for
its readability and versatility. It
was created by Guido van Rossum
and first released in 1991. Python
emphasizes code readability, ease
of use, and the ability to express
concepts in fewer lines of code,
making it a popular choice for
beginners and experienced
developers alike.
2. Key Characteristics:
•Readability: Python's syntax is
designed to be clear and readable,
using English keywords instead of
punctuation. This readability
reduces the cost of program
maintenance and development.
•Versatility: Python supports
multiple programming paradigms,
including procedural, object-
oriented, and functional
programming. It can be used for
web development, data science,
artificial intelligence, automation,
and more.
•Interpreted and Interactive:
Python is an interpreted language,
meaning that the source code is
executed line by line. It also
supports an interactive mode,
allowing developers to execute
code interactively and experiment
with concepts.
•Extensive Standard Library:
Python comes with a large
standard library that includes
modules and packages for various
tasks, ranging from web
development to data analysis. This
reduces the need for external
libraries in many cases.
3. Python Ecosystem:
•Package Management: Python
uses package managers like pip
and conda to facilitate the
installation, distribution, and
management of external libraries
and dependencies.
•Frameworks: Python has a rich
ecosystem of frameworks for
different domains. Flask and
Django are popular for web
development, TensorFlow and
PyTorch for machine learning, and
Pandas for data analysis.
4. Community and Support:
•Active Community: Python has a
large and active community of
developers, contributing to its
growth and evolution. The Python
Software Foundation (PSF)
oversees the development of the
language and supports community
initiatives.
•Documentation: Python is well-
documented, with comprehensive
official documentation and
numerous tutorials available
online. This makes it easy for
developers to learn and find
information about the language
and its libraries.
5. Applications:
•Web Development: Python is
widely used for web development,
with frameworks like Django and
Flask simplifying the process of
building robust and scalable web
applications.
•Data Science and Machine
Learning: Python is a popular
choice for data science and
machine learning due to libraries
such as NumPy, Pandas, scikit-
learn, TensorFlow, and PyTorch.
•Automation and Scripting:
Python's simplicity and readability
make it an excellent choice for
writing scripts and automating
tasks.
•DevOps and System
Administration: Python is used for
scripting in DevOps and system
administration tasks, providing
tools for configuration
 management, deployment, and
infrastructure automation.
6. Python 2 vs. Python 3:
•Python 2 reached its end of life
on January 1, 2020. New projects
should use Python 3, as it includes
many improvements and is the
focus of ongoing development.
Python code:
import mysql.connector
#con=mysql.connector.connect(host="localhost",user="root",p
asswd="password")
#cur=con.cursor()
#cur.execute("create database library")
con=mysql.connector.connect(host="localhost",user="root",pa
sswd="password",database="library")
#cur=con.cursor()
#cur.execute("create table books (bname
varchar(50),bcode varchar(10),total int, subject
varchar(50))")
#cur.execute("create table issue (bname varchar
(50),regno varchar (10), bcode int, issue varchar (50))")
#cur.execute("create table submit (bname varchar
(50),regno varchar (10), bcode int, submit varchar
(50))")
#con.commit()
def addbook():
bn = input("Enter book Name : ")
c=input("Enter Book Code: ")
t =input("Total Books : ")
s = input("Enter Subject: ")
data = (bn,c,t,s)
sql = 'insert into books values( %s,%s ,%s ,%s)'
c = con.cursor()
c.execute(sql,data)
con.commit()
print(">--------------------------------------------------- <")
print("Data Entered Successfully")
main()
def issueb():
n = input("Enter Name : ")
r=input("Enter Reg No: ")
co=input("Enter Book Code: ")
d=input("Enter Date : ")
a = "insert into issue values(%s,%s ,%s ,%s)"
data = (n,r,co,d)
c = con.cursor()
c.execute(a,data)
con.commit()
print(">-------------------------------------------------
--------------------------------------------------------------
---------------------<")
print("Book issued to : ",n)
bookup(co,-1)
def bookup(co,u):
a = "select total from books where bcode =
%s"
data = (co,)
c = con.cursor()
c.execute(a,data)
myresult = c.fetchone()
t = myresult[0] + u
sql = "update books set total = %s where
total =%s"
d = (t,co)
c.execute(sql,d)
con.commit()
main()
def dbook():
ac =input("Enter Book Code: ")
a = "delete from books where bcode = %s "
data = (ac,)
c = con.cursor()
c.execute(a,data)
con.commit()

print("Data removed Successfully")

main()
def dispbook():
a = "select * from books"
c = con.cursor()
c.execute(a)
myresult = c.fetchall()
 for i in myresult:
print("book name: ",i[0])
print("book code: ",i[1])
print("Total: ",i[2])
print("subject: ",i[3])
print(">----------------------------------------------
--------------------------------------------------------------
------------------------<")
main()
def main():
print ("""
............LIBRARY MANAGER
INTERFACE.............

1. ADD BOOK
2. ISSUE BOOK
3. SUBMIT BOOK
4. DELETE BOOK
5. DISPLAY BOOK
""")
choice = input("Enter Task no : ")
print(">-------------------------------------------------
---------------------------------------------------------<")
 if (choice=='1'):
addbook()
elif (choice=='2'):
issueb()
elif (choice=='3'):
submitb()
elif (choice =='4'):
dbook()
elif (choice =='5'):
dispbook()
else:
print("Try again....................")
print(">----------------------------------------------------------
--------------------------------------------------------------------------
<")
def pswd():
ps=input("Enter Password ____: ")
if ps=="password":
main()
else:
print("Try again.....................")
print(">----------------------------------------<")
pswd()
pswd()
Output screen :
1. Table created.

2. Fields on table books .

3. Fields on table issue .

4. Fields on table submit:

5. Login Screen: python interface

{security purpose}

6. Adding Books…:
7 Issue books:

8. Submit Books…:

9. Delete Books…:
10 Display books….:

Limitations of Library Management Systems:

1.Dependency on Technology: Library management
systems heavily rely on technology, and any technical
issues, such as server failures or software glitches, can
disrupt normal library operations.
2.Initial Implementation Cost: Implementing a robust
library management system may involve significant
initial costs, including software development,
hardware infrastructure, and staff training.
3.User Training: Transitioning to a new library
management system requires training for library staff
and users. Resistance to change or the learning curve
for new software can be a limitation.
4.Data Security Concerns: Libraries handle
sensitive information such as user details and
book records. Security breaches or
unauthorized access could compromise the
privacy and confidentiality of this
information.
5.Limited Customization: Some library
management systems may have limitations in
terms of customization. Libraries with specific
or unique requirements may find it
challenging to tailor the system to their exact
needs.
6.Integration Issues: Integration with other
systems, such as educational institutions or
external databases, may pose challenges.
Incompatibility issues between different
software can hinder seamless integration.
Future Scope of Library Management
Systems:
1.Artificial Intelligence (AI) Integration: AI can
be integrated to enhance the efficiency of
library systems. For example, AI algorithms can
help in predicting book demands, recommending books
based on user preferences, and optimizing resource
allocation.
2.Enhanced User Experience: Future library management
systems may focus on improving the user experience
through more intuitive interfaces, personalized
recommendations, and seamless integration with digital
resources.
3.Cloud-Based Solutions: Moving towards cloud-based
solutions can offer scalability, accessibility, and cost-
effectiveness. Cloud-based library management systems
can provide easy access to information from various
locations and devices.
4.Blockchain for Security: Implementing blockchain
technology can enhance the security of library
management systems by providing a decentralized and
tamper-proof system for managing transactions and
records.
5.Data Analytics for Decision Making: Advanced data
analytics can be employed to gain insights into user
behavior, book circulation patterns, and resource
utilization. This data-driven approach can aid in decision-
making for resource allocation and collection
development.
6.Mobile Integration: Increasing mobile integration,
including mobile apps for catalog search, borrowing, and
notifications, can improve accessibility and user
engagement.
 Conclusion:

In conclusion, a well-designed Library

Management System is an invaluable
tool for modern libraries. It not only
simplifies administrative processes
but also enhances the overall
experience for librarians and library
users. By embracing technology,
libraries can better serve their
communities and foster a culture of
lifelong learning and knowledge
dissemination.
Bibliography:

➢ www.slideshare.com
➢ www.python.mykvs.in
➢ Sumita arora class 12 python