Center for Industrial Technology and Enterprise

San Jose, Cebu City

INVENTORY SYSTEM

REQUIREMENTS SPECIFICATIONS

Jake Quimbo
Romnick Revalde
Emmanuel Broniola
ITP 3E
 Chapter 1 Introduction

1.1 Purpose

The primary objective of this software is to provide a systematic way of handling transactions

in borrowing and adding a new category or group of items. It enables the “administrators” to

systematically and accurately do transactions with its customers/users. In general, this

software offers a less hassle and effective way of removing the problems of borrowing and

returning of items through the use of a database.

1.2 Scope
The project is known as Enfants Du Mekong Inventory System(EDMIS). This software
encompasses the following general functionalities:
• Efficient Working Environment - EDMIS provides an efficient working environment
for administrators (e.g. librarians, etc) to lend items to its host just by interacting on
the software functions (either by clicking on the GUI or by encoding phrases to the
system).
• Dynamic GUI Interaction – Administrators would be able to interact with the system
dynamically through the user-friendly GUI which also guides the them all throughtout
the whole system.
• Dynamic Data Manipulation – EDMIS also has the capability to manipulate data
dynamically. If an administrator ask for a deletion or addition of an item to the
database, the software would be able to do so quickly. That’s is how it is being very
dynamic.

1.3 Project Constraints and Limitations

• This software is only intended to Enfants Du Mekong Usage.

• The software only supports administrator accounts.

Requirements Specifications 2
 • The software has no network support.

1.4 Hardware Requirements

• At least 128MB bytes of RAM

• At least 1G of hard disk

1.5 Software Requirements

Any Windows Platform

xampp (any version)

PHP 4 or PHP 5

Browsers like Mozilla Firefox(3.0.7), Opera, Google Chrome, etc.

1.6 Definitions of Terms

Administrators – Power users who can only use this software . They all have the privileges

that the software can offer.

CakePHP – PHP framework used in the software.

Enfants Du Mekong – a french organization dedicated to give quality education and life to

some of our under privilege youth.

GUI – Graphical User Interface, it ensures a good communication between the user and the

software.

Host – Enfants Du Mekong youths who are often using the items for their convenience and

studies.

1.7 References

[Link]
[Link]

Requirements Specifications 3
 [Link]
[Link]

Chapter 2 System Analysis

Diagram

The major components of the software are:

Requirements Specifications 4
 • Users – By default, they are set to be administrators. Users are assigned to a specific

username and password which they use in order to login and use the software. They are

entitled to privileges like adding, deleting, editing, etc. of database data.

• Categories – These are names of groups of items in the database. A category could be

of any sort.

• Items – These are the core data which has a specific category in the database.

Chapter 3 Functional Requirements

3.1 Management of Items

The software gives its user the privilege to manipulate items in the database. Administrators

are entitled to making a new category, add new items to a category, or delete it from its

category. Administrators are also the ones who have the complete privilege to lend items to

its host. Administrators can let them borrow it but they have to return it afterwards. The

tracking of the transactions made by the hosts are interacted by the administrators to the

system. Therefore, a 100% assurance is guaranteed that the items are completely controlled

and monitored.

3.1.1 Borrowing of items

A host can borrow an item by asking the administrator. The administrator then inputs all the

data of the host who borrows the item, meaning the host is logged to the system as a

borrower.

3.1.2 Returning of items

Requirements Specifications 5
 A host can return an item anytime he wants. The administrator then changes his attributes

from the database. If his status is being a “borrower”, it will be deleted and his status will go

back to its original state.

3.2 Adding a category

A category serves as a room for items. This is the key groups of items that separate them

from one another. For example, a mathematics book is under a books category and a

transformers CD is under a movies category. To add a category, the administrator will just

encode it via a form and the software will just be the one to interact it to the database.

3.3 Adding items to a category

Items are separated through their specific groups or category. To add items to a category, the
administrator will first select a category from the dropdown list. Then, he can already input
items to form inputs. It is up to the software to place it to the database.

Chapter 4 User Interface

The main user interface of this software is the login page of administrators where they input their

usernames and passwords in order to login to the system and interact with the software's

functionalities. The login page is very necessary for data security. Without the login page,

any data in the database is accessible by anyone who accesses the software.

3.5 Control 1

The main menus include the following link:

Requirements Specifications 6
Home - main page for logged in users. This will be the first page display after users are finished

logging in.

Categories – specifies the name of the group of items.

Items – list of items in the database.

Search – enables users to navigate and search for a keyword. If a match is found by the system, the

user would be prompted with the search results.

Requirements Specifications 7