Chapter 1

INTRODUCTION

1.1 Background of the Study

Tricycles are a three-wheeled vehicle with a sidecar or lounge chair, which is

utilized as an open transport in the Philippines. LTFRB or the Land

Transportation Franchising and Regulatory Board regulated the buses and

jeepneys while tricycles are not managed by the LTFRB. Rather, the local

government units were authorized to deal with the franchising of tricycles since

1991.

Binan Tricycle Franchising and Regulatory Board (BTFRB) is an agency of

the City Government of Binan under the City Community Affairs Office which is

responsible for circulating, overseeing, executing and managing compliance of

policies, laws, and regulations of tricycle services. The office is situated at POSO

office, BC3 Building, Brgy. Zapote, Binan City, Laguna. The management is

under the supervision of Mr. Ronaldo Roscain. There are 4,450 registered

tricycle franchises which are members of 45 TODA and with an average client of

30 tricycle operators and drivers in a day. The most frequent violation that is

being violated for the past five years were Invalid or No Franchise and Illegal

Parking at Poblacion and San Antonio respectively.

Since tricycle operations are often the source of income for many of the

locals, the BTFRB is doing their best to accommodate all the transactions in their

department, but despite their hard work, there are still factors that need to be

1
improved. BTFRB still uses a manual process in recording their transactions thru

a logbook. For a renewal of a franchise, all approved franchises were recorded

on the Franchising Logbook and all approved application for Dropping the

Franchise were recorded on the Dropping logbook. With this kind of record

keeping, the Franchising Manager has difficulty in monitoring the status of all the

registered tricycle franchise such as: expired, renewed, canceled and transferred

franchises. For the list of violations, all tickets that were issued on that day will

be recorded on the Violation logbook including the monitoring of payment. The

Violation manager has difficulty in monitoring records especially in checking the

status of the payment thus sometimes resulted to the processing and approval of

the renewal of a tricycle franchise even if the applicant has a pending violation

that needs to be settled. BTFRB staff also experienced unreadable data and

some of the pages were already deteriorated due to long period of being used.

This manual process resulted to long queuing due to the retrieval of records.

Renewal of franchise is time-consuming for the applicants since they need at

least two working days for the processing for the renewal of their tricycle

franchise because it requires actual inspection of the tricycle. The first day is the

submission and checking of the requirements and the second day is the

inspection of the tricycle. With these problems, the proponents would like to help

the BTFRB to serve the citizens of Binan by developing a system which will be

beneficial both for the BTFRB staff and the tricycle operators and drivers in our

project titled “Web-Based Management System with SMS and e-mail Notification

for Binan Tricycle Franchising and Regulatory Board”.

2
1.2 Objective of the Study

1.2.1 General Objective

The general objective of this study is to provide solutions to the problems

experienced by BTFRB in maintaining their records of tricycle franchising,

records of violations and penalties, and report generation, through the

creation of a Web-Based Management System with SMS and e-mail

Notification.

1.2.2 Specific Objective

This study aims to:

1. Develop a system that is accessible to BTFRB and their client.

2. Create a module that will manage franchise such as.

a) Application for new, renewal and updating of franchise (drop or

transfer)

b) Approval of applied tricycle franchise

3. Design a module that can Manage Violations such as.

a) Add, update and delete violations and violators.

b) Viewing of violations committed by the clients

4. Design a module that will not allow the client to renew their tricycle

franchise if they have an existing unsettled violation.

3
 5. Create a module that will automatically send e-mail notification and

SMS notification to the client once their application was approved

and ready for inspection.

6. Create a module that will generate report such as:

a) Audit Trail

Records the movement on the system.

b) Penalty Reference

View list of issued tickets.

c) Apprehension Incentives

View list of apprehensions

d) Apprehension Status

Can generate report for the List of Apprehensions, paid and

unpaid, Violation Occurrences and Violation Record per Barangay.

e) Franchise Status

Can generate report for the list of franchise such as new

franchise, renewed franchise, expired franchise and drop franchise.

f) Franchise Certificate

Can generate franchise certificate.

4
 g) Drop Certificates

Can generate drop certificates.

1.3 Scope and Delimitation of the Study

1.3.1 Scope of the Study

The proponents aimed to established a better way of communication for

BTFRB and their clients. Web-Based Management System with SMS and e-

mail Notifications for Binan Tricycle Franchising and Regulatory Board

covers the ff:

 BTFRB Staff

 Admin Module

Will be the administrator of the system. Overall controller of

the system.

a. Manage Account

Admin can add, edit and delete users of the system.

b. Audit Trails

Shows all the transactions done by each users.

 Franchising Manager Module

a. Manage Franchise

5
 BTFRB Staff can add, update and delete the list of

franchise.

b. Approve Requirements

BTFRB Staff / Requirement Checker can view and check

all submitted requirements for approval. Then update the

status of the application. Upon approval of the

application, schedule for inspection will be automatically

sent thru e-mail or SMS to the applicant.

c. Motorcycle Information

BTFRB Staff can add, update and delete the list of

registered motorcycle.

d. TODA Information

BTFRB Staff can add, update and delete the list of

TODA registered in their office.

f. Generate Reports

Franchising Manager can generate report for Franchise

Certificate and Drop Certificate.

g. Manage Account

Franchising Manager can add update and deleted

account of the client.

6
  Violation Manager Module

a. Manage Penalties

BTFRB Staff can update the payment settled by tricycle

operators, can add and delete violators and violations

committed by the tricycle drivers.

b. Manage Violations

BTFRB Staff can add new violation, update violation fee

and delete non-existing violations.

c. Generate Report

BTFRB Staff view list of issued tickets.

 Enforcer Module

Enforcer can view the numbers of violations they

apprehended.

 Clients / Tricycle Operators

a. Renewal of Tricycle Franchise

Tricycle operators can apply for the renewal of their franchise

online.

7
 b. Drop or Transfer of Franchise

