Scribd
Upload
15 views12 pages

DBMS Library Management System Project

The Library Management System is a DBMS-based project aimed at improving library operations by digitalizing book tracking and management. It addresses issues like inefficiency and human error in manual systems, offering features such as student registration, book cataloging, and overdue tracking. Future enhancements include barcode scanning, reminders, and mobile app integration.

Uploaded by

poorvikagouda15
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
15 views12 pages

DBMS Library Management System Project

The Library Management System is a DBMS-based project aimed at improving library operations by digitalizing book tracking and management. It addresses issues like inefficiency and human error in manual systems, offering features such as student registration, book cataloging, and overdue tracking. Future enhancements include barcode scanning, reminders, and mobile app integration.

Uploaded by

poorvikagouda15
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

DBMS Mini Project

Library Management System


Introduction
• Title: Library Management System
• Objective: Create a DBMS-based system to
manage library operations.
• Tools Used: MySQL, PHP/Python, HTML/CSS
(optional UI)
• Project Type: Academic Mini Project
Problem Statement
• Manual systems are inefficient and prone to
human error.
• Tracking issued and returned books is difficult.
• No real-time status of books
(available/issued).
• Overdue and defaulter tracking is
cumbersome.
Proposed System
• Digital tracking of books and members.
• Book issuing, returning, and availability check.
• Defaulter tracking and fine calculation.
• Admin panel for managing books and users.
ER Diagram
• The system includes the following entities:
• - Students
• - Books
• - Authors
• - IssuedBooks
• - Librarian
• Relationships can be illustrated in an ER
diagram.
Database Schema - Students &
Books
• Students(StudentID, Name, Department,
Email, Phone)
• Books(BookID, Title, AuthorID, Publisher, Year,
Quantity)
Database Schema - Authors &
IssuedBooks
• Authors(AuthorID, Name)
• IssuedBooks(IssueID, BookID, StudentID,
IssueDate, DueDate, ReturnDate)
Database Schema - Librarian
• Librarian(LibrarianID, Name, Username,
Password)
Sample Queries
• 1. List all books:
• SELECT * FROM Books;

• 2. Find overdue books:


• SELECT * FROM IssuedBooks WHERE DueDate
< CURDATE() AND ReturnDate IS NULL;

• 3. Check available books:


• SELECT * FROM Books WHERE Quantity > 0;
Features Implemented
• - Student registration
• - Book catalog and search
• - Issue and return functionality
• - Fine calculation for late returns
• - Librarian login and dashboard
Conclusion
• - Efficient and reliable library management
system.
• - Reduces manual work and human error.
• - Improves tracking and reporting of books.
• - Can be further extended to support web or
mobile interfaces.
Future Enhancements
• - Barcode or QR scanning for books.
• - Email/SMS reminders for due dates.
• - Mobile app integration.
• - Analytics and usage reports.

You might also like