KENDRIYA VIDYALAYA _____

SESSION: 2025–26

COMPUTER SCIENCE PROJECT

LIBRARY MANAGEMENT SYSTEM

Submitted By:

Name: ____
Class & Section: XII
Roll No.: __

Submitted To:

PGT (Computer Science)

\f

CERTIFICATE
This is to certify that ________, Roll No. _____, of Class XII _____ of Kendriya Vidyalaya ____ has successfully
completed the Computer Science Project titled "Library Management System" under my guidance during
the academic session 2025–26, in partial fulfillment of the CBSE Computer Science Practical Examination.

Teacher’s Signature: ___

Date: _____
School Seal

\f

ACKNOWLEDGEMENT
I would like to express my sincere gratitude to my Computer Science teacher for her/his valuable guidance,
encouragement, and continuous support throughout the completion of this project. I am also thankful to
our respected Principal and school for providing the necessary facilities. Finally, I thank my parents and
friends for their cooperation and motivation.

\f

1
INDEX
1. Introduction
2. Objectives of the Project
3. Software and Hardware Requirements
4. Description of the System
5. MySQL Database Tables
6. Source Code (Python with MySQL)
7. Sample Output
8. Advantages
9. Limitations
10. Future Scope
11. Bibliography
12. Thank You

\f

1. INTRODUCTION
The Library Management System is a simple computer-based application designed to manage library
activities efficiently. It helps in maintaining book records, issuing books to students, and returning books
without manual paperwork. This system saves time, reduces errors, and improves accuracy.

The project is developed using Python as the programming language and MySQL as the database.

\f

2. OBJECTIVES OF THE PROJECT

• To computerize library operations
• To maintain book records systematically
• To reduce manual work and paperwork
• To provide fast and accurate data access
• To improve efficiency of library management

\f

3. SOFTWARE AND HARDWARE REQUIREMENTS

Software Requirements
• Operating System: Windows 10 / 11
• Programming Language: Python 3
• Database: MySQL

2
 • IDE: Python IDLE / VS Code

Hardware Requirements
• Processor: Dual Core or higher
• RAM: Minimum 2 GB
• Hard Disk: 40 GB or more

\f

4. DESCRIPTION OF THE SYSTEM

The Library Management System allows the librarian to perform the following operations: - Add new books
to the library - Display all available books - Issue books to students - Return issued books

All data is stored securely in a MySQL database, making the system reliable and efficient.

\f

5. MYSQL DATABASE TABLES

Database Name: library_db

Table 1: BOOKS

Field Name Data Type Description

book_id INT Unique Book ID

title VARCHAR(50) Book Title

author VARCHAR(50) Author Name

publisher VARCHAR(50) Publisher Name

quantity INT Number of Copies

Table 2: ISSUE

Field Name Data Type Description

book_id INT Issued Book ID

student_name VARCHAR(50) Student Name

issue_date VARCHAR(20) Date of Issue

\f

3
6. SOURCE CODE (PYTHON WITH MYSQL)

import [Link]

con = [Link](
host='localhost',
user='root',
password='admin123',
database='library_db'
)

def add_book():
bid = int(input("Book ID: "))
title = input("Title: ")
author = input("Author: ")
publisher = input("Publisher: ")
qty = int(input("Quantity: "))

cur = [Link]()
[Link]("INSERT INTO books VALUES (%s,%s,%s,%s,%s)", (bid, title,
author, publisher, qty))
[Link]()
print("Book added successfully")

def display_books():
cur = [Link]()
[Link]("SELECT * FROM books")
for row in [Link]():
print(row)

def issue_book():
bid = int(input("Book ID: "))
name = input("Student Name: ")
date = input("Issue Date: ")

cur = [Link]()
[Link]("INSERT INTO issue VALUES (%s,%s,%s)", (bid, name, date))
[Link]("UPDATE books SET quantity = quantity - 1 WHERE book_id=%s",
(bid,))
[Link]()
print("Book issued successfully")

def return_book():
bid = int(input("Book ID: "))
cur = [Link]()
[Link]("DELETE FROM issue WHERE book_id=%s", (bid,))

4
 [Link]("UPDATE books SET quantity = quantity + 1 WHERE book_id=%s",
(bid,))
[Link]()
print("Book returned successfully")

def main():
while True:
print("\nLIBRARY MANAGEMENT SYSTEM")
print("1. Add Book")
print("2. Display Books")
print("3. Issue Book")
print("4. Return Book")
print("5. Exit")

ch = int(input("Enter choice: "))

if ch == 1:
add_book()
elif ch == 2:
display_books()
elif ch == 3:
issue_book()
elif ch == 4:
return_book()
elif ch == 5:
break
else:
print("Invalid choice")

main()

\f

7. SAMPLE OUTPUT
Adding a Book

Book ID: 101

Title: Python Basics
Author: Guido van Rossum
Publisher: Pearson
Quantity: 5
Book added successfully

Displaying Books

(101, 'Python Basics', 'Guido van Rossum', 'Pearson', 5)

5
Issuing a Book

Book ID: 101

Student Name: Rahul Sharma
Issue Date: 10-01-2026
Book issued successfully

Returning a Book

Book ID: 101

Book returned successfully

\f

8. ADVANTAGES
• Reduces paperwork and manual effort
• Saves time for librarian and students
• Easy and fast data retrieval
• Maintains accurate book records
• Improves efficiency of library management

\f

9. LIMITATIONS
• No graphical user interface
• Limited security features
• Works for single user only
• Internet-based access is not available

\f

10. FUTURE SCOPE

• GUI can be developed using Tkinter
• Login system for librarian and students
• Online book reservation system
• Barcode-based book issuing
• Cloud database integration

\f

6
11. BIBLIOGRAPHY
• Computer Science with Python – Sumita Arora
• [Link]
• [Link]
• MySQL Documentation

\f

THANK YOU
Thank you for giving me the opportunity to work on this project.

This project helped me understand Python programming, MySQL database handling, and real-life
application development.

END OF PROJECT