📚 University Library Management System
A Desktop Application built with VB.NET
📌 Project Overview
The University Library Management System (ULMS) is a desktop-based application developed using VB.NET (Windows Forms) to automate and manage library operations efficiently.
The system allows administrators, librarians, and students to manage books, users, borrowing transactions, and reports in a structured and secure way.
🎯 Objectives
Digitize manual library operations
Improve book tracking and availability management
Reduce errors in borrowing and returning processes
Provide role-based access control
Generate accurate reports
🛠️ Technologies Used
Frontend: VB.NET (Windows Forms)
Backend: SQL Server / MySQL
IDE: Visual Studio
Version Control: Git & GitHub
👥 User Roles & Functionalities 1️⃣ Admin
Add, update, delete users
Assign roles (Admin, Librarian, Student)
Add, update, delete books
Issue and return books
View and generate reports
Backup and maintain system
2️⃣ Librarian
Manage books (Add, Edit, Delete)
Issue books to students
Process book returns
Calculate overdue fines
Generate reports
3️⃣ Student / Faculty
Search books
View book availability
View borrowed books
View due dates and fines
📦 Core Features
🔐 Secure Login System
📖 Book Management (CRUD)
👤 User Management
🔄 Borrow & Return Module
💰 Fine Calculation
📊 Reporting System
🗂 Role-Based Access Control
🗄 Database Structure Users Table
UserID (Primary Key)
Name
Username
Password
Role
Status
Books Table
BookID (Primary Key)
Title
Author
ISBN
Publisher
TotalCopies
AvailableCopies
BorrowedBooks Table
TransactionID (Primary Key)
UserID (Foreign Key)
BookID (Foreign Key)
BorrowDate
DueDate
ReturnDate
Fine
🚀 Installation Guide
Clone the repository:
git clone https://github.com/jiregnaworku/Library-Management.git
Open the project in Visual Studio
Configure the database connection string
Run the application
🔐 Security Considerations
Password authentication system
Role-based authorization
Input validation to prevent SQL injection
Restricted access based on user type
📈 Future Improvements
Barcode scanning integration
Email notifications for overdue books
Online access for students
Advanced analytics dashboard
📄 License
This project is developed for educational purposes.
👨💻 Author
Jiregna Worku VB.NET Developer GitHub: https://github.com/jiregnaworku