A desktop application to help librarians manage book inventory using Python and MySQL.
- Member registration system
- Book lending with due dates
- Active loans tracking
- Instant member search functionality
- Automatic availability updates
- loned book display
- Return processing
- Active loans tracking
- Automatic fine calculation for overdue books
- Fine payment tracking
- Frontend: Tkinter (Python GUI)
- Backend: Python 3.9+
- Database: MySQL
- Architecture: MVC Pattern
-
Prerequisites:
- Python 3.9 or later
- MySQL Server
- XAMPP (recommended for easy MySQL setup)
-
Setup Database:
- Create a MySQL database named
library_management - Run the SQL script from
database/setup_db.sql
- Create a MySQL database named
-
Install Python Dependencies:
pip install -r requirements.txt