A Project Report On
"LIBRARY MANAGEMENT SYSTEM"
SUBMITTED BY : DIVYANSH DUBEY
CLASS : 12th SCIENCE
BOARD ROLL NO :
UNDER THE GUIDANCE OF: Mrs. ALKA CHAWLA
ACKNOWLEDGEMENT
This is to certify that DIVYANSH DUBEY Of class
12th Science has prepared the report on the
Project entitled "Library Management System". The
report is the result of his efforts and endeavors.
The report is found worthy of acceptance as final
project report for the subject Computer Science of
class XII. He has prepared the project under the
guidance of the subject teacher Mrs. Alka Chawla
(Mrs. Alka Chawla)
DECLARATION
I hereby declare that the project work entitled
"Library management System", submitted to
Department of computer science, St. Xaviers world
school is prepared by me. All the coding are result
of my personal efforts.
DIVYANSH
DUBEY
12th Science B
INDEX
1. Brief overview of the Project
2. Need of Computerization
3. Software and Hardware requirement
4. Advantages of the Project
5. Source code of Project
6. Output Screens
7. Bibliography
LIBRARY MANAGEMENT
SYSTEM
BRIEF OVERVIEW OF PROJECT
The Library Management System is a software
project designed to simplify and automate the daily
operations of a library. It helps in efficiently
managing books, users, and transactions such as
issuing, returning, and tracking borrowed books.
The system maintains a digital database of all library
resources, reducing the need for manual record-
keeping and minimizing errors.
This project aims to provide an easy-to-use interface
for both librarians and students, ensuring quick
access to book details and user information. Key
features include book search, user registration,
issue/return management, and report generation.
By digitizing the library operations, the system
enhances accuracy, saves time, and improves the
overall management process.
INPUT DATA AND VALIDATION OF PROJECT
[Link] the fields such as addition of new members,
list of issued books, new books, etc. are
validated and does not take invalid values.
[Link] form of operations cannot accept the
blank values.
[Link] errors in data.
[Link] amount of input.
SOFTWARE AND HARDWARE REQUIREMENTS:
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 create 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 as DBMS. It has 3 models:
• Relation model
• Hierarchical model
• Network model
RELATIONAL MODEL:
It's based on the concept on relation. Relation is
the table that consists of rows and columns. The
rows of the table are called tuple and the columns
of Numbers of the rows table are called attribute.
in the table is called as cardinality. Number of
columns in the table is called as degree.
HIERARCHICAL MODEL:
In this type of model, we have multiple records for
each record. A particular record has one parent
record. No chide record can exist without parent
record. In 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.
CHARACTERISTICS OF DBMS:
• It reduces the redundancy
• Reduction of data in inconsistency
• Data sharing
• Data standardization
DIFFERENT TYPES OF FILES: -BASED ON ACCESS:
• Sequential file
• Serial file
• Random (direct access) file BASED ON
STORAGE:- • Text file
• Binary File
NEED OF
COMPUTERISATION
With the rapid growth of information and the
increasing number of library users, traditional
manual library systems have become inefficient
and difficult to manage. Computerisation in library
management is therefore essential to ensure
smooth, accurate, and organized operations. A
computerized library management system helps
automate various tasks such as cataloguing,
indexing, book issue and return, fine calculation,
and record maintenance. It minimizes human
errors, saves time, and reduces paperwork.
Furthermore, computerisation allows users to
easily search for books or resources through an
online catalogue, check their availability, and even
reserve or renew them remotely. It enables
librarians to generate quick reports, track usage
patterns, and manage large collections effectively.
Data security and backup are also enhanced in a
digital system.
Overall, computerisation transforms the library into
a more efficient, accessible, and user-friendly
environment, supporting both librarians and
readers in the digital age. It is a necessary step
toward modernizing educational institutions and
promoting better information management.
ADVANTAGES
1. Saves time by automating daily library tasks
such as issuing, returning, and tracking
books.
2. Reduces manual effort and minimizes errors
through accurate digital record management.
3. Provides quick and convenient access to book
and user information whenever needed.
4. Keeps all records well-organized, making it easy
to monitor issued, returned, and overdue
books.
5. Offers a simple and user-friendly interface that
can be easily used by both students and
librarians.
6. Ensures data security through user
authentication and restricted access to
sensitive information.
7. Can be upgraded or expanded easily to include
new features like fine calculation or online book
reservation.
SOURCE CODE SCREEN
DBMS: MYSQL
Host: local host
User: root
Password: root
Database: library: (Image below)
PYTHON CODE
# For DB Creation:
# For main program :
OUTPUT SCREEN
BIBLIOGRAPHY
1. [Link]
2. [Link]
3. Computer science with python by Sumita Arora
Thanks
A lot!
DIVYANSH DUBEY
CLASS: 12th Science