PM SHRI KENDRIYA VIDYALAYA NMR JNU NEW DELHI

ACADEMIC YEAR : 2025-26

PROJECT REPORT ON

LIBRARY MANAGEMENT SYSTEM

CBSE BOARD ROLL NO :

NAME : SHIVAM YADAV

CLASS : XII B

SUBJECT : COMPUTER SCIENCE

SUB CODE : 083

PROJECT GUIDE: Mr MAHESH CHAND PAL PGT (CS)

PM SHRI KV NMR JNU

1
 PM SHRI KENDRIYA VIDYALAYA NMR JNU NEW DELHI

CERTIFICATE

This is to certify that _____________ CBSE Roll

No:_________________ has successfully completed the project Work

entitled EMPLOYEE MANAGEMENT SYSTEM in the subject Computer

Science (083) laid down in the regulations of CBSE for the purpose of

Practical Examination in Class XII to be held in PM SHRI KV NMR

JNU NEW DELHI on______________.

(MAHESH CHAND PAL)

PGT Comp Sci
Master IC

Signature of External Examiner

Name: _______________________

Examiner Number:_______________

PRINCIPAL

2
 TABLE OF CONTENTS [ T O C ]

SER DESCRIPTION PAGE NO

01 ACKNOWLEDGEMENT 04

02 INTRODUCTION 05

03 OBJECTIVES OF THE PROJECT 05

04 PROPOSED SYSTEM 06

05 SYSTEM DEVELOPMENT LIFE CYCLE (SDLC) 07

06 PHASES OF SYSTEM DEVELOPMENT LIFE CYCLE 08

07 FLOW CHART 15

08 SOURCE CODE 16

09
OUTPUT 19

10 INSTALLATION FILE 21

10 TESTING 25

11 HARDWARE AND SOFTWARE REQUIREMENTS 27

12 BIBLIOGRAPHY 29

3
 ACKNOWLEDGEMENT

Apart from the efforts of me, the success of any project depends largely
on the encouragement and guidelines of many others. I take this
opportunity to express my gratitude to the people who have been
instrumental in the successful completion of this project.

I express deep sense of gratitude to almighty God for giving me

strength for the successful completion of the project.

I express my heartfelt gratitude to my parents for constant

encouragement while carrying out this project.

I gratefully acknowledge the contribution of the individuals who

contributed in bringing this project up to this level, who continues to look
after me despite my flaws,

I express my deep sense of gratitude to the luminary The Principal,

PM SHRI KV JNU who has been continuously motivating and extending
their helping hand to us.

My sincere thanks to Mr. Mahesh Chand Pal, PGT CS, A guide,

Mentor all the above a friend, who critically reviewed my project and
helped in solving each and every problem, occurred during
implementation of the project

The guidance and support received from all the members who
contributed and who are contributing to this project, was vital for the
success of the project. I am grateful for their constant support and help.

4
 PROJECT ON LIBRARY MANAGEMENT SYSTEM

INTRODUCTION

The Library Management System is a computer-based application

developed to manage the daily operations of a library in an efficient and

systematic way. Traditional libraries often face problems such as

difficulty in maintaining records, locating books, issuing books manually,

and keeping track of due dates. This project is designed to overcome

these problems by computerizing the library activities.

The system helps in storing complete information about books, students,

issue records, and returns in a structured database. It allows the librarian

to easily add new books, search books, issue and return books, and

generate records with accuracy and speed. The project reduces

paperwork, saves time, minimizes human errors, and ensures better

organization of library resources.

Thus, the Library Management System provides a user-friendly, reliable,

and efficient solution for managing library operations, making the library

more productive and convenient for both students and librarians.

5
OBJECTIVES OF THE PROJECT

1.  To computerize library operations and reduce manual

work.
2.  To maintain accurate records of books, students, issued
books, and returned books.
3.  To make searching of books faster and easier using
computerised search options.
4.  To reduce paperwork and store records safely in digital
form.
5.  To minimize human errors in book issue, return, and
record management.
6.  To keep track of due dates and fines efficiently.
7.  To save time for both librarian and students by simplifying
library processes.
8.  To provide a user-friendly interface that is easy to
understand and operate.
9.  To improve overall efficiency and organization of library
management.