Tricycle operators can apply to drop or transfer their franchise

online.

c. View Transaction Status

Tricycle operators can view the status of the applied

transactions.

d. Check Violation

Tricycle operators can view the amount of their incurred violation

in the system thru the reference number on the issued Ordinance

Infraction ticket by the enforcer.

1.3.2 Delimitation of the Study

The proposed system should be connected to the internet. It has no

payment module. The system only covers the franchise of the tricycle and

traffic rule violators in Binan City, Laguna

8
 CHAPTER 2

THEORETICAL FRAMEWORK

2.1 Review of Related Literature and Studies

Web-Based Management System

According to Thomas (2015) Strategies, frameworks and articles of

fabricating of making an electronic spreadsheet utilizing an online spreadsheet

application. A web-server facilitating an electronic spreadsheet site involves at

least one computer(s) having somewhere around one PC processor, memory,

information stockpiling and a system specialized gadget (e.g. a system

connector). The web-server is designed to transmit a spreadsheet web

application to a client figuring gadget (e.g. a PC, cell phone, and so on.) having

an internet browser through the web. The spreadsheet web application is

arranged to program the internet browser of the registering gadget to show and

execute a spreadsheet web application having different highlights and

usefulness, including at least one of a different structure segment and review

board, a test information include, line by line working of a spreadsheet without a

beginning framework of lines and segments, an installed spreadsheet include, an

implanted worksheet show inside a line highlight, or any blend of these

highlights.

Fox and Tye (2016), said that Web-based are accessible to one or more

clients using the internet. For instance, client frameworks may utilize an internet

browser to get to at least one electronic applications that are running on a server

9
framework. The Connection between the program and an electronic application

might be viewed as a session, for example, a hypertext exchange convention

(HTTP) session. Data about the session, which can be alluded to as session

state data, might be put away at the server framework. Every application on the

server framework with which the program communicates might be related with its

own unmistakable session (i.e., between that application and the program) with

its very own session state data. A first web application with which the program is

associating and for which a session is set up may exchange control of the

program communication to a second web application. This exchange may

happen for any number of reasons. Notwithstanding, it might be troublesome or

unimaginable for the primary web application to share the session state data with

the second web application.

According to Sikora (2016), a web-based would be one that runs utilizing

Internet conventions. It could be an Internet or Intranet-based framework.

Generally, it likewise implies that it was composed utilizing some kind of HTML

variation as its programming base. The framework could be inside facilitated

inside an organization or remotely facilitated in somebody's cloud.

Fong, Ng and et.all (2017) said that present creation gives a framework

that encourages intelligence and web-based access. Amid activity, the

framework executes a content which naturally gets to at least one sites. While

executing the content, the framework recovers client particular information

related with a client. The framework at that point utilizes the client particular

information to get to an objective site. While getting to the objective site, the

10
framework gets an intelligence in which the framework presents to the client. The

framework at that point gets a reaction to the intuitiveness for the client, and

advances the reaction to the site.

According to Younge (2018) web-based information gives a lot of benefits

to technology. Since we can use broadband connections anywhere we can

access the computer everywhere. This is one of the advantages that people can

receive information in their most convenient way. The main objective is to

maintain and publish data by using HTTP.

Short Message Service (SMS)

According to Clarke et. All (2014) One especially helpful way in sending a

message of e-mail is through short message (SMS) messages. SMS is a

framework that is utilized for sending short instant messages (i.e., 160

characters or less) over remote systems. Numerous cell gadgets and cell

organize bearers supports SMS. However, such providers normally charge

clients for SMS messages. In addition, such, SMS warning messages may not

be shown by remote specialized gadgets like a customary SMS instant

message, since the gadget naturally responds to such messages (i.e., surveys

for the new email messages) without including the client. Clients might be

especially disappointed with being charged for SMS messages they didn't know

they were accepting.

Barker (2015) said that 31 years ago since text message has been part of

the modern age. E-mail has a big role on how SMS evolved. The first text

message was sent by a PC on 1992 and later SMS enabled phone was

11
introduced by Nokia. 9000i Communicator a phone with a full keyboard was

produced by Finnish company on 1997. On 1999 exchanging of SMS across

networks become possible.

Middleton (2016), said that today, SMS is the most widely-used data

application in the world, with 81% of mobile phone subscribers using it.

Moreover, SMS has become more than just a way to text with friends — it also

lets us receive updates and alerts, keep track of our finances, send email, and

much more. Sierra Middleton, (Feb.17, 2016)

According to Osman and et.all (2018), A Web-based System with SMS

notifications was developed to inform information of their reservations to the

customer. The purpose of developing an SMS notification is to reduce the cost

and time consumed, which is beneficial for the client and their customer.

Lee (2018) said that the present innovation identifies with a framework for

recognizing interruption ahead of time by utilizing an SMS notification which will

be beneficial in transmitting information during emergency situations and

sending the rescue signal.

According to Fendelman (2018), Short text messages allows a message

to be sent from one cellphone to another or from the internet to a cell phone.

Sending text messages does not require a lot of money however if you don’t

have a cell service you cannot send a message. There is no notification if the

text messages being sent was received or read. There is also a limitation on the

characters about 70 to 160.

12
Electronic Mail

Carson (2014) said that in 1993 the human’s way of communicating has

been changed because of the email. The traditional way of sending letters is

through postal carriers but the introduction of email give as the fastest way of

sending letters by just clicking the send button. As time passed the email

innovates fast and most of the phones that people use have access on the

internet which has an email on it and was called smartphones. Because

smartphones is capable of receiving and sending email wherever we are.

According to Asghar (2014), there are an average of 109 billion business-

related emails last 2014 and this 2018 there are 140 billion emails. He

mentioned that many professionals have no time in reading their email,

therefore, the email should be short and key points should be put on the top.

Starr et.all (2015), sending questionnaire through email is more efficient

compared to sending it through postal because the reply on their survey is faster

