A robust library management system designed to streamline the borrowing and returning of books, manage member and admin accounts, and maintain accurate records of books and loans. Built using Java for the frontend and SQL Server as the backend, this project is perfect for managing libraries of varying sizes.
- Book Borrowing: Borrow books using just the title and your member ID.
- Book Returning: Return books with automatic fine calculation for overdue returns.
- Manage Books: Add, update, or remove books from the system.
- Manage Members: Register new members and view their borrowing history.
- Overdue Tracking: Identify overdue books and fines for efficient management.
- Audit Trail: Track all borrowing and returning activities.
- Dynamic Fine Calculation: Automatically calculates fines for overdue returns based on days late.
- Role-Based System: Separate interfaces and functionalities for members and admins.
- Search and Filter: Easily search for books by title, category, or author.
- Frontend: Java Swing
- Backend: SQL Server 2022
- Database Connection: JDBC (Java Database Connectivity)
- Development Environment: NetBeans IDE
- Members: Stores member information, linked to
AdminsthroughManagerID. - Admins: Stores administrator credentials and details.
- Books: Stores information about books, including title, author, category, and availability.
- Loans: Tracks book loans, including issue date, due date, return date, and fines.
- Admins to Members: One-to-many relationship, where each member is assigned to a manager (admin).
- Books to Loans: One-to-many relationship, as a book can have multiple loans.
- Members to Loans: One-to-many relationship, as a member can borrow multiple books.
- Clone the Repository:
git clone https://github.com/yourusername/library-management-system.git