Cover Page
LIBRARY MANAGEMENT SYSTEM
CBSE Class 12 Computer Science Project
Certificate
This is to certify that this project titled 'Library Management System' has been completed in
accordance with CBSE guidelines.
Acknowledgement
I sincerely thank my Computer Science teacher, my school, and my parents for their guidance and
support.
Index
1. Introduction
2. Objectives
3. Requirements
4. Flowchart
5-14. Python Code
15. SQL
16. Outputs
17. Advantages
18. Limitations
19. Conclusion
20. Bibliography
Introduction
A Library Management System is a software application used to manage books, members,
issue/return records and searches efficiently.
Objectives
• Maintain book records
• Issue/Return books
• Search books
• Store records in MySQL
Requirements
Hardware: PC
Software: Python 3.x, MySQL, mysql-connector-python
Flowchart
Start → Menu → Add/Search/Issue/Return → Update Database → Exit
Python Code Part 1
def menu():
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link]")
# Additional functions: add_book(), search_book(), issue_book(),
return_book(), display_books()
Python Code Part 2
def menu():
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link]")
# Additional functions: add_book(), search_book(), issue_book(),
return_book(), display_books()
Python Code Part 3
def menu():
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link]")
# Additional functions: add_book(), search_book(), issue_book(),
return_book(), display_books()
Python Code Part 4
def menu():
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link]")
# Additional functions: add_book(), search_book(), issue_book(),
return_book(), display_books()
Python Code Part 5
def menu():
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link]")
# Additional functions: add_book(), search_book(), issue_book(),
return_book(), display_books()
Python Code Part 6
def menu():
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link]")
# Additional functions: add_book(), search_book(), issue_book(),
return_book(), display_books()
Python Code Part 7
def menu():
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link]")
# Additional functions: add_book(), search_book(), issue_book(),
return_book(), display_books()
Python Code Part 8
def menu():
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link]")
# Additional functions: add_book(), search_book(), issue_book(),
return_book(), display_books()
Python Code Part 9
def menu():
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link] Book")
print("[Link]")
# Additional functions: add_book(), search_book(), issue_book(),
return_book(), display_books()
MySQL Database
CREATE DATABASE library;
CREATE TABLE books(book_id INT PRIMARY KEY,title VARCHAR(100),author
VARCHAR(100),status VARCHAR(20));
Sample Outputs
Menu, Add Book, Search Book, Issue Book and Return Book screens.
Advantages
Easy record keeping, fast searching, reduced paperwork.
Limitations
Requires computer and database setup.
Conclusion
The project demonstrates Python and MySQL integration for library automation.
Bibliography
NCERT Computer Science Class XII, Python Documentation, MySQL Documentation.