and at a low cost.

Vdovin (2017) said that email is commonly used as a way of

communication in the workplace. The advantages of email are it is free and no

additional payment is required in sending and receiving a message. Sending

email is simple and quick. You can archive your email for reference, it is also

paperless. You can access files and information and can access it anywhere.

However, for the disadvantage, email has no personal touch. It can cause

13
misunderstanding and may contain viruses. Some emails might be disregard and

it needs maintenance because more messages will enter your mailbox.

Tshabitscher (2018), said that electronic mail is one of the modern ways

of communication. It replaced telephone calls in offices and other agencies. It is

a digital message and instead of using a pen a paper you used your computer or

phone in composing your message.

Tricycle

Kenneas (2014) said that in the Western world, the tricycle is any three-

wheeled vehicle. In the Philippines, it has a sidecar and other gaudy stylistic

layouts. It offers the accommodation of giving a ride to your destination like your

home. In some areas tricycle are color-coded depends on the route. Driving a

tricycle is one of the easiest ways in earning a living since purchasing a tricycle

is easy and you can even have it as an installment. They essentially change the

bike and transform it into a tricycle by including a sidecar. After processing

needed documents they can start servicing the passengers.

According to De Leon and Miguel (2015), Tricycle is the most popular

mode of transportation in the countryside.

MindaNews (2015) said that tricycle owner mostly hire a driver and the

driver needs to give the owner a fixed amount of money or commonly known as

boundary system.

14
 According to Dorado (2015), in the Philippines tricycles is one of the

commonly used modes of transportation because they can access and capable

of dropping the passengers at almost any part of the town.

Balaria (2016) said tricycle, a three-wheeled vehicle is commonly used as

transportation because jeepneys and buses are used for long travel and headed

outside the city. Residents that are residing away from the national road

depends on the tricycle to avoid walking. Driving a tricycle is one of the

alternative livelihood because owning a tricycle doesn’t require a big capital.

Rey (2018) said that in the Philippines tricycles are used as school

service of the Filipino students.

Franchising

According to Mishra (2017), Franchising is a plan of action choice. The

establishment demonstrate gives utilized development a pioneering

adaptability when the company's income is questionable.

EI Scorebook (2017) said that you need effort and it takes time at the

same time enough money to developed a franchise but all the sacrifices is worth

if your become successful. It is important to have your concept prepared before

you start with any franchisees.

15
2 Concept of the Study

Input Process Output

Data
 Violation Logbook
 Franchise Logbook Requirement
 Dropping Logbook gathering and
 Violation Payment
Analyzing
Form
 Ordinance Infraction
Ticket

Design
Hardware Requirements
 Computer

System Unit
 i3
Coding
Web-Based
 Dual Core 8g RAM Management System
with SMS and e-mail
Software Requirements Notification for Binan
 Windows 10
Testing Tricycle Franchising
 jQuery
and Regulatory Board
 Php
 Bootstrap
 Xampp
Implementation

SYSTEM EVALUATION
FEEDBACK

Figure 1 - Conceptual Framework

16
 The Conceptual Framework of the system is composed of input, process,

and output.

The input consists of all the requirements which are important in

developing the system. These requirements include the data coming from the

violation, franchise, dropping logbook and Ordinance Infraction Ticket. Web-

based application is used to input data and the processing of the information.

jQuery, PHP, and bootstrap are the tools used in developing the software. It is

uploaded to the server and will run on the specified hardware requirements.

After identifying the requirements, SDLC was used to ensure the

effectiveness and usage of the website and system.

The final product is the Web-Based Management System with SMS and

e-mail Notifications for Binan Tricycle Franchising and Regulatory Board. The

system is evaluated and modified based on the feedback given by the end users

and customers.

2.3 Definition of Terms

Bootstrap is a free and open source front-end development

framework for the creation of websites and web

apps.

BTFRB Binan Tricycle Franchising and Regulatory Board

17
Certificate of Franchise a certificate given to those who applied and

renew their franchise.

Drop of Franchise cancellation of their franchise

E-mail messages that was distributed by electronic

means from one computer user to one or more

recipients.

Franchise is a type of license that a party (franchisee)

acquires to allow them to have access to a

business's (the franchiser) proprietary

knowledge, processes, and trademarks in order

to allow the party to sell a product or provide a

service under the business's name.

Functionality An aspect of what a software application can do

for a user.

Hardware It is the physical aspects of computers such as

monitor, keyboard

Maintainability is the capability of the software product to be

modified. Modifications may include corrections,

improvements or adaptation of the software to

changes in environment, and in requirements

and functional specifications.

Module a separate unit or structure in the system that is

combined in a program.

18
Portability A set of attributes that bear on the ability of

software to be transferred from one

environment to another.

Reliability A set of attributes that bear on the capability of

software to maintain its level of performance

under stated conditions for a stated period.

SMS stands for Short Message Service and is also

commonly referred to as a "text message."

Usability is the capacity of the software product to be

understood, learned, used and attractive to the

user when used under a specified condition.

TODA Tricycle Operators and Drivers’ Association

Transfer of Franchise transferring of franchise from one operator to

other operator or from one tricycle to another

tricycle.

Violation an act of breaking the law

Violators the person who breaks the law

19
 CHAPTER 3
OPERATIONAL FRAMEWORK

3.1 Materials

3.1.1 Software

The proponents used the following software based on Windows 10

Operating System. Mysql is used as the storage of all the data. A browser

such as Chrome, Mozilla and Internet Explorer is a tool used to see the

output of the program, and for the Web Server, the Apache is more

appropriate for the PHP coding.

3.1.2 Hardware

To develop the system, some hardware requirements are needed.

A desktop or laptop with the at least i3 processor is required with

4Gigabytes of RAM.

3.1.3 Data

The proponents refer to the current logbook being used at the

BTFRB such as Logbook for Franchise, Logbook for Dropping, Logbook

