CLASS 12 COMPUTER SCIENCE PROJECT
Library Management System Using Python & MySQL
Name: ____________
Class: XII
School: ____________
Certificate
This is to certify that ____________ of Class XII has successfully completed the Computer Science
project titled 'Library Management System Using Python and MySQL' during the academic year
2025–26 under the guidance of the Computer Science teacher.
Acknowledgement
I express my sincere gratitude to my Computer Science teacher for guiding me throughout this
project. I also thank my parents and friends for their support.
Introduction
A Library Management System is software used to manage books in a library. It helps to add books,
issue books, return books, and view records. This project connects Python with MySQL database to
store data permanently.
Objectives
1 To learn Python with database
2 To manage library records digitally
3 To reduce manual work
4 To understand real-life applications
Software & Hardware Requirements
Software
Python 3.x, MySQL, VS Code/IDLE
Hardware
Computer/Laptop with minimum 4GB RAM
Python Overview
Python is a high-level programming language. It is easy to learn and widely used in web
development, AI, and data science. It has simple syntax and is open-source.
MySQL Overview
MySQL is a database system used to store and retrieve data efficiently. It helps keep data safe and
organized.
Problem Definition
Managing library records manually is difficult and time-consuming. There is risk of data loss and
difficulty in tracking books. This system solves these issues.
Algorithm
1 Start
2 Connect to database
3 Show menu
4 Perform user choice
5 Stop
Program Code
import [Link] db = [Link]( host="localhost", user="root",
password="1234", database="library" ) cursor = [Link]()
Advantages
1 Saves time
2 Secure data
3 Easy management
4 User-friendly
Conclusion
This project helped in learning Python programming and database connectivity. It shows real-life
application development.
Bibliography
Computer Science Textbook, Teacher Notes, Python Documentation