6
PROPOSED SYSTEM

The proposed Library Management System is a computer-

based application designed to automate the working of a

library. Instead of maintaining records manually in

registers, the system will store all information digitally in a

database. It will allow the librarian to easily add new

books, update book details, maintain student records, and

manage book issue and return processes efficiently.

The system will provide fast searching of books based on

book ID, title, author, or category. It will also help in

tracking issued books, checking due dates, and

calculating fines, thereby reducing human errors. The

system ensures data accuracy, security, and easy access

to information whenever required. Overall, the proposed

system will make library management more organized,

reliable, and time-saving compared to the manual system.

7
SYSTEM DEVELOPMENT LIFE CYCLE (SDLC)

The System Development Life Cycle is the step-by-step process

followed to develop the Library Management System project. It includes
the following phases:
1. Problem Identification / Planning
In this phase, the problem of the existing manual library system was
identified. The need for a computerized system to manage books,
students, issue and return records was understood. The objectives and
scope of the project were decided.
2. System Analysis
The working of the existing manual library system was studied. The
requirements of the librarian and users were collected, such as storing
book records, issuing books, returning books, searching books, and
maintaining reports. Based on this, the system requirements were
analyzed.
3. System Design
In this phase, the structure of the system was designed. Input screens,
output formats, database tables, and data flow were planned. The user
interface layout and working of each module were designed to make the
system simple and user-friendly.
4. Development / Coding
The system was developed using a suitable programming language and
database. The required modules such as book entry, student entry,
issue, return, and search were coded and linked with the database.
5. Testing
After development, the system was tested to check whether it works
correctly or not. Different test cases were used to find errors and bugs.
Any mistakes found were corrected to ensure the system runs smoothly.
6. Implementation
The system was installed and used as a replacement for the manual
library system. The users were explained how to operate the software
and use its features effectively.
7. Maintenance In this phase, the system is regularly checked and
updated whenever required. Any future improvements or changes can
be made to enhance the performance and features of the system.

8
PICTORIAL REPRESENTATION OF SDLC:
FLOW CHART

◯ START
|
▼
┌─────────────┐
│ LOGIN │
└─────┬───────┘
|
▼
◇ VALID USER?
┌─────┴──────┐
│ │
YES NO
│ │
▼ ▼
┌─────────────┐ ┌────────────┐
│ MAIN MENU │ │ SHOW ERROR │
└─────┬───────┘ └─────┬──────┘
│ │
└────────────────┘
│
▼
┌───────────────────────────┐
│ 1. Add Book │
│ 2. Issue Book │
│ 3. Return Book │
│ 4. Search Book │
└───────────┬───────────────┘
│
▼
┌─────────────┐
│ PROCESS TASK│
└─────┬───────┘
│
▼
┌─────────────┐
│ UPDATE DATA │
└─────┬───────┘
|
▼
◇ EXIT?
┌─────┴──────┐
│ │
NO YES
│ │

◯ STOP
▼ ▼
BACK
TO MENU

9
SOURCE CODE
RUN THIS IN MYSQL:

CREATE DATABASE library;

USE library;

CREATE TABLE books(

book_id INT PRIMARY KEY,

title VARCHAR(50),

author VARCHAR(40),

qty INT

);

CREATE TABLE student(

admn INT PRIMARY KEY,

name VARCHAR(50),

class VARCHAR(10)

);

CREATE TABLE issue(

issue_id INT PRIMARY KEY,

book_id INT,

admn INT,

issue_date DATE,

return_date DATE

);

PYTHON PROGRAM (COPY IN .PY FILE)

import [Link]

10
from datetime import date