for Violation and Ordinance Infraction Ticket.

20
 Figure 2 - Franchising Logbook
The Franchising Logbook is used in recording the approved tricycle

Franchise. It includes the name of the franchisee, TODA membership, date of

approval, assigned body number of the tricycle and ticket number. Once the

certificate is issued it will be received by the tricycle operator.

Figure 3 - Dropping Logbook

21
 The Dropping Logbook is used in recording the approved dropping such

as transfer of TODA, Change from Hire to Private, Change of Ownership and

transfer

Figure 4 - Violation Logbook

The Violation Logbook is where all the violations is recorded. Payment is

also recorded in this logbook.

22
 Figure 5 - Ordinance Infraction Ticket
The Ordinance Infraction Ticket is issued by the enforcer to the tricycle

driver who violate the traffic law in Binan.

3.2 Methods

3.2.1 Experimental design

The proponents used the System Development Life Cycle or

SDLC. There are different stages or phases and each phase have

different activities take place.

SDLC creates a structure for the researchers to be able to design,

create and deliver high-quality software by defining various tasks that

need to happen. SDLC process additionally creates a product that is cost-

proficient, impressive and of high quality.

23
 SDLC models portray periods of the product cycle and the request

in which those stages are executed. Each stage produces deliverable

required by the next phase in the life cycle. Requirements are translated

into design. The code is produced according to the design which is called

development phase. After coding and development, the testing verifies

the deliverable of the implementation phase of requirements.

Figure 2 illustrates the steps carried out in the SDLC model. These

steps are listed below.

24
 Figure 6 - SDLC Model

3.2.2 Procedure for the different phases

Requirement Gathering and Analysis Phase

In this phase, the proponents conducted an interview with Mr. Ronaldo

Roscain, City Community Affair Officer of Binan and other users to gather

needed data such as the user of the system, how it will be used and how long it

will take for the development of the system. These are the general quires that

will be addressed during requirements gathering phase. The researcher started

to define the requirements. The software and hardware technology to be used

were identified.

Table 1 - Interview Questionnaire

INTERVIEW QUESTIONS ANSWER

25
Describe your current process.
Scale the efficiency of your business
process. (1 to 6, 1 is poor and 6 is
excellent).
Would you still want to improve the current
process in your department? (If yes,
please specify the improvement you
want).
Do you encounter problems in the current
business flow? (If yes, please specify.)
Do you have computer access?
How long does it take to finish one
transaction?
What are the requirements needed for a
franchise?
How long do you keep the records?

Design Phase

In this phase, the proponents will design a system based on the required

specification of the client. The system architecture design is presented. This

includes the important aspects of the system which will give an idea of the

system to the user. It will help to develop the system faster and easier.

In table 2 and table 3, are hardware and software specifications of the

proposed project.

Table 2 - Hardware Specifications

Hardware Specifications
Item Name Description
Desktop computers/ Laptop At least i3 processor
Memory 4GB

26
Video Card
Keyboard USB, optical mouse
Mouse USB, optical
Monitor LED, at least 15’
Table 3 - Software Specifications
Software Specifications
Item Name Description
Operating System Windows 10
Web Server Apache
Database Server MySQL
Browser Chrome/Mozilla/IE

Current Process Flow

27
 Figure 7 - Existing Process Flow

The figure above shows the current process flow of BTFRB. All transactions

are manual and recording and keeping of record is thru logbook only.

Design of the Study

28
 Figure 8 - System Architecture

The figure above shows the different components of Web-Based

Management System for BTFRB. There will be users like the Administrator, who

administer users account, can access all the module in the system. Franchising

Manager who handle the application, renewal and updating of franchise and print

the certificate once application is approved. Requirement Checker who checks

the requirements submitted and manage the sending of e-mail or SMS once the

requirement is correct and complete. Violation manager who administer the

updating of violations and payment. Enforcer Module that handles violators

apprehend. Client Module that handles the client applications and inquiries.

Network Design Infrastructure

29
 Figure 9 - Network Design Infrastructure

The figure above shows the network design infrastructure of Web-Based

Management System for Binan Tricycle and Franchising Regulatory Board.

There is only one server that caters all the system of the BTFRB. This server

caters the proposed system which will be used for tricycle franchise and the

violations monitoring. Most of the borrower is using Google Chrome and Mozilla

Firefox as their internet browser running in Windows 10. Most of the hardware

components used are i3 models.

Database Schema

30
 This figure shows the database design of the proposed system. The

database and is consists of 9 tables.

Figure 10 - Database Schema

31
 Figure 11 - Use Case Diagram for Admin Side

Upon log-in, Admin can access the Franchising Module, Violations

Module, can generate reports, can manage account and access the Audit trail.

32
 Figure 12 - Use Case Diagram Franchising Manager Module

This Franchising Manager module will help the requirement checker to

easily check the requirements and for the franchising manager to easily

approved all the application for renewal and updating of franchise. It will help

also to easily check and monitor all registered motorcycle and TODA in Binan.

Reports are also available and it can also manage the accounts of the clients.

33
 Figure 13 - Use Case Diagram Violation Manager Module

The Violation Manager Module can easily monitor the violations

committed and easily update the payment of the violators, updating of violations

and generation of report for the list of all the violators is also available.

34
 Figure 14 - Use Case Diagram Enforcer Module

This module will help the enforcer monitor the violators they apprehended.

Figure 15 - Use Case Diagram Client Module

35
 This module will help their client to apply for the renewal and updating of

their franchise. They can easily monitor the status and check if they committed a

violations.

Coding Phase

In this phase, the proponents will start coding according to the

requirements and the design needed by BTFRB. The proponents use jQuery for

the functionality of the system, Php for the database and bootstrap for designing

the system.

Testing Phase

After the code is developed, the proponents will test if the requirements

are being met. This is to make sure the program is complying based on the

requirements address during data gathering and analysis phase. In this phase,

