Scribd
Upload
5 views15 pages

Library_Management DBMS project

The document presents a Library Management System (LMS) that efficiently manages cataloging, user information, and transactions using SQL implementation. Key features include catalog management, user authentication, and fines tracking, while emphasizing the importance of data organization and integrity in database management. The SQL implementation involves creating tables for books, members, and transactions, utilizing views and joins to enhance data retrieval and management.

Uploaded by

amanpatel042004
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
5 views15 pages

Library_Management DBMS project

The document presents a Library Management System (LMS) that efficiently manages cataloging, user information, and transactions using SQL implementation. Key features include catalog management, user authentication, and fines tracking, while emphasizing the importance of data organization and integrity in database management. The SQL implementation involves creating tables for books, members, and transactions, utilizing views and joins to enhance data retrieval and management.

Uploaded by

amanpatel042004
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
You are on page 1/ 15

Library Management System

Conceptual Overview & SQL Implementation

Presented by: Aman Patel ,Ajay Chauhan,


Sarthak Yadav
UID’s: 23BCS11665, 23BCS13759,
23BCS11640
Date: 18 April 2025
Submitted To: Dr. Navjot Kaur
Introduction
• A Library Management System (LMS)
manages cataloging, user
information, check-in/check-out, and
inventory.
• This presentation covers the
importance of LMS in database
management and demonstrates its
SQL-based implementation
Importance in DBMS
• Organizes and retrieves large data
efficiently
• Ensures data reliability and integrity
• Enables analytics for decision-making
• Improves library operations and user
engagement
Key Features
• Catalog management
• User authentication
• Book check-in/check-out
• Fines tracking
• Report generation
• Integration with digital resources
SQL Implementation Overview
• Using MySQL, we create tables for:
• - Books
• - Members
• - Transactions
• - Fines

• We also use views to track current borrowings.


Key SQL Concepts Used
• Data Definition Language (DDL): CREATE
TABLE, DROP TABLE IF EXISTS
• Primary Key: Uniquely identifies each
record (e.g., ISBN in Books)
• Foreign Key: Establishes relationships
between tables (e.g., MemberID in
Transactions refers to Members)
• Data Integrity Constraints: NOT NULL,
UNIQUE, DEFAULT values
Database Normalization
• Organizes data to reduce redundancy
and dependency
• Each table stores data related to a
single entity
• Foreign keys establish relationships
between tables
SQL Implementation Overview
• Tables Created:
• Books
• Members
• Transactions
• Fines
• Views: Used to track current
borrowings (e.g.,
ActiveBorrowedBooks)
Table Structures
• Books Table: ISBN, Title, Author,
RentalPrice, IsAvailable
• Members Table: MemberID, Name,
Email, Phone, JoinDate
• Transactions Table: Links to Books and
Members, IssueDate, DueDate,
ReturnDate, Status
• Fines Table: Tracks fines per
transaction, fine status (Paid/Not Paid)
Data Modification & Transactions

• INSERT INTO: Adds new records to


tables
• UPDATE/DELETE: Modify or delete
records (not shown in this example)
• Transaction Table: Records book
issue/return events
• Fines Table: Manages fines for
overdue books
Views & Joins
• Views: Virtual tables presenting data
from one or more tables (e.g.,
ActiveBorrowedBooks)
• Joins: Combine data from multiple
tables based on common keys, used
in views to link Transactions, Books,
and Members
Date Functions
• CURRENT_DATE: Returns the current
date (used for JoinDate, IssueDate,
DueDate)
• DATE_ADD: Adds a time interval to a
date (used for setting due dates)
Sample SQL Queries
• INSERT INTO Books (...)
• INSERT INTO Members (...)
• SELECT * FROM Books;
• SELECT * FROM
ActiveBorrowedBooks;
Conclusion
• The SQL-based Library Management
System demonstrates the use of key
database concepts: DDL, normalization,
primary/foreign keys, data integrity,
joins, views, and transactions.
• MySQL ensures structured, efficient,
and scalable data management, ready
for future upgrades (UI, analytics, ML)

You might also like