Smart Library Management System

Library management with QR member cards and book labels, scan-ready counter, renewals, reservations queue, fines, reminders and smart insights. Python, Tkinter, SQLite.

  • Price: ₹1,499
  • Category: Desktop App
  • Technology: Python, Tkinter, SQLite, Matplotlib, QR codes (segno)
  • Includes: Source code + database
  • Suitable for: BCA / B.Sc CS, MCA / M.Sc CS, B.E / B.Tech CSE & IT

Project overview

A modern library desk needs more than an issue register. This desktop application keeps the catalogue (code, title, author, category, shelf, price, copies) and the members (Student or Staff, department, phone) with search and filters. Each member and book has a QR code: the member card can be printed from the browser and the counter accepts a scanned or typed code. At the Counter the system checks the member's limit (3 books for students, 6 for staff), overdue books, unpaid fines of Rs. 50 or more, duplicate titles and copies held for reservations, then sets the due date (14 or 30 days). Loans can be renewed twice for 7 more days unless someone is waiting. Books that are out can be reserved; a returned copy is held for the first member for 3 days and then passed on automatically. Late returns create a fine of Rs. 2 per day (never more than the book price) that can be collected or waived with a reason. The Alerts screen lists due-soon and overdue reminders with a message to copy into WhatsApp or SMS and an activity log of every action, and Insights shows trending books, 'readers also borrowed', reorder suggestions and loans by weekday. 28 logic tests with hand-worked dates and 73 screen checks are included.

Modules

  1. Login: Admin login with a salted password hash; change the password from the side menu.
  2. Dashboard: Titles, copies, members, on loan, overdue, unpaid fines, reservations and today's loans; issue/return chart and loans by category.
  3. Books: Add, edit, delete books with validation; search by title, author or code; category filter; QR label for each book.
  4. Members: Students and staff with department and phone checks; loan history; QR member card (PNG) and a printable card for the browser.
  5. Counter: Scan or type a code; issue with all rules; return with automatic fine; renew up to two times.
  6. Reservations: Reserve a book that is out; waiting queue with places; a returned copy is held 3 days for the first member, then passed on.
  7. Fines: Unpaid, paid and waived fines; collect, or waive with a reason; CSV export.
  8. Alerts: Due-soon and overdue reminders with a ready message, copy / mark as sent / CSV; activity (audit) log of every action.
  9. Insights: Trending books, 'readers who borrowed this also borrowed', reorder suggestions with CSV, loans by weekday.

Requirements

  • Python 3.11
  • Internet once, to install the libraries (about 2 minutes)
  • Windows 10 / 11

How to run this project

  1. Install Python 3.11 from python.org and tick "Add python.exe to PATH" during setup.
  2. Extract the zip and open the project folder (STUDENT_GUIDE.md explains every step in simple words).
  3. Double-click `1_INSTALL.bat` once and wait until it says [OK] (about 2 minutes; it downloads the libraries into a private .venv folder).
  4. Double-click `2_RUN.bat` to start the project. If it does not start, double-click `CHECK_SETUP.bat` and read what it says.
  5. Log in with admin / admin123.
  6. Open Reservations, then return 'A Lantern for Marigold' at the Counter: the copy is held for Demo Student 17. Open Fines (collect / waive with a reason), Alerts (copy a reminder, see the activity log) and Insights (trending, also borrowed, buy more).

More Desktop App projects