all types of functional testing like, integration testing, system testing and

acceptance testing were done.

Unit Testing

During this first round of testing, the software will be tested where

individual units components of the software are tested. The objective of this

phase is to check if the software designed meet the system requirements. The

White Box Testing Method is used in performing unit testing which is performed

by the developers or their peers. One of the biggest benefits of this testing phase

is that it can be run every time a piece of code is changed, allowing issues to be

resolved as quickly as possible.

36
Integration Testing

Integration testing is a phase in which individual software modules are

combined allows individuals the opportunity to combine all of the units within a

program and test them as a group. This testing can expose problems with the

interfaces among program components before trouble occurs in real-world

program execution. Integration testing is done by a specific integration tester or

test team.

System Testing

System testing is a level of the software testing where a complete and

integrated software is tested and meets specified requirements. The purpose is

to evaluate the system’s compliance with the specified requirements and to

detect any inconsistencies between the software units they are integrated

together with the hardware.

Acceptance Testing

Acceptance Testing is a level of the software testing where a system is

tested for acceptability. The purpose of this phase is to evaluate the system’s

compliance with the business requirements and assess whether it is acceptable

to the end user. During this phase, the user will test the software to determine

whether or not a system satisfies the acceptance criteria. Once this process has

37
been completed and the software has passed, the program will then be

endorsed by the end-user.

Software Test Plan Flow

Figure 16 - Software Test Plan

Test Specification is detailed summary if what scenarios will be tested,

how they will be tested and how often they will be tested. Different types of

software testing are performed depending on the size of the project, the current

project phase, and the amount of progress made in the coding process. Types of

testing include Unit testing may also be known as module testing and is used to

test small parts of code such as functions and modules. Programmers should

test each module to be sure it performs as intended, Integration testing that will

test the interfaces between modules; System integration testing is performed

when the system needs to interface with other or third-party systems. The testing

tests against the system requirements specification for interfaces to other

systems. Acceptance testing is a testing by the customer or end user to

determine whether the software is acceptable. In test code, you will be able to

see what module is needed to fix or revise after the execution and to review

those test results.

38
 Table 4 Test Matrix

MODULES TEST TYPE

Admin Side Integration Testing / System Testing
Franchising Manager Side Integration Testing / System Testing
Document Checker Side Integration Testing / System Testing
Violation Manager Side System Testing
Enforcer Side System Testing
Client Side System Testing

In the test plan, the system will undergo testing to know if the system is

working well.

Below is the test plan of each module

Table 5 Admin Module

Test ID 1
Test Name Admin Side
Description Ensure that components pass unit and integration
testing, and perform basic operations as expected.
Pre-requisite None
Test Environment Acceptance Server
Test Strategy Integration Testing /System Testing

Admin Side
Step Descriptions Expected Results
1 Open the Web-based The Web Page displays correctly
Management System in web
browser.
2 Log-in Admin Account The application will accept and display
admin account page.
3 View Module in the system All the module in the system will be
viewed.
4 Manage Account The admin can add, edit and delete
account.
5 View Audit Trail The admin can view the logs on the
audit trail.

39
 Table 6 Franchising Manager Module
Test ID 1
Test Name Franchising Manager Module Side
Description Ensure that components pass unit and integration
testing, and perform basic operations as expected.
Pre-requisite None
Test Environment Acceptance Server
Test Strategy Integration Testing / System Testing

Franchising Manager Webpage

Step Descriptions Expected Results
1. Open the Web-based The Web Page displays correctly
Management System in web
browser.
2. Log-in Franchising Manager The application will accept and display
Account franchising manager account page.
3. Manage Franchise The page can accept new franchise,
update and delete franchise.

4. Manage Requirements The page can download the uploaded

requirements by the client. It can also
approved and send SMS and e-mail
notification to the client.
5. Motorcycle Information The page accepts the additional
motorcycle information, can also
update and delete motorcycle
information.
6. TODA Information The page accepts the additional TODA,
update and delete TODA.
7. Generate Reports The page can generate the franchise
and drop certificates.
8. Accounts The page can create new account,
update and delete existing account of
the client.

Table 7 Violation Manager Module

Test ID 1
Test Name Violation Manager Module Side
Description Ensure that components pass unit and integration
testing, and perform basic operations as expected.

40
Pre-requisite None
Test Environment Integration Testing /Acceptance Server
Test Strategy System Testing

Violation Manager Webpage

Step Descriptions Expected Results
1 Open the Web-based The Web Page displays correctly
Management System in web
browser.
2 Log-in Violation Manager The application will accept and display
Account violation manager account page.
3 Manage Penalties The page can accept new penalty,
update and delete penalty.
4 Manage Violations The page accepts new violation, can
also update and delete existing
violation.
5 Generate Reports The page can view list of issued tickets
and can generate the violation
information.

Table 8 Enforcer Module

Test ID 1
Test Name Enforcer Module Side
Description Ensure that components pass unit and integration
testing, and perform basic operations as expected.
Pre-requisite None
Test Environment Acceptance Server
Test Strategy System Testing

Enforcer Webpage
Step Descriptions Expected Results
1 Open the Web-based The Web Page displays correctly
Management System in web
browser.
2 Log-in enforcer Account The application will accept and display
enforcer account page.
3 View Incentive The page will show the total violation
apprehended by the enforcer.

41
 Table 9 Client Module
Test ID 1
Test Name Enforcer Module Side
Description Ensure that components pass unit and integration
testing, and perform basic operations as expected.
Pre-requisite None
Test Environment Acceptance Server
Test Strategy System Testing

Client Webpage
Step Descriptions Expected Results
1 Open the Web-based The Web Page displays correctly
Management System in web
browser.
2 Log-in client Account The application will accept and display
client account page.
3 Drop Franchise The application will accept the changes
in franchise such as from hire to
private, change ownership, change of
TODA and transfer.
4. Check Violation The application will show the violation
of the client.

