[go: up one dir, main page]
Scribd
Upload
22 views13 pages

Library Management System

Uploaded by

priyanshukumar776603
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views13 pages

Library Management System

Uploaded by

priyanshukumar776603
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 13

RPVV,B-1,VASANT

KUNJ

COMPUTER
2024-2025

SCIENCE
PROJECT
“Library
MANAGEMENT
SYSTEM”

Name : Priyanshu Kumar


Class : XII A
Roll No. : 12102

1
CERTIFICATE
This is to certify that Priyanshu Kumar of Class XII-A has
successfully completed the Computer Science project titled
“Library Management System” under my supervision during
the academic session 2024-25.
This project is submitted in partial fulfillment of the
requirements for the All India Senior School Certificate
Examination (AISSCE) conducted by the Central Board of
Secondary Education (CBSE), New Delhi.
The project is a commendable demonstration of technical skills,
creativity, and hard work.

Mr. Praveen Yadav


TGT Computer science
RPVV
Date:
[29 DEC 2024

2
ACKNOWLEDGEMENT
We would like to express our sincere gratitude to Mrs. Praveen
Kumari, Principal, RPVV, for providing us with an
opportunity to work on this project and for his constant
encouragement.
We are deeply indebted to our mentor, Mr. Praveen Yadav, for
his invaluable guidance and support throughout the completion
of this project.
We further extend our heartfelt thanks to all the staff members
of RPVV, whose cooperation made this project possible.
We owe our sincere gratitude towards the Directorate of
Education, Delhi, for their continuous support and motivation.
Our heartfelt thanks to CBSE for inspiring excellence and setting
the benchmark for education.
We also express our deepest gratitude to our parents for their
unwavering support and encouragement during this journey.
Finally, we would like to wind up by paying our heartfelt thanks
to all our near and dear ones, whose belief in us helped make this
project a reality.

3
INTRODUCTION
LIBRARY MANAGEMENT SYSTEM

The Library Management System is a Python-based project designed to


streamline the management of students and books in a library. The project uses
Python as the programming language and MySQL as the database management
system, with the help of the mysql.connector library to interact with the
database.

Introduction to the Elements Used:


Python
Python is a high-level, versatile programming language known for its simplicity
and readability. It is used in this project for implementing the system's logic,
taking user inputs, and performing database operations.

MySQL
MySQL is a relational database management system used to store and manage
data in a structured format. It supports querying, updating, and managing
data efficiently.
In this project, it stores information about:
Students
Books
Book issuance and return transactions

MySQL Connector Library

The mysql.connector Python library is used to establish a connection between


Python and the MySQL database. It allows the program to execute SQL
commands directly from Python.

4
Database Tables
The system relies on three database tables:
Students: Stores details about students such as ID, name, and course.
Books: Stores information about books such as ID, title, author, and ISBN.
Transactions: Keeps track of books issued and returned, along with dates

SQL Queries
SQL (Structured Query Language) is used to interact with the database.
Examples include creating tables, inserting data, and retrieving records.

Features of the Code


Clear menu-driven interface for user interaction.
SQL-based database integration ensures data integrity and persistence.
Well-structured code with comments for easy understanding.

Features of the Library Management System


Add Students
Allows the librarian to add student details like ID, name, and course to the
database.
Add Books
Enables the librarian to add new books with details such as ID, title, author,
and ISBN.
Issue Books
Records when a student borrows a book, storing the student ID, book ID, and
the issue date.
Return Books
Updates the system when a student returns a book, recording the return date
and marking the book as returned.

5
View Students
Displays a list of all students currently registered in the system.
View Books
Shows all books available in the library.
Data Persistence
All data is stored securely in a MySQL database, ensuring it remains intact even
after the program is closed.
Error Handling
Includes basic error handling for invalid inputs and database-related issues.

Minimum System Requirements

1. Hardware Requirements
Processor: Intel Core i3 or equivalent
RAM: 2 GB
Hard Disk: 500 MB free space
2. Software Requirements
Operating System: Windows 10/11, macOS, or any Linux distribution
Python (version 3.7 or higher)
MySQL Server (version 5.7 or higher)
MySQL Connector Python library (pip install mysql-connector-python)
3. Additional Tools
Text Editor/IDE: PyCharm, Visual Studio Code, or any Python-compatible
editor.
MySQL Workbench or any MySQL client (optional, for database
inspection).

6
CODE:

7
9
INPUT & OUTPUT

10
11
12
Computer Science with Python – Class XII By : Sumita Arora

YOUTUBE :- https://youtube.com/playlist?list=PLtXHXicnhSe5f-
tkxuUsSlvUcwT7Bx_qu&si=P5XM_zz4JITUt51p

"MySQL Tutorial." TutorialsPoint,


https://www.tutorialspoint.com/mysql/index.html

"Introduction to Python." GeeksforGeeks,


https://www.geeksforgeeks.org/python-programming-
language/

13

You might also like