Computer Project File

Academic Year: 2025–26

Name: Rajat Pal
Class: 12th ‘A’
Roll No.: 17651991
School: SMB Gita Sr. Sec.
School
Submitted To: Virender Sir
Topic: Inventory Management
System
 Certificate
This is to certify that Rajat Pal, a student of
Class XII, Section A, Roll No. 17651991, of SMB
Gita Sr. Sec. School, has successfully completed
the Computer Science project entitled
“Inventory Management System” during the
academic year 2025–26.
This project is submitted in partial fulfillment of
the requirements for the subject Computer
Science under the guidance of Mr. Virender.
It is further certified that this project is the
original work of the student and has been
carried out sincerely.

Date: 01/01/26
Signature of Teacher:__________
 Acknowledgement
I would like to express my sincere gratitude to my
Computer Science teacher, Mr. Virender, for his valuable
guidance, encouragement, and support throughout the
completion of this project on Inventory Management
System. His constant supervision and constructive
suggestions have been instrumental in shaping this work.
I am also thankful to the Principal and Management of
SMB Gita Sr. Sec. School for providing me with the
facilities and environment to carry out this project
successfully.
Finally, I extend my heartfelt thanks to my family and
friends for their cooperation and motivation during the
preparation of this project.
 Introduction
An Inventory Management System (IMS) is a software
application designed to track, manage, and control the
flow of goods within an organization. It helps
businesses monitor stock levels, sales, purchases, and
deliveries in a systematic and efficient manner.
Traditionally, inventory was managed manually using
registers or spreadsheets, which often led to errors,
delays, and mismanagement. With the advancement
of technology, computerized inventory systems have
become essential for ensuring accuracy and efficiency.
The IMS provides real-time updates on stock
availability, generates alerts for low inventory, and
maintains records of suppliers and customers. It also
supports billing, invoicing, and reporting, making it a
vital tool for modern businesses.
Inventory Management Systems are widely used in
retail shops, warehouses, manufacturing industries,
hospitals, and e-commerce platforms, as they help
reduce losses, improve planning, and enhance
customer satisfaction.
Thus, the study of IMS is important for understanding
how businesses optimize resources and maintain
smooth operations in today’s competitive
environment.
 Objective
The main objectives of this project on
Inventory Management System (IMS) are:
• To understand the concept of inventory
and its management in organizations.
• To study the features, advantages, and
limitations of IMS.
• To explore the real-life applications of
IMS in retail, warehouses,
manufacturing, and healthcare.
• To design and implement a small
database project using SQL queries for
managing inventory records.
• To highlight the importance of IMS in
ensuring accuracy, efficiency, and better
resource planning.
 System Analysis
System Analysis is the process of studying and understanding
the existing system to identify its problems, requirements, and
objectives before developing a new solution. In the context of
an Inventory Management System (IMS), system analysis helps
in designing a system that is efficient, reliable, and
user-friendly.
1. Existing System:
• Inventory managed manually using registers or
spreadsheets.
• Problems: errors in stock records, duplication, delays in
billing, difficulty in tracking suppliers/customers.
2. Proposed System:
• A computerized Inventory Management System using a
database.
• Features: real-time stock updates, automated billing,
supplier/customer records, low-stock alerts, reporting.
3. System Requirements:
• Hardware: Computer with sufficient storage and processing
power.
• Software: Database software (MySQL/SQL Server),
front-end application.
• Users: Admin (manages stock), Staff (updates
sales/purchases), Customers (indirectly affected).
affect operations).
4. System Objectives:
• Reduce errors and duplication in inventory records.
• Provide accurate and real-time stock information.
• Improve efficiency in billing and reporting.
• Ensure data security and controlled access.
 Theory
1. Inventory
• Inventory refers to the goods and materials that a
business holds for the purpose of resale or production.
• Types of inventory:
• Raw Materials – Basic inputs for production.
• Work-in-Progress (WIP) – Semi-finished goods.
• Finished Goods – Ready products for sale.
• Maintenance, Repair & Operations (MRO) – Supplies
needed for daily operations.

2. Inventory Management System (IMS)

An Inventory Management System is software designed to
monitor stock levels, track sales/purchases, and generate
reports. It ensures that businesses maintain the right amount
of stock at the right time.
3. Components of IMS:
• Database – Stores product, supplier, and customer
information.
• User Interface – Allows staff to input and view data.
• Processing Unit – Executes queries and updates records.
• Reports & Analytics – Provides insights into stock levels,
sales trends, and supplier performance.
4. Functions of IMS
• Recording purchases and sales.
• Updating stock levels in real time.
• Generating invoices and bills.
• Alerting for low stock or overstock situations.
• Maintaining supplier and customer records.
• Producing analytical reports for decision-making.
 Features of Inventory