Operating Procedures

This is a step by step system instruction gathered to carry out the operating

procedure for Web-based Management System for BTFRB. The purpose is to

solve the dilemma encountering by the Institutions and their clients. Below are

the different operating procedures of each Module that indicates the system and

work instructions.

42
 Table 10 - Admin Module

MODULE: ADMIN

Process Work Instructions

The admin will log in the web page

It will display all the modules in the

system that is accessible by the
admin

If Franchising module was selected

the transactions for franchising will
be displayed.

For Violation module it displays the

all transactions regarding violations.

Reports will be generated based on

your selected transactions.

At the Accounts you can create

accounts and updated or delete the
existing accounts

Audit trails show or monitor all the

updates or changes made on the
web page.

43
Table 11 - Franchising Manger Procedure

44
 MODULE: FRANCHISING MANAGER

Process Work Instructions

Franchising Manger will

login on the web page.

Manage requirements can

check and approve the
uploaded requirements by
the client.

If the requirement is correct

or completed the
requirement checker will
approved the requirement
and SMS or e-mail
notification will be sent to
the client stating the
schedule of inspection.

However if the requirements

is incomplete it will be
denied and SMS or e-mail
notification will be sent to
the client stating that the
client application had been
denied.

Manage Franchises can add

new franchise, update and
delete the existing
franchises.

Manage account is where

you can update or add
account for the client.

Generate Report generates

the Certification of franchise
which will be signed the
officer of BTFRB. It also
generates the list of all
dropped franchise.
Table 12 - Violation Manager Procedure

45
 MODULE: VIOLATION MANAGER

Process Work Instructions

Violation Manager will login

on the web page.

In Manage Penalties it can

add new violators and can
update or delete the existing
violators. You can also
update the payment made
by the violators.

For Manage Violations this

will add new violation and
update or delete the existing
violations.

In the Generate Report you

can generate the list of all
Issued tickets with the
status.

Table 13 - Enforcer Procedure

46
 MODULE: ENFORCER

Process Work Instructions

Enforcer will login on the

web page.

In View Incentive he can

view all the violations he
apprehended.

Table 14 - Client Procedure

MODULE: CLIENT

47
 Process Work Instructions

Client will login on the web

page.

In Renew Franchise the

client may renew his
expired franchise.

Drop franchise will allow the

client to update his
franchise.

Check violation will help the

client to check if he has
unsettled violations.

Deployment Phase

For this phase, the proponents will ensure that the application will perform
correctly. Training will be conducted to make sure that the user is familiar with
the system. Once the system has been fully tested and no issues found, the

48
proponents will endorse the system to their client, where they can use the
system in the live environment.

Maintenance Phase

In this stage of maintenance, a corrective and adaptive maintenance will

be applied. During the operation of BTFRB, they may encounter problems that

need to be solved from time to time or maintenance for new technology and

bigger demands. Database backup is also a part of the maintenance.

3.2.3 Evaluation

After the testing strategies have been conducted, Web-based

Management System with SMS and e-mail Notification for Binan Tricycle and

Franchising Regulatory Board will be evaluated based on the ISO 9126. The

standard presents some set of quality attributes for any software such as

functionality, reliability, usability, efficiency, maintainability, and portability. The

proponents will set a method to rate the application that they have developed.

(1) Functionality- The software features will be checked if they are all working

correctly.

(2) Reliability- The software’s fault tolerance and the chance of recoverable

are high; it will not crash.

(3) Usability- The application can easily be understood and navigated by the

end-users. The design and images to be used are easy to recognize.

49
 (4) Efficiency- The system responds precisely and efficiently to the

commands. It uses resources such as memory, the CPU, and the

network.

(5) Maintainability- The software is easy to maintain, and it is stable.

(6) Portability- The software can be used and run in different web browsers’

versions and screen resolutions. It does not require vital programs that

are hard to install.

These characteristics were rated by the respondents using the 5-point

Likert scale the developers used this method to rate the application that they

developed.

Table 15 Likert Scale

Scale Range Interpretation
5 4.6 - 5.0 Strongly Agree
4 3.7 - 4.5 Agree
3 2.8 - 3.6 Neither agree nor disagree
2 1.9 - 2.7 Disagree
1 1.0 - 1.8 Strongly Disagree

On the other hand, the statistical treatments for this study are frequency

and percentage distributions for data presentation and weighted mean to

determine the results of the software evaluation. Below is the evaluation criteria

used by the proponent.

Software Evaluation Criteria

Direction:
Check the box that corresponds to your answer. Use the legend as your guide.

50
LEGEND: 5 - Strongly Agree 4 - Agree 3 - Neutral
2 - Disagree 1- Strongly Disagree

Table 16 Software Evaluation Criteria

Ratings
Criteria Indicators
5 4 3
Functionality The website performs all the functions required.
The website shows the output as it intended to be.
The website prevents unauthorized access.
The website can automatically send SMS and e-mail
notification that the application was approved.
Most of the faults in the website been eliminated over
Reliability
time.
The website is capable of handling errors.
The website responded faster in terms of user
interaction and performance.
Usability The website is user-friendly
The user learns to use the system easily.
The user uses the website without much effort.
The user uses the website without problems.
Efficiency The website responds quickly.
The website efficiently utilizes resources.
The website minimizes the time required in
processing documents.
Maintainability Faults are easily diagnosed.
The website can be easily maintained.
The website continues functioning if changes are
made.
There is no problem encoutered during user testing
Portability The website can be accessed online
The website can run in different web browers'
versions and resolutions
The website is easy to use and navigate

Chapter 4

RESULTS AND DISCUSSION

51
4.1 Results by Phase of Study

In this modern age, technologies have changed people’s lives and still

changing people’s lifestyle. Internet is this modern age can be access easily by

most of the people. Thus, the proponents decided to developed a web based

management system that will accept online renewal and updating of franchise,

