Project: DBMS Project
Title: School Library Management System
Subject: Database Management System
(DBMS)
Student’s Name: Raj Gupta
Class: X Roll No: 15
Teacher’s Name: Neha Ma`am
Academic Year: 2025-2026
ACKNOWLEDGEMENT
I would like to express my sincere gratitude to my
Project Coordinator, Ms. Neha Ma’am, for her
invaluable guidance and constant support
throughout the preparation of this practical file. I
am truly thankful for the opportunity to work on
these practical tasks, which have greatly
enhanced my understanding in the subject.
I would also like to thank our Principal and the
school administration for providing the necessary
facilities and resources required to complete this
work successfully. Lastly, I am grateful to my
parents and friends for their encouragement and
help during the completion of this file.
Submitted by:
Name: Raj Gupta
Class: X
Roll No: 15
Date: 06/02/2026
CERTIFICATE
This is to certify that RAJ GUPTA a student of
Class X, Section A, of PEARLS VALLEY
SCHOOL, has successfully completed the DBMS
project titled “School Library Management
System” for the subject- Information Technology
(IT) as per the curriculum requirements for the
academic session 2025-2026.
The work recorded in this file is a bonafide record
of the project performed under the guidance and
supervision of [Link] . This work is found
satisfactory for the partial fulfillment of the
requirements for the examination
Teacher`s Signature: ______________
Date:_________
INDEX
• Introduction
• Objectives of the Project
• Hardware and Software Requirements
• Description of the Project
• Database Design
• Forms and Reports
• Conclusion / Output
• Bibliography
1. Introduction:
Project Name: Library Management System
A library is an essential part of any educational
institution. Managing a school library manually is a
time-consuming process and often leads to errors
such as incorrect book records or misplaced data.
The School Library Management System is a
database-driven application designed to automate and
simplify the process of maintaining library records.
This project uses DBMS concepts such as tables,
primary keys, foreign keys, relationships, and reports
to store and manage data efficiently.
2. Objectives of the Project:
The main objectives of this project are:
• To maintain accurate records of books available in
the library
• To store student information in a systematic
manner
• To track book issuance and return details
• To reduce manual workload and paperwork
• To ensure fast retrieval of information
3. Hardware and Software Requirements
Hardware Requirements:
• Desktop Computer or Laptop minimum 4 GB RAM
• Keyboard and Mouse
Software Requirements:
• Operating System: Windows
• Database Software: Libreoffice base
• Documentation Tool: Libreoffice writer
4. Description of the Project:
The School Library Management System is divided
into three major components:
[Link] Management
[Link] Management
[Link] Management
Each component is stored in a separate table within
the database.
5. Database Design:
5.1 Books Table
This table stores information related to all books
available in the library.
Book table
Attributes:
• Book_ID (Primary Key): Unique identification
number for each book
• Book_Name: Name of the book
• Author: Name of the author
• Category: Subject or genre of the book
• Quantity: Number of copies available
5.2 Students Table
Student table
This table stores details of students who are
registered library members.
Attributes:
• Student_ID (Primary Key): Unique student
identification number
• Student_Name: Name of the student
• Class: Class of the student
• Contact_No: Student’s contact number
5.3 Issues Table
Issue table
This table records details of books issued to students.
Attributes:
• Issue_ID (Primary Key): Unique issue record
number
• Student_ID (Foreign Key): References Students
table
• Book_ID (Foreign Key): References Books table
• Issue_Date: Date when the book was issued
• Return_Date: Expected return date
6. Relationships Between Tables:
• One student can issue multiple books (One-to-
Many relationship)
Relationship between tables
• One book can be issued to multiple students at
different times
• Foreign keys are used to maintain data integrity
7. Forms and Reports:
Forms:
Forms are designed to make data entry simple and
user-friendly.
• Book Entry Form
• Student Entry Form
• Book Issue Form
Reports:
Reports help summarize and analyze stored data.
• List of all issued books
• Student-wise book issue report
• Available books report
8. Conclusion / Output:
The School Library Management System
successfully automates the library record-keeping
process.
It reduces human errors, saves time, and ensures
efficient data management.
This project helped in understanding real-world
applications of DBMS concepts such as normalization,
relationships, and reporting.
9. Bibliography / Refrences:
• Database Management System Textbook
• Teacher’s Class Notes
• DBMS Research papers
• [Link]
• [Link]