SHRI GULAB RAI MONTESSORI SR.
SECONDARY SCHOOL
INFORMATION TECHNOLOGY PROJECT FILE (Inventory Control Management)
CLASS –X
Student name- Aryan Mishra
Roll No- 4
SUBMITTED TO- Mr Rajat Shubhara Bhattacharya
Acknowledgment
I, Aryan Mishra, am thankful for the opportunity of making this project on
library management system, based on the topic of relational database
management system. Through this project, I learned how a relational
database management system stores and manages data, with a real-life
example.
I would also like to express my sincere gratitude to Mr. Rajat Shubhara
Bhattacharya, our respected teacher, for his valuable guidance, support and
encouragement throughout the completion of my project “Library
Management System.” His constant supervision and constructive
suggestions helped me understand the topic deeply and complete the
project successfully.
I am also thankful to my school and the computer science department for
providing me with the necessary resources and a suitable environment to
carry out this project.
Certificate
• This is to certify that Aryan Mishra,
student of Class X-B, has successfully completed his Information
Technology project on
“LIBRARY MANAGEMENT SYSTEM” under the guidance of Mr. Rajat
Shubhara Bhattacharya.
• This project has been submitted to school SHRI GULAB RAI
MONTESSORI SR. SECONDARY SCHOOL
in fulfillment of the requirements for the academic year 2025–2026.
INDEX
• Steps to create table……………………………………………………………………………………………………………5
• Inserting data………………………………………………………………………………………………………………………6
• Create Tables Supplier and Cardholder with the same steps:……………………………………………….7
• Insert data …………………………………………………………………………………………………………………………..8
• Establish relationship among tables …………………………………………………………………………………….9
• Creating query 1: …………………………………………………………………………………………………………………10
• The result: ……………………………………………………………………………………………………………………………11
• Steps to create query 2 ………………………………………………………………………………………………………..12
• Result of query 2: …………………………………………………………………………………………………………………13
• Creating a form …………………………………………………………………………………………………………………….14
• Reports …………………………………………………………………………………………………………………………………15
• Report of cardholder table: ………………………………………………………………………………………………….16
• Report of supplier table ……………………………………………………………………………………………………….17
Abstract
Inventory control management database design
An inventory management system has several critical components. It is the process by which the tracking of goods
throughout the entire supply chain from purchasing to production to end sales. It is a combination of hardware and
software technology which tracks and manages product delivery, product sales, and other production processes. It works
by tracking the two main functions of a warehouse, receiving and shipping. First of all, we will have to properly think of the
useful field required and insert them in tables. Here we will require three tables, suppliers, cardholders, as well as books
table. These will contain some important records like supplier ID, address, city, phone number, and item, item name, price,
etc. After that, we will try to fill records in these tables using forms. Then we will take out important information using
query. And at last, we will have present them in presentable formats using reports. This study focuses on inventory
database, which is centralized repository for all inventory data in an organization. A database for inventory management
system allows balancing inventory costs and risks against the desired inventory performance mechanics. This inventory is
eliminating paperwork, human faults, manual delay, and speeds of process. This inventory management system will have
the ability to track sales and available inventory than a shopkeeper when it's time to reorder and how much to purchase. It
will make easier for us to track the actions of products as we will make queries of products that are higher in quantity so
that the management becomes easier.
Steps to create table
• Click on Create Table in Design View option under Tasks and a Table
Designer window appears as shown below.
• Specify the field name and data type of the field to be created by
selecting the appropriate type available under Field Type drop-down
list.
• Save and write the name as “Book” and click OK
Inserting data
Create Tables Supplier and Cardholder with
the same steps:
Insert data
Establish relationship among tables
Creating query 1:
Steps to Create the Query:
[Link] all the tables that you want to use
in the query. In this case, add the
Books table and the Supplier table.
[Link] the relationship between
the tables using the common field.
[Link] the fields from which the data
has to be extracted.
[Link] on the Criteria row and enter the
condition for which the query will display
the result.
In this case, the criteria is: Supplier ID
= 323.
[Link] the query with a suitable name.
The result:
Steps to create query 2
Here is the corrected and well-formatted
version:
Steps for Creating the Second Query:
[Link] all the tables from which you
want to extract data. In this case, select
the Books table and the Supplier table.
[Link] the fields to be included in the
query result. In this case, choose Name,
Author, and Price fields.
[Link] the Criteria row under the Price
field, specify the condition that the
books should cost less than ₹250.
[Link] the result of the query and
confirm that the output is correct.
[Link] the query and enter a suitable
query name.
Result of query 2:
Creating a form
Here is the corrected, polished, and well-formatted
version:
Forms Used in Library Management System:
Forms are used in a library management system to
enter data into tables. They provide a better, user-
friendly interface and make data entry easier. Forms
allow us to view each set of records separately in an
organized way. They are usually created with the help
of a Form Wizard, which is easier and faster
compared to creating a form in Design View.
In this project, we have created a form for the Books
table and entered the required data into the
respective fields.
The details entered are as follows:
•Book ID: 110
•Name of the Book: Myth of the Sisyphus
•Author: Albert Camus
•Publisher: Dupa Publications
•Genre: Philosophy
•Price: ₹723
Reports
Here is the corrected and polished version:
Reports in Library Management System:
Reports are created to show a summary or
overview of a table or a query. They present data in
a well-organized and printable format, making it
easier to analyze and understand information stored
in the database. Reports help in examining records,
comparing values, and generating useful insights for
decision-making.
Here is a report of books table:
Report of cardholder table:
Report of supplier table