updating and additions of violators and violations. The admin part of the system

will manage the user’s registration on the system. The violation manager will

handle all the transactions related to the violations, while the franchising

manager will handle all the transactions related to registration, renewal and

updating of franchise. The project focuses only on the transactions for Binan

Tricycle Franchising and Regulatory Board (BTFRB).

The first objective of the study is to develop a system that is accessible to

BTFRB and it’s client.

52
 Figure 17- Home Page of the System
The figure above shows the home page of the system once access in the

internet.

Figure 18 - Log-in Page

The figure above shows the log-in page of the member.

53
 Figure 19 - Sign-up Page

The figure above shows the Sign-up Page for those who doesn’t have

existing account. Here the e-mail address will be verified.

Figure 20 - E-mail verification

The figure above shows that e-mail should be verified upon registration on

the system.

54
 The second objective of the study is to design a module that will manage

franchise such as.

a) Application for new, renewal and updating of franchise.

Figure 21 - Application for New Franchise

The figure above shows the application form for new registration of

franchise. Once submitted, this will be automatically sent to the Requirements

Checker for verification.

Figure 22 - Application for Renewal or Updating of franchise

55
 The figure above shows the application form for the renewal and updating

of franchise. Once submitted, this will be automatically sent to the Requirements

Checker for verification.

b) Approval of Applied Franchise

Figure 23 Approval of Applied Franchise

The figure above shows wherein all pending for approval is listed.

Requirement Checker can verify the application, by clicking on the items.

56
 The third objective of the study is to design a module that can Manage

Violations such as.

a. Can add, update and delete violations and violators.

Figure 24 - Manage Penalties

The figure above shows wherein all violators is listed and the status of

their violations.

Figure 25 - Add Penalties

57
 ‘

The figure above shows wherein the Violation Manager can input the

penalties occurred by referring to the issued ticket of the enforcer.

Figure 26 - Delete, Update Payment and Update Penalty

The figure above shows wherein the Violation Manager delete the

violators, update payment by in-putting the amount paid by referring on the OR

as proof of payment and can also update the penalty.

58
 Figure 27- Add Violations

The figure above shows wherein the Violation Manager add violations.

Figure 28 - Delete and Update Violations

59
 The figure above shows wherein the Violation Manager delete violations if

no longer existing and can update violation for any changes in coverage or in

penalty fee.

b. Check Violations

Figure 29 - Check Violations

The figure above shows wherein the operators can view their committed

violation including the penalties that they need to pay.

The fourth objective of the study is to design a module that will not allow

tricycle operators to renew or update their franchise if they have existing

violation.

60
 Figure 30 - Message Box for Unsettled Violation

The figure above shows that the tricycle operator cannot proceed with the

updating or renewal of his account since he has a unsettled violation.

61
 The fifth objective of the study is to design a module that will automatically
sends SMS and e-mail notification once the request is approved.

a. SMS Notification’

Figure 31 SMS Notification

The figure above shows the auto SMS notification received by the client. It
informs the schedule for inspections.

b. E-mail Notification

62
 Figure 32 e-mail Notification
The figure above shows the auto e-mail notification received by the client.
It informs the schedule for inspections.

The sixth objective of the study is to design a module that will generate
reports such as.

a. Audit Trail

Figure 33 Audit Trail

63
 The figure above shows all the transaction done in the system. This is

only accessible by the Admin. It shows the date, action taken, description of the

transaction and the user of the system.

b. Penalty Reference

Figure 34 Penalty Reference

The figure above shows that it can generate List of Issued Tickets.

64
 c. Apprehension Incentives

Figure 35 Apprehension Incentives

The figure above shows that it can view the List of Apprehensions.

d. Apprehension Status

Figure 36 Apprehension Status

65
 The figure above shows that it can generate report for the Apprehension
Status.

Figure 37 Generated Report for Apprehension Status

The figure above shows the sample report.

66
 Figure 38 Generated Report for Violation Occurrence

The figure above shows report for Violation Occurrence. You can select if
the report is in monthly or yearly basis.

67
 Figure 39 Franchise Status

The figure above shows that it can generates reports for the Status of
Franchise.

68
 Figure 40 Generated Report for Franchise Status
The figure above shows the sample report.

Figure 41 Franchise Certificate

The figure above shows that it can generate Franchise Certificates

69
 Figure 42 Printable Certificate of Franchise
The figure above shows that it can generate printable Certificate of
Franchise.

Figure 43 Drop Certificate

The figure above shows that it can generate Drop Certificates

70
 Figure 44 Printable Certificate of Drop

The figure above shows that it can generate printable Certificate of

Dropping.

4.2 Verification studies

Software Evaluation Using ISO9126

The study is to evaluate the acceptability of the system using the

ISO9126, which is the software product evaluation standard from the

International Organization for Standardization.

These characteristics were rated by the respondents using the 5-point

Likert scale as shown in below.

71
 Table 15 - Likert Scale

Scale Range Interpretation

5 4.6 - 5.0 Strongly Agree
4 3.7 - 4.5 Agree
3 2.8 - 3.6 Neutral (Neither agree nor disagree)
2 1.9 - 2.7 Disagree
1 1.0 - 1.8 Strongly Disagree

On the other hand, the statistical treatments for this study were frequency

and percentage distributions for data presentation and weighted mean to

determine the results of the software evaluation. Below is the evaluation criteria

used by the proponent.

Our Dear Respondents,

72
 Undersigned are 3rd year B.S.I.T. students of TRIMEX COLLEGES (formerly Trimex Institute

of Science and Technology), currently taking on our study entitled “WEB-BASED

MANAGEMENT SYSTEM FOR BINAN TRICYCLE FRANCHISING AND REGULATORY

BOARD”. Answer on the statement below are material on our program. Please put a check on

the space provided for your preferred answer. Rest Assured that the same will be treated with

utmost confidentiality.

Thank you.

Ryan Pintucan and Erica Sere

