CHAPTER 3

DESIGN AND METHODOLOGY

3.1 Requirement Analysis

The proposed system has different modules and different database table for different
purpose. The textbox forms are laid out properly to input data and filter data faster.

3.2 Requirement Documentation

The first step in developing the system is connecting it to the database. The system has
four modules. The manage material module handles the material details. The next step
is to stock in or stock out module. Lastly is to create report by filtering the stock data.

3.2.1 Methodology Used for System Development

Requirement Analysis

In the requirement analysis, Basilan State College Supply Inventory System is designed
to help the Supply Officer to have an effective inventory system that generate stocks

Basilan State College Supply Inventory System

3-1
forecast and generate stock report. This will help the Supply Officer to input and
manipulate stocks data.

System Design

After the requirement phase, all data gathered and transformed into diagram that shows
the interface and functions of the Basilan State College Supply Inventory System. It will
visualize how the System works, the processes and how it will function. The Stock
Inventory System is designed so that the Supply Officer would be able to input,
manipulate and monitor stocks inventory fast also, to generate report.

Implementation

The system is designed based on the client’s needs and preferences. All the information
needed is observed through researched papers, related system and the existing
system. The system is developed with different separate forms that will be
interconnected. We used Visual basic for our programming language and SQL for
database.

Testing

First all forms are tested one by one in order to make sure they will function well and to
remove errors, and lastly to compile all and test the system as a whole to spot failures
or faults.

Deployment

Once all testing is done, the system will be delivered to the client and observed for
minor changes or fixes.

Maintenance

The client might experience bugs or laggy, so some functions must be fixed or updated.
The client future needs may be different so upgrade is an option or re-design the
system.

Basilan State College Supply Inventory System

3-2
3.3 Design of Software Systems

HARDWARE

LAPTOP - We will be using laptop for the development and deployment of the
system.

SOFTWARE

VisualBasic.net – We chose Visual Basic.net as our programming language.

Visual Studio 2019 - We chose Visual Studio 2019 as our programming

environment.

MySQL - We chose mysql for our database.

XAMPP - We also chose Xammp to configure our database.

Basilan State College Supply Inventory System

3-3
 3.3.1 Hierarchical Structure

Basilan State College Supply Inventory

System

ADMIN

DASHBOARD

INVENTORY ADD ITEM STOCK REPORT

CARD

ADD DELETE
MATERIALS MATERIALS INVENTORY
STOCK DETAILS STOCK
UPDATE REPORT
AVIALABILITY STOCKS REPORT

Basilan State College Supply Inventory System

3-4
 3.3.2 Data Flow Diagram (existing and proposed)

Context Diagram

Materials Details

Stock Quantity
Filter Material’s Stock 0.0 Stocks Qty.
Checker
ADMIN Basilan State Stocks Count
College Supply
Stock Inventory Report Inventory System

Basilan State College Supply Inventory System

3-5
Basilan State College Supply Inventory System
3-6
Basilan State College Supply Inventory System
3-7
 3.3.3 Flow Chart

START

Enter Username &

Password

LOG-IN

NO
Verify
DATABASE

YES

Display
Dashboard

DASHBOARD

END

Basilan State College Supply Inventory System

3-8
 DASHBOARD

Select Menu

Add Iten Inventory Report Stock card

END

Basilan State College Supply Inventory System

3-9
 Add Item

Display DataGrid

NO
Add Materials?

YES

Add Materials Tab

Enter materials code, description, group,

unit.

Verify if
duplicate

YES
Verify for dupplication

NO

DATABASE
SAVE

Manage Materials

Basilan State College Supply Inventory System

3 - 10
 Manage Stock In

Load Material List DATABASE

Stock In

Enter amount

NO
Amount must be Integer

YES

Update Material
Stock qty. DATABASE

End

Basilan State College Supply Inventory System

3 - 11
 Manage Stock Out

Load Material List DATABASE

Stock Out

Enter amount

NO
Amount must be Integer

YES

Update Material
Stock qty. DATABASE

End

Basilan State College Supply Inventory System

3 - 12
 Report

Load Material List DATABASE

Load Material List

Edit for Report

Generate Report DATABASE

Report Data

Print

End

Basilan State College Supply Inventory System

3 - 13
 3.3.4 Entity Relationship Diagram (Physical ERD and Logical ERD)

Physical ERD

tbl_StockIn
tbl_user ID int(11) A.I
ID int(11) A.I code varchar (100)
name varchar(100) description varchar (100)
usernam
e varchar(100) groups varchar (100)
password varchar(100) units varchar (100)
position varchar(100) oldstock int(100)
stockin int(100)
currentstock int(100)
Date datetime

tbl_group
ID int(100) A.I tbl_materials tbl_report
addgroup varchar(100) ID int(11) A.I ID int(11) A.I
code varchar (100) requestno varchar (100)
description varchar (100) requestdate date
groups varchar (100) reportno varchar (100)
tbl_unit units varchar (100) reportdate varchar (100)
ID int(100) A.I Stocks int(100) reportime varchar (100)
addgroup varchar(100) code varchar (100)
description varchar (100)
groups varchar (100)
tbl_StockOut units varchar (100)
ID int(11) A.I Stocks int(100)
code varchar (100) Project varchar (100)
description varchar (100)
groups varchar (100)
units varchar (100)
oldstock int(100)
stockin int(100)
currentstock int(100)
Date datetime
deliveredto varchar (100)
requestor varchar (100)

Basilan State College Supply Inventory System

3 - 14
 Stock-Inbound
Users ID
ID code
name description
username groups
password units
position oldstock
stockin
currentstock
date

Load
materials

Group
ID
addgroup Load Materials
group ID Report
code ID
description requestno
Load
groups materials requestdate
units reportno
Unit
Load Stocks reportdate
unit
ID reporttime
addgroup code
description
Load groups
materials units
Stocks
Project

StockOut
ID
code
description
groups
units
oldstock
stockin
currentstock
date
deliveredto
requestor
Logical ERD

Basilan State College Supply Inventory System

3 - 15