SDFGH Pages Deleted
SDFGH Pages Deleted
SDFGH Pages Deleted
Gorakhpur,Uttar Pradesh-273010
A Report on
“Inventory Management System”
SUBMITTED IN
PARTIAL FULFILMENT FOR AWARD OF DEGREE OF BACHELOR OF
TECHNOLOGY
IN
COMPUTER SCIENCE AND ENGINEERING
By
Team
(Name) (Roll-No.)
Anjali Mishra 2021021017
Anshu 2021021018
Arun Kumar Yadav 2021021019
Arun Yadav 2021021020
Aryan Anand 2021021021
Submitted in
Department of Computer Science and Engineering
Under the Guidance of
1 Introduction
1.1 Introduction to IMS
1.2 Literature Review
1.3 Problem Statement
1.4 Objective Of the Project
1.5 Features of the project
1.6 Scope of the Application
2 System Analysis
2.1 The Proposed System
2.2 The Theoretical Background
2.3 Description of System
2.4 Limitations of Existing Project
2.5 Advantages of Proposed System
2.6 Feasibility Study
2.7 Background Knowledge
2.8 Software and hardware requirements
3 System design
3.1 Process flow diagram
3.2 Use case diagram
3.3 ER diagram
3.4 Components of ER diagram
3.5 Diagram Relationship
3.6 Activity Diagram
3.7 Inventory Activity
3.8 Class diagram
3.9 Sequence diagram
3.10 UML Diagram
3.11 DFD Diagram
4 Analysis and Design
4.1 Background research
4.2 Requirement Analysis
4.3 Ims Requirement
4.4 User requirements
Chapter:1
INTRODUCTION
1.1 Introduction to Inventory Management System
The project Inventory Management System is a complete web based application An inventory
management system is the combination of technology (hardware and software) and processes and
procedures that oversee the monitoring and maintenance of stocked products, whether those
products are company assets, raw materials and supplies, or finished products ready to be sent to
vendors or end consumers. Inventory Management System plays an important role because it
reduces the stress, monitoring of products, making balance sheets and many more which was done
manually. Simply Inventory Management System overtook the manual things and also it optimizes
the cost and time constraint. Inventory Management Software is an open source project developed
by procedural php, MySQL, bootstrap, and jquery. This application is based on web application and
develop with procedural php, MySQL database, jquery, data tables plugins, and bootstrap. This
application provides the users to manage brands, category, product, orders, and report. This system
provides best inventory management software features. This system can be also used for small
business.
Products are considered as the business resources for the organization. This includes managing the
product with appropriate way to review any time as per the requirement. Therefore it is important to
have a computer based IMS which has the ability to generate reports, maintain the balance of
The stock, details about the purchase and sales in the organization. Before developing this application
we came up with Inventory Management System existing in the market, which helps to give the
knowledge for the development of our project. After analyzing the other inventory management
system we decided to include some of common and key features that should be included in every
inventory management system. So we decided to include those things that help the small organization
in a way or other.
1.3. Problem Statement
Secondary objective
To develop an application that deals with the day to day requirement of any production
organization
To develop the easy management of the inventory
To handle the inventory details like sales details, purchase details and balance stock details.
To provide competitive advantage to the organization.
To provide details information about the stock balance.
To make the stock manageable and simplify the use of inventory in the organization.
1.5 Features of Project
This application is used to show the stock remaining and details about the sales and purchase. It gives
the details about the stock on daily based and weekly based. The details components are described
below:
Create Stock
We can create stock if we need to extend or we have more than one stock. We can create the stock
along with the date.
Sales details
It show the details about the sales and the remaining stock of sales. It also show the details about the
sales in return.
Purchase details
It shows the details about the purchase made by the organization along with the price and dates.
Generate Report details
It generate the purchase report of any months. And the report show in pdf format.
The proposed system is computerized and has been developed using advance language therefore it
gives more facilities than present system.
By user friendly we mean to make records available to the user at just the hit of a keystroke.
To maintain the list of Student records, to maintain records of Customers and Event, to
maintain records of Customer, to maintain the transaction details. To add/update/search them
from the database-all these features have been considered for the management of the system.
Besides maintaining the data in the database the system also has the provision for printing
various reports.
The system helps reduce the paper work and provide an efficient environment that is user friendly
to work in.
Inventory Management systems (IMS) :- are part of the so-called inventory System Process, which
are applications supporting the direct contact with the volunteer and Customers.The aim of the project titled
INVENTORY MANAGEMENT is to development enterprise software that optimizes the performance
of an event management company. This system helps the managers at different departments to
coordinate their work and thereby save their valuable time and finance.
2.3Description of System
Existing System:--
In present non-computerized system all jobs are performed manually. All records of Customer,
and Customers details are written and stored in paper format in a file
2.4 Limitation of Existing System:-
in files, so there will be lot of redundancy
In present system each and every record is maintained
in maintaining ‗Customer and Volunteer records.
Also there is no security as all records are maintained in files.
Modification of one record causes changes to other records related to that record, so work becomes
very critical, there are chances of data loss
Storage of information is costly.
Require knowledge about the system
Searching any old record requires more time due to critical system of register
Present system is very time consuming.
A lot of paperwork is maintain
Difficult in maintaining records
It is difficult to keep through registers for many years or months safely.
There are many chances of mistakes as all the data is handled manually.
The system is platform independent as it is developed in Asp.net with C# Web Application.
It facilitates quick processing of data.
Data present in database is highly secured.
Searching of data is done very easily & more efficiently.
Maintaining of data is very proper & accurate.
Information of any Item can be retrieved any time.
It provides facility to modify records.
It will save user time.
User can get several responses at a place.
Feasibility study tells whether the system would be beneficial for the organization with respect to the
requirements of the organization. Feasibility study is divided into the following phases:
I. Operational Feasibility:
Operational feasibility is dependent on the human resources available for the project and involves
projecting whether the system will operate and used once it is install. It is mainly concerned with the
availability of human resources for the project. In the staff, Student and Teachers, different departments
and members are assigned according to their jobs.
I. Architectural Review
This Web based application is based on 3-tier architecture. The3-tier includes the three hierarchy of the
flow of programming logic from user interface to database and again database to user interface with
the desired information requested by the clients. In between there involves the logic layer for
effectively and correctly manipulating the request. The 3-tier includes the following:
II Client tier
The visual part is implemented using all kinds of swing components, which does not make database
calls. For example, inventory list will display when user click ―display‖ button if he or she wants to
know the list of stock remaining in the organization.
V. Database Theory
A database is a collection of information that is organizes so that it can easily be accessed, managed
and updated. In one view, database can be classified according to types of content: bibliography, full-
text, numeric, and image.
VI. Relational Database
IMS has the relational database model. A relational database is a digital database whose organization is
based on the relational model of data. This model organizes data into one or more tables of rows and
columns. The standard user and application program interface to a relational database is the structured
query language (SQL). SQL statement are used both for interactive queries for Information from
relational database and for gathering data for reports.
VII.PrimaryKey
The primary key of a relational table uniquely identifies each record in the table A primary key‘s main
features are:
It must contain a unique value for each row of data.
It cannot contain null value.
X. ACID Property
Every database transaction obeys the following rules:
1. Atomicity
2. Consistency
3. Isolation
4. Durability
. 2.8 SOFTWARE AND HARDWARE REQUIREMENTS
Software Requirements :-
Front End : HTML ,CSS ,JavaScript
Operating System : Windows 11
For Documentation : Microsoft Office 2007
Hardware Requirements :-
Processor :- Intel core i5
RAM :- 1GB onwards
Free Hard Disk Space :- 2 GB or more
Chapter 3
SYSTEM DESIGN
Entity relationship diagrams are useful for illustrating the relationships between different
elements in a database. With the help of entity relationship diagrams, the structure of a database
is made clear, and it is possible to see exactly how the different elements are interlinked. You
can use entity relationship diagrams to plan a database you are going to build, or to maintain an
existing database structure.
ER Diagram is a visual representation of data that describes how data is related to each other. In
ER Model, we disintegrate data into entities, attributes and setup relationships between entities,
all this can be represented visually using the ER diagram.
For example, in the below diagram, anyone can see and understand what the
diagram wants to convey: Developer develops a website, whereas a Visitor visits a
website.
3.4 Components of ER Diagram
Entity, Attributes, Relationships etc. form the components of ER Diagram and there are defined symbols
and shapes to represent each one of them.
Entity
Simple rectangular box represents an Entity.
Weak Entity
A weak Entity is represented using double rectangular boxes. It is generally connected to another entity.
1. Binary Relationship
2. Recursive Relationship
3. Ternary Relationship
Action Flow
Action flows, also called edges and paths, illustrate the transitions from one action state to another. They
are usually drawn with an arrowed line.
Object Flow
Object flow refers to the creation and modification of objects by activities. An object flow arrow from
an action to an object means that the action creates or influences the object. An object flow arrow from
an object to an action indicates that the action state uses the object.
Synchronization
A fork node is used to split a single incoming flow into multiple concurrent flows. It is represented as a
straight, slightly thicker line in an activity diagram.
A join node joins multiple concurrent flows back into a single outgoing flow.
A fork and join mode used together are often referred to as synchronization.
Time Event
This refers to an event that stops the flow for a time; an hourglass depicts it.
Merge Event
A merge event brings together multiple flows that are not concurrent.
Interrupting Edge
An event, such as a cancellation, that interrupts the flow denoted with a lightning bolt.
Final State or End Point
An arrow pointing to a filled circle nested inside another circle represents the final action state.
Fig.Inventory Activity
3.8 CLASS DIAGRAM
Active Classes
Active classes initiate and control the flow of activity, while passive classes store data and serve
other classes. Illustrate active classes with a thicker border.
Visibility
Use visibility markers to signify who can access the information contained within a class. Private visibility,
denoted with a - sign, hides information from anything outside the class partition. Public visibility, denoted
with a + sign, allows all other classes to view the marked information. Protected visibility, denoted with a #
sign, allows child classes to access information they inherited from a parent class.
Associations
Associations represent static relationships between classes. Place association names above, on, or below the
association line. Use a filled arrow to indicate the direction of the relationship. Place roles near the end of
an association. Roles represent the way the two classes see each other.
Multiplicity (Cardinality)
Place multiplicity notations near the ends of an association. These symbols indicate the number of instances
of one class linked to one instance of the other class. For example, one company will have one or more
employees, but each employee works for just one company
.
Composition and Aggregation
Composition is a special type of aggregation that denotes a strong ownership between Class A, the
whole, and Class B, its part.
Illustrate composition with a filled diamond. Use a hollow diamond to represent a simple aggregation
relationship, in which the "whole" class plays a more important role than the "part" class, but the two
classes are not dependent on each other.
The diamond ends in both composition and aggregation relationships point toward the "whole" class (i.e.,
the aggregation).
Class Diagram
A sequence diagram is an interaction diagram that shows how processes operate with one another and
in what order. It is a construct of a Message Sequence Chart.
A sequence diagram shows object interactions arranged in time sequence. It depicts the objects and
classes involved in the scenario and the sequence of messages exchanged between the objects needed to
carry out the functionality of the scenario.
Sequence diagrams are typically associated with use case realizations in the Logical View of the system
under development. Sequence diagrams are sometimes called inventory diagram.
A sequence diagram shows, as parallel vertical lines (lifelines), different processes or objects that live
simultaneously, and, as horizontal arrows, the messages exchanged between them, in the order in which
they occur.
Visual
Notation Description
Representation
Actor
A type of role played by an entity that interacts with the subject (e.g., by
exchanging signals and data)
external to the subject (i.e., in the sense that an instance of an actor
is not a part of the instance of its corresponding subject).
represent roles played by human users, external hardware, or
other subjects.
Note that:
Lifeline
Call Message
Return Message
Recursive Message
Create Message
Duration Message
Note
A note (comment) gives the ability to attach various remarks to elements.
modeler.
3.10 UML DIAGRAM
[4]
UML offers a way to visualize a system's architectural blueprints in a diagram, including elements such as:
A data flow diagram (DFD) is a graphical representation of the "flow" of data through an information
system, modeling its process aspects. Often they are a preliminary step used to create an overview of
the system which can later be elaborated. DFDs can also be used for the visualization of data processing
(structured design).
A DFD shows what kinds of information will be input to and output from the system, where the data will
come from and go to, and where the data will be stored. It does not show information about the timing of
processes, or information about whether processes will operate in sequence or in parallel (which is shown
on a flowchart.
A DFD represents flow of data through a system. Data flow diagrams are commonly used during problem
analysis. It views a system as a function that transforms the input into desired output. A DFD shows
movement of data through the different transformations or processes in the system.
Dataflow diagrams can be used to provide the end user with a physical idea of where the data they input
ultimately has an effect upon the structure of the whole system from order to dispatch to restock how any
system is developed can be determined through a dataflow diagram. The appropriate register saved in
database and maintained by appropriate authorities.
We usually begin with drawing a context diagram, a simple representation of the whole system. To
elaborate further from that, we drill down to a level 1 diagram with additional information about the major
functions of the system. This could continue to evolve to become a level 2 diagram when further analysis
is required. Progression to level 3, 4 and so on is possible but anything beyond level 3 is not very common.
Please bear in mind that the level of detail asked for depends on your process change plan.
Diagram Notation
Now we'd like to briefly introduce to you a few diagram notations which you'll see in the tutorial below.
1. External Entity
An external entity can represent a human, system or subsystem. It is where certain data comes from or goes
to. It is external to the system we study, in terms of the business process. For this reason, people use to
draw external entities on the edge of a diagram.
Process
A process is a business activity or function where the manipulation and transformation of data takes place.
A process can be decomposed to finer level of details, for representing how data is being processed within
the process.
3.Data Store
A data store represents the storage of persistent data required and/or produced by the process. Here are
some examples of data stores: membership forms, database table, etc.
4. Data Flow
A data flow represents the flow of information, with its direction represented by an arrow head that shows at
the end(s) of flow connector.
Symbol Description
Data Flow – Data flow are pipelines through the packets of information
flow.
Admin
Able to create new go down along with date.
Able to edit the entry as per entry.
Able to add, modify and delete the stock entry.
Inventory management
Able to check the stock available.
Able to check the balance payment.
Able to view the remaining sales stock
Feasibility Analysis
This software has been tested for various feasibility criterions from various point of views.
Economic Feasibility
The system is estimated to be economically affordable. The system is medium scale desktop
application and has affordable price. The benefits include increased efficiency, effectiveness, and the
better performance. Comparing the cost and benefits the system is found to be economically feasible.
Technical Feasibility
Development of the system requires tools like:
MySQL,
Which are easily available within the estimated cost and schedule.
Operational Feasibility
The system provides better solution to the libraries by adding the typical requirement and necessities.
The solution provided by this system will be acceptable to ultimate solution for the stock management.
Schedule Feasibility
The organized schedule for the development of the system is presented in the schedule sub-section.
The reasonable timeline reveals that the system development can be finished on desired time
framework.