📚 Library Management System
Automating library operations using Python & Database Management
🔹 Author: Zaheer Shaik
AI & Software Engineer | Focused on Building Scalable and Smart Systems
🧾 Overview
The Library Management System is a simple yet powerful desktop-based application designed to digitize the library workflow — from managing book inventory to tracking users, borrowing, and returns.
This project demonstrates the application of Object-Oriented Programming, Database Management, and GUI Development in Python to create a real-world software solution for educational institutions.
🚀 Features
✅ Add, Update, Delete books and members ✅ Search books by title, author, or ID ✅ Issue and return book management ✅ Display overdue books with fine tracking ✅ Simple and user-friendly interface ✅ Secure database integration
🧠 Tech Stack
Programming Language: Python 3.x
GUI Library: Tkinter
Database: MySQL / SQLite
Other Libraries: os, datetime, tkinter.messagebox
📂 Project Structure library-management-system/ │ ├── main.py # Main GUI file ├── database.py # Handles DB connectivity and operations ├── add_book.py # Script to add new books ├── issue_book.py # Script for issuing books ├── return_book.py # Script for returning books ├── view_books.py # View and search functionality ├── README.md # Project documentation └── library-management-system-master.zip # Compressed backup
⚙️ Installation & Setup 1️⃣ Clone this Repository git clone https://github.com/ShaikZaheer-developer/library-management-system.git cd library-management-system
2️⃣ Install Dependencies pip install mysql-connector-python
3️⃣ Configure the Database
Create a MySQL database (e.g., librarydb)
Update your connection credentials in database.py
Run the script to initialize tables
4️⃣ Run the Application python main.py
📘 How It Works
Admin Login: Access control to prevent unauthorized usage.
Book Management: Add, edit, delete, and view book details.
Member Management: Manage students or users who borrow books.
Transaction Logs: Track all issued and returned books.
Reporting: Easily view current stock and borrowed book lists.
🧩 Future Enhancements
🔹 Integrate with AI-based book recommendation system 🔹 Add cloud-based backup and synchronization 🔹 Role-based access for librarians and users 🔹 Convert into a full-stack web application with Flask/Django
🧑💻 About the Developer
👋 I’m Zaheer Shaik, a passionate AI & Data Science Engineer who enjoys turning code into meaningful products. I focus on creating intelligent, efficient, and user-friendly systems that solve real problems.
⭐ Support
If you found this project useful, please star this repo ⭐ — it inspires me to build more real-world tech projects!