Software Evaluation Criteria

Name (Optional):___________________ Signature:________________

LEGEND: 5 - Strongly Agree 4 - Agree 3 - Neutral 2 - Disagree 1 - Strongly Disagree

Table 16 Software Evaluation Criteria

Table 17 Evaluation for Functionality Criterion

73
 Functionality
Weighted
Indicators
Mean

The website performs all the functions required. 4.8

The website shows the output as it intended to

4.7
be.
The website prevents unauthorized access. 4.8
The website can automatically send SMS and e-
mail notification that the application wsa 4.8
approved
Average 4.8

The total

weighted mean of 4.8 for the functionality of the system was distributed

accordingly. Among the 50 responses, 39 of them Strongly Agreed that the

module response functionality is truly functional and visible. However, 10 of the

respondents cast their Agreed situation and 1 respondents is neither Agree nor

Disagree.

Table 18 Evaluation for Reliability Criterion

Reliability
Weighted
Indicators
Mean
Most of the faults in the website been eliminated
4.7
over time.
The website is capable of handling errors. 4.6
The website responded faster in terms of user
4.6
interaction and performance.
Average 4.7

74
 In terms of Evaluation in Reliability, it has a mean of 4.7 with a

interpretation of Strongly Agree. The web based application was able to handle

errors and respond faster to its user.

Table 19 Evaluation for Usability Criterion

Usability
Weighted
Indicators
Mean

The website is user-friendly 4.8

The user learns to use the website easily. 4.8

The user uses the website without much effort. 4.7
The user uses the website without problems. 4.7
Average 4.8

In terms of

Evaluation in Usability, it has a mean of 4.8 with a interpretation of Strongly

Agree. The web based application was user friendly and can be used by the user

easily.

Table 20 Evaluation for Efficiency Criterion

Efficiency
Weighted
Indicators
Mean

The website responds quickly. 4.6

The website efficiently utilizes resources. 4.6

The website minimizes the time required in
4.6
processing documents.
Average 4.6

75
 In terms of Evaluation in Efficiency, it has a mean of 4.6 with a

interpretation of Strongly Agree. The web based application minimizes the time

required in processing the documents. However poor network connection may

affect the efficiency of the website.

Table 21 Evaluation for Maintainability Criterion

Maintainability
Weighted
Indicators
Mean

Faults are easily diagnosed. 4.5

The website can be easily maintained. 4.7

The website continues functioning if changes are
4.6
made.
There is no problem encountered during user
4.5
testing
Average 4.6

In terms of Evaluation in Maintainability, it has a mean of 4.6 with a

interpretation of Strongly Agree. It means that the website can be easily

maintained and manageable.

76
 Table 22 Evaluation for Portability Criterion

Portability
Weighted
Indicators
Mean

The website can be accessed online 4.8

The website can run in different web browers'

4.8
versions and resolutions
The website is easy to use and navigate 4.8
Average 4.8

In terms of Evaluation in Portability, it has a mean of 4.8 with a

interpretation of Strongly Agree. It means that the website can be accessed

online and easy to use and navigate by the user.

Table 23 Summary of Software Evaluation Overall Mean Scores

Indicators Weighted Mean Interpretation

Functionality 4.8 Highly Acceptable

Reliability 4.7 Highly Acceptable
Usability 4.8 Highly Acceptable
Efficiency 4.6 Highly Acceptable
Maintainability 4.6 Highly Acceptable
Portability 4.8 Highly Acceptable
Average 4.7 Highly Acceptable

77
 In general, the software yielded a total weighted mean of 4.5 which fall on

the Highly Acceptable in the Linkert’s scale. Functionality and Portability got the

highest with 4.6 weighted mean. It means that the system can be access online

and the system is functional and visible. Next is Usability with a mean of 4.5 , it

means that the user found the system user friendly. Last is, Efficiency,

Maintainability and Reliability at 4.4 mean. It means that the resources of the

website satisfies the user and it it easily maintained.

Chapter 5

78
 SUMMARY, CONCLUSIONS AND RECOMMENDATIONS

This chapter presents the summary of findings, conclusions and

recommendation of the study.

5.1 Summary

Web-Based Management System with SMS and e-mail notification for Binan

Tricycle Franchising and Regulatory Board is a website that gives tricycle

operators of Binan a convenience in renewing and updating their franchise. It

also helps them to know the amount of violation they incurred. For the

management side, it will help them to easily manage and monitor the

applications and the violations of the tricycle operators.

Based on the survey conducted, the website is the best way to help the

BTFRB on the problems they are encountering. The website provides services

such as; management page and a client page which allows them to easily

manage the daily transactions of this government agency.

5.2 Conclusion

Based on the aims of the study and the results of the evaluation the

following conclusions were drawn;

1) Web-Based Management System with SMS and e-mail Notification of Binan

Tricycle Franchising and Regulatory Board is now accessible using internet

browser, both for the BTFRB and its clients.

79
2) The website allows their clients to apply for the renewal and updating of their

franchise. The implementation of this website allows their clients to save

time during the application of their franchise.

3) The system helps the management to easily monitors the violators thus it will

help them to save time and process the application easily.

4) The system helps the management to easily check those with unsettled

violations and will not be allowed to renew their franchise.

5) The system automatically send SMS and e-mail notification to the applicant

once their application is approved.

6) Generating reports with the help of internet browsers is convenient and

flexible for printing Violations, Certificates, Audit Trail and other related

reports.

5.3 Recommendations

After the successful development of Web-Based Management System

with SMS and e-mail Notification for Binan Tricycle Franchising and Regulatory

Board, the following are the observed recommendations:

1) To include a chat feature for the online active guests

2) To have an online payment for the violations incurred.

3) To have an android version in order to have a multi-platform of the system.

4) To include a ticketing module that will record the violation directly to the

system.

80
5) The system might be useful to other government franchising agencies

especially for those who want to adopt the system.

81