Shemrock Senior Secondary School
SESSION 2025–2026
PROJECT TITLE SCHOOL MANAGEMENT SYSTEM
SUBMITTED BY Navdeep Singh Sidhu
CLASS X
ROLL NO. 19
SUBJECT Information Technology (402)
SUBMITTED TO Mrs. Harleen Kaur
INTRODUCTION TO THE TOPIC
A School Management System is a digital platform used to manage school operations such as student
records, attendance, fees, and communication. It helps reduce paperwork and improves efficiency and
accuracy in school administration.
OBJECTIVE OF THE TOPIC
1 To automate administrative work
2 To maintain accurate student records
3 To reduce paperwork
4 To improve communication
5 To save time and resources
STEPS IN CREATING PROJECT
1 Creating a Database
2 Creating Tables
3 Inserting Data in Tables
4 Creating Relationships
5 Creating Forms
6 Generating Reports
MAIN COMPONENTS OF SCHOOL MANAGEMENT SYSTEM
Student Table Student ID, Class, Section, Roll No, DOB, Phone No
Fee Table Fee ID, Student ID, Date, Status
Attendance Table Attendance ID, Student ID, Date, Status
CONCLUSION
The School Management System helps schools manage their daily activities efficiently. It improves
accuracy, reduces manual work, and enhances communication. This project shows the importance of
Information Technology in modern education.
CASE STUDY DOCUMENTATION
Library Management System
Developed using LibreOffice Base
Date: 16-01-2026
1. Introduction
The Library Management System is a database application developed using LibreOffice Base to
automate and manage the routine operations of a library. Libraries play an important role in
educational institutions, and maintaining records manually can be time-consuming and error-prone.
This system is designed to store, organize, and retrieve library information efficiently using a
computerized database.
The application manages details related to books, library members, and book issue and return
transactions. It uses tables for data storage, forms for data entry, and reports for presenting output
in a structured manner. This case study documentation is prepared for submission to the library and
provides a brief overview of the system.
2. Objectives of the System
The main objectives of the Library Management System are:
• To maintain accurate and up-to-date records of books and members
• To reduce manual work and paperwork
• To improve efficiency in issuing and returning books
• To ensure proper organization of library data
• To generate reports with title and date for reference
3. System Description
The Library Management System is developed using LibreOffice Base. The database consists of
multiple tables created using Design View, where field names, data types, and keys are defined.
Relationships are established between tables to maintain data consistency.
Data entry is performed using forms, which provide a user-friendly interface and prevent direct
manipulation of tables. Output is generated using reports, which display information such as book
lists and issued book details in a printable format with proper titles and dates.
4. Scope of the System
The scope of this system is limited to basic library operations such as:
• Managing book details
• Maintaining member information
• Recording issue and return of books
• Generating simple reports
This system is suitable for small libraries, schools, and colleges where simple and efficient record
management is required.
5. Conclusion
The Library Management System developed using LibreOffice Base provides a simple, reliable, and
efficient solution for managing library records. By using tables, forms, and reports, the system
ensures proper data organization and easy access to information. This case study highlights the
importance of database applications in improving the efficiency of library management.
LIBRARY MANAGEMENT SYSTEM
Practical Project using LibreOffice Base
Date: 16-01-2026
INTRODUCTION
This project titled Library Management System is developed using LibreOffice Base. The
database manages book details, member information, and issue/return records using tables, forms,
and reports.
TABLE CREATION (DESIGN VIEW)
All tables are created using the Design View option in LibreOffice Base. Field names, data types,
primary keys, and relationships are defined manually.
Table 1: Books
Field Name Data Type Description
Book_ID Integer Primary Key
Book_Title Text (100) Title of the Book
Author Text (100) Author Name
Publisher Text (100) Publisher Name
Price Currency Book Price
Quantity Integer Number of Copies
Table 2: Members
Field Name Data Type Description
Member_ID Integer Primary Key
Member_Name Text (100) Member Name
Address Text (150) Address
Phone Text (15) Contact Number
Membership_Date Date Date of Joining
Table 3: Issue_Details
Field Name Data Type Description
Issue_ID Integer Primary Key
Book_ID Integer Foreign Key
Member_ID Integer Foreign Key
Issue_Date Date Date of Issue
Return_Date Date Date of Return
FORMS CREATION (DATA ENTRY)
Forms are created using the Form Wizard in LibreOffice Base. Forms provide an easy interface for
entering data into the tables. Direct table entry is not used.
Form 1: Book Form
The Book Form is based on the Books table. It allows the user to add, modify, and delete book
records.
Form 2: Member Form
The Member Form is created using the Members table. It is used to register new library members
and update member details.
Form 3: Issue Form
The Issue Form is based on the Issue_Details table. It is used to record the issue and return of
books.
REPORT GENERATION (OUTPUT)
Reports are generated using the Report Wizard in LibreOffice Base. Reports display the data in a
printable format and include a title and date.
Report 1: Library Book List Report
This report displays the list of all books available in the library along with author names and
quantity.
Report 2: Issued Books Report
This report shows the details of books issued to members including issue date and return date.
CONCLUSION
The Library Management System project successfully demonstrates the use of tables, forms, and
reports in LibreOffice Base. It provides a practical approach to database management.
STEPS PERFORMED IN LIBREOFFICE BASE
PROJECT
Steps to Create Tables (Design View):
1. LibreOffice Base was opened and a new database was created.
2. Option 'Create Table in Design View' was selected.
3. Fields such as Book ID, Book Name, Author, Publisher, Member ID and Issue Date were defined.
4. Appropriate data types were selected for each field.
5. Primary key was set for each table and tables were saved.
Steps to Create Forms:
1. Required tables were selected one by one.
2. 'Use Wizard to Create Form' option was used.
3. Fields were added to the form for data entry.
4. Suitable layout and style were selected.
5. Forms such as Book Form, Member Form and Issue Form were saved and used for data entry.
Steps to Create Reports:
1. Required table or query was selected.
2. 'Use Wizard to Create Report' option was chosen.
3. Required fields were selected for display.
4. Report title and date were added.
5. Reports such as Book List Report and Issued Books Report were generated.