con = [Link](

host="localhost",

user="root",

password="your_password",

database="library"

cursor = [Link]()

def addBook():

bid=int(input("Enter Book ID: "))

title=input("Enter Book Title: ")

author=input("Enter Author Name: ")

qty=int(input("Enter Quantity: "))

query="insert into books values(%s,%s,%s,%s)"

data=(bid,title,author,qty)

[Link](query,data)

[Link]()

print("Book Added Successfully")

def viewBooks():

[Link]("select * from books")

rec=[Link]()

print("\nBOOK RECORDS\n")

for i in rec:

11
 print(i)

def addStudent():

admn=int(input("Enter Admission Number: "))

name=input("Enter Student Name: ")

cls=input("Enter Class: ")

query="insert into student values(%s,%s,%s)"

data=(admn,name,cls)

[Link](query,data)

[Link]()

print("Student Added Successfully")

def issueBook():

iid=int(input("Enter Issue ID: "))

bid=int(input("Enter Book ID: "))

admn=int(input("Enter Student Admission No: "))

today=[Link]()

query="insert into issue values(%s,%s,%s,%s,NULL)"

data=(iid,bid,admn,today)

[Link](query,data)

[Link]("update books set qty=qty-1 where book_id=

%s",(bid,))

[Link]()

print("Book Issued Successfully")

12
def returnBook():

iid=int(input("Enter Issue ID: "))

today=[Link]()

query="update issue set return_date=%s where issue_id=%s"

[Link](query,(today,iid))

bid=int(input("Enter Book ID to Update Quantity: "))

[Link]("update books set qty=qty+1 where book_id=

%s",(bid,))

[Link]()

print("Book Returned Successfully")

def searchBook():

bid=int(input("Enter Book ID to Search: "))

[Link]("select * from books where book_id=%s",

(bid,))

rec=[Link]()

if rec:

print("Book Found:",rec)

else:

print("Book Not Found")

def menu():

while True:

print("\n===== LIBRARY MANAGEMENT SYSTEM =====")

print("1. Add Book")

13
 print("2. View Books")

print("3. Add Student")

print("4. Issue Book")

print("5. Return Book")

print("6. Search Book")

print("7. Exit")

ch=int(input("Enter Your Choice: "))

if ch==1:

addBook()

elif ch==2:

viewBooks()

elif ch==3:

addStudent()

elif ch==4:

issueBook()

elif ch==5:

returnBook()

elif ch==6:

searchBook()

elif ch==7:

print("Thank You!")

break

else:

print("Invalid Choice")

menu()

14
OUTPUT

15
Details of Database:
a) Name of Database
used:LIBRARY
b) Name of Tables used:BOOKS
c) Structure of Tables and use
of Tables in the project

Details of Python functions

used in the project:
a) addBook()
b) viewBooks()
c) addStudent()
d) issueBook()
e) returnBook()
f) searchBook()
g) menu()

16
 INSTALLATION PROCEDURE

Library management system :-

-------------------------------------

Pre-Requisites :-
1. You have to have the following softwares for the
successful running of this software; which are

I) Python (Only for the First time), it is

downloadable from '[Link]'.

(python –version)

II) MySQL (Only for the First time), it is

downloadable from '[Link]'.

(CREATE DATABASE library; )

III) MySQL Connector (Only for the First

time), it is downloadable from
'[Link]'.

(pip install mysql-connector-python)

CREATE TABLES
USE library;

17
CREATE TABLE books(
book_id INT PRIMARY KEY,
title VARCHAR(50),
author VARCHAR(40),
qty INT
);

CREATE TABLE student(

admn INT PRIMARY KEY,
name VARCHAR(50),
class VARCHAR(10)
);

CREATE TABLE issue(

issue_id INT PRIMARY KEY,
book_id INT,
admn INT,
issue_date DATE,
return_date DATE
);

18
 CODE COMPLETENESS EVALUATION

The Library Management System program was thoroughly checked and

evaluated to ensure that the source code is complete, functional, and meets all
project requirements. The following points were considered during the code
completeness evaluation:

1. Module Completion
2. Compilation and Execution
3. Functional Verification
4. Database Connectivity
5. Input and Output Handling
6. Error Handling

7. USER INTERFACE

19
 HARDWARE AND SOFTWARE
REQUIREMENTS
 Operating System

 Windows 7 / 8 / 10 / 11
 or Linux
 or macOS

 Programming Language

 Python

 Database Software

 MySQL Database

 Python Modules

 mysql-connector-python

 Editor / IDE

 Python IDLE / VS Code / PyCharm / Any Text Editor

 Other Requirements

 MySQL Workbench or Command Line Client

SOFTWARE REQUIREMENTS:
I. Windows OS
II. Python

20
 BIBLIOGRAPHY

1. Computer science With Python - Class XII By : Sumita Arora

2. Website: [Link]

***

21