Management System
An Inventory Management System (IMS) provides
several important features that make stock handling
efficient and reliable. The major features are:
• Real-Time Stock Updates: Automatically adjusts
inventory levels after every sale or purchase.
• Billing & Invoicing: Generates bills and invoices
quickly and accurately.
• Supplier & Customer Records: Maintains detailed
information about suppliers and customers.
• Low Stock Alerts: Sends notifications when product
levels fall below a set threshold.
• Reporting & Analytics: Provides detailed reports on
sales, purchases, and stock trends.
• Multi-User Access: Allows multiple staff members to
use the system simultaneously.
• Data Security: Ensures that only authorized users can
access or modify records.
• Backup & Recovery: Protects data against accidental
loss with recovery options.
Applications of Inventory
Management System
An Inventory Management System (IMS) is widely
used across industries to streamline operations
and improve efficiency. Some major applications
include:
• Retail Shops: Tracks daily sales, manages stock
levels, and generates bills.
• Warehouses: Monitors incoming and outgoing
goods, prevents overstocking or shortages.
• Manufacturing Industries: Manages raw
materials, work-in-progress, and finished
goods inventory.
• Hospitals & Pharmacies: Keeps records of
medicines, medical supplies, and equipment.
• E-Commerce Platforms: Provides real-time
stock updates, order tracking, and customer
notifications.
• Educational Institutions: Manages laboratory
equipment, library books, and stationery
supplies.
 Software Testing
Software Testing is the process of evaluating a
software application to ensure that it meets the
specified requirements and works correctly without
errors. For an Inventory Management System (IMS),
testing is essential to confirm that stock updates,
billing, and reporting are accurate and reliable.

1. Purpose of Testing
•Verify that the IMS functions as intended.
•Ensure accuracy in product records, sales, and stock
updates.
•Detect and fix errors before deployment.
•Validate that the system meets user requirements.
2. Types of Testing
•Unit Testing – Testing individual modules (e.g.,
product entry, billing).
•Integration Testing – Checking how modules interact
(e.g., sales affecting stock levels).
•System Testing – Testing the complete IMS as a
whole.
•User Acceptance Testing (UAT) – Ensuring the system
is user-friendly and meets business needs.
3. Importance of Testing
•Ensures reliability and accuracy of the system.
•Reduces risk of data loss or mismanagement.
•Improves user confidence and satisfaction.
•Saves time and cost by detecting errors early.
4. Sample Test Cases
 Example Project – SQL
Implementation
To demonstrate the working of an Inventory
Management System, a sample database named
Inventory is created. It contains tables for products,
suppliers, and sales.
1. Creating Tables:
CREATE TABLE Products (
ProductID INT PRIMARY KEY,
ProductName VARCHAR(50),
Quantity INT,
Price DECIMAL(10,2)
);
CREATE TABLE Suppliers (
SupplierID INT PRIMARY KEY,
SupplierName VARCHAR(50),
Contact VARCHAR(20)
);
CREATE TABLE Sales (
SaleID INT PRIMARY KEY,
ProductID INT,
QuantitySold INT,
SaleDate DATE,
FOREIGN KEY (ProductID) REFERENCES Products(ProductID)
);
2. Inserting Records:
INSERT INTO Products VALUES (1, 'Pen', 100, 10.50);
INSERT INTO Products VALUES (2, 'Notebook', 50, 45.00);
INSERT INTO Suppliers VALUES (1, 'ABC Stationery', '9876543210’);
INSERT INTO Suppliers VALUES (2, 'XYZ Papers', '9123456780’);
INSERT INTO Sales VALUES (1, 1, 10, '2026-01-20’);
INSERT INTO Sales VALUES (2, 2, 5, '2026-01-21');
3. Querying Data:(SQL)
Display all products
SELECT * FROM Products;
Find products with low stock
SELECT ProductName FROM Products WHERE Quantity <
60;
Show sales details with product names
SELECT [Link], [Link],
[Link], [Link]
FROM Sales
JOIN Products ON [Link] = [Link];
 Conclusion
The study of Inventory Management highlights its crucial
role in ensuring the smooth functioning of businesses. By
maintaining accurate records of stock, purchases, and
sales, an Inventory Management System (IMS) helps
organizations reduce errors, improve efficiency, and make
better decisions.
From manual registers to modern computerized systems,
inventory management has evolved into a powerful tool
that integrates with billing, reporting, and analytics. It not
only saves time and cost but also enhances customer
satisfaction by ensuring product availability at the right
time.
Through this project, I have learned how Database
Management Systems (DBMS) can be applied to real-life
scenarios such as retail shops, warehouses, manufacturing
industries, hospitals, and e-commerce platforms. The
practical use of SQL queries demonstrated how data can
be stored, updated, and retrieved effectively.
In conclusion, inventory management is not just about
tracking goods—it is about optimizing resources,
minimizing losses, and supporting business growth in
today’s competitive environment. This project has been a
valuable learning experience, connecting theoretical
knowledge with practical applications.