POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

San Juan Campus

Brgy. Addition Hills, San Juan City, Metro Manila

Online Scheduling,
Sales and Inventory System
In partial fulfillment of the requirements for
INTE 4213 – Capstone Project

Proponents:
Mañago, Ian Rizh F.
Balingit, Weenalie
Espinoza, Marita B.
Gabayne, Princess May C.
Malacad, Jona Mae G.
Zorilla, Jan Pauline O.

Submitted to:
Prof. Ely Austria
Instructor

September 24, 2018

Page | 1
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
Table of Contents
Chapter 1 ......................................................................................................................................... 5
Introduction ..................................................................................................................................... 5
1.1 Project Context.................................................................................................................................... 5
1.2 Technical Background ........................................................................................................................ 6
1.2.1 Equipment / Hardware ................................................................................................................. 6
1.2.2 Software ....................................................................................................................................... 6
1.2.3 Peopleware / Manpower............................................................................................................... 6
1.2.4 Network Infrastructure / Architecture .......................................................................................... 7
1.2.5 Storage, Backup and Recovery Procedure ................................................................................... 7
1.2.6 Security Procedures...................................................................................................................... 7
1.2.7 Policies and Procedures ............................................................................................................... 8
Business Rules ...................................................................................................................................... 8
Context Diagram ................................................................................................................................... 8
Data Flow Diagram ............................................................................................................................... 9
1.3 Problem Analysis .............................................................................................................................. 10
1.3.1 Fishbone Diagram ...................................................................................................................... 10
1.3.2 Problem and Solution Statement ................................................................................................ 10
1.3.5 Specific Objectives .................................................................................................................... 11
1.3.6 Scope and Limitations ................................................................................................................ 12
Chapter 2 ....................................................................................................................................... 13
Reviews of Related Literatures and Systems ................................................................................ 13
Chapter 3 ....................................................................................................................................... 16
Methodology ................................................................................................................................. 16
3.1 Requirements Analysis ..................................................................................................................... 16
3.1.1 Requirements Feature Matrix..................................................................................................... 16
3.1.2 Use Case Diagram...................................................................................................................... 17
3.1.2.1 Use Case per Module .............................................................................................................. 18
3.1.2.2 Use Case Report ...................................................................................................................... 20
3.2 Design Specifications........................................................................................................................ 23
3.2.1 Activity Diagram........................................................................................................................ 23
3.2.2 Class Diagram ............................................................................................................................ 28
3.2.3 GUI Design ................................................................................................................................ 29
3.2.4 Database Schema ....................................................................................................................... 32

Page | 2
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
3.2.5 Data Dictionary .......................................................................................................................... 33
3.3 Development Methodology .............................................................................................................. 35
3.3.1 Process Model ............................................................................................................................ 35
3.3.2 Development Tools .................................................................................................................... 36
References ............................................................................................................................................... 37

Lists of Figures
Figure 1: Organizational Chart ..................................................................................................................... 6
Figure 2: Context Diagram ........................................................................................................................... 8
Figure 3: Data Flow Diagram ....................................................................................................................... 9
Figure 4: Fishbone Diagram ....................................................................................................................... 10
Figure 5: Use Case Diagram ....................................................................................................................... 17
Figure 6: Per Use Case Online Product Ordering ....................................................................................... 18
Figure 7: Per Use Case Online Registration (Log-in Module) ................................................................... 18
Figure 8: Per Use Case Walk-ins Reservation System ............................................................................... 19
Figure 9: Per Use Case Online Reservation / Scheduling ........................................................................... 19
Figure 10: Per Use Case Point of Sales....................................................................................................... 20
Figure 11: Activity Diagram_ Transactions (Online Ordering) .................................................................. 23
Figure 12: Activity Diagram_ Log in ......................................................................................................... 24
Figure 13: Activity Diagram_ Sign in......................................................................................................... 24
Figure 14: Activity Diagram_Pet Registration (After customer login)....................................................... 24
Figure 15: Activity Diagram_ Online Scheduling / Reservation ................................................................ 25
Figure 16: Activity Diagram_Sales Invoice................................................................................................ 26
Figure 17: Activity Diagram_Purchase Products to Supplier ..................................................................... 26
Figure 18: Activity Diagram_Generating Reports ...................................................................................... 27
Figure 19: Class Diagram ........................................................................... Error! Bookmark not defined.
Figure 20 Appointment link for user customer ........................................................................................... 29
Figure 21 Veterinarian Profile .................................................................................................................... 29
Figure 22 Veterinarian Information ............................................................................................................ 29
Figure 23 Set Appointment ......................................................................................................................... 30
Figure 24 Date Added Preview ................................................................................................................... 30
Figure 25 Customer's information .............................................................................................................. 30
Figure 26 Appointments' List...................................................................................................................... 31
Figure 27 Veterinarian’s account ................................................................................................................ 31
Figure 28 Adding appointment ................................................................................................................... 31
Figure 29 Home User Interface................................................................................................................... 32
Figure 30: Database Schema ....................................................................................................................... 32

Page | 3
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
Lists of Tables
Table 1: Equipment / Hardware of Company ............................................................................................... 6
Table 2: Manpower Hierarchy / Roles .......................................................................................................... 7
Table 3: Problem-Requirements Matrix ..................................................................................................... 11
Table 4: Requirement-Feature Matrix......................................................................................................... 16
Table 5: Online Ordering System Use Case Report_Customer and Staff................................................... 20
Table 6: Log-in Module Use Case Report_Admin and Customer .............................................................. 21
Table 7: Walk-in Reservation System Use Case Report_Customer and Staff ............................................ 21
Table 8: Online Reservation System Use Case Report_Customer and Staff .............................................. 21
Table 9: Point of Sale Use Case Report_Customer and Staff ..................................................................... 22
Table 10: Orders ......................................................................................................................................... 33
Table 11: Order Details ............................................................................................................................... 33
Table 12: User Type.................................................................................................................................... 33
Table 13: User List...................................................................................................................................... 33
Table 14: Pet ............................................................................................................................................... 33
Table 15: Veterinarian ................................................................................................................................ 34
Table 16:Pet Status ..................................................................................................................................... 34
Table 17: Pet Supplies ................................................................................................................................ 34
Table 18: Pet Category................................................................................................................................ 34
Table 19: Appointment ............................................................................................................................... 34
Table 20: User ............................................................................................................................................. 35
Table 21: Comment..................................................................................................................................... 35
Table 22: Review ........................................................................................................................................ 35
Table 23: Work Done in every Phase of Prototyping Methodology ........................................................... 36

Page | 4
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
Chapter 1
Introduction
1.1 Project Context

In business industries, time is one of the most important elements to consider. For them, “Time is
money”. That is why every business company has their own method to save time while increasing profit
as effectively as possible. And modern technology plays a great role in this saving-time-increasing-profit
process because of internet.
The two subsystems of this study are online scheduling or online reservation and online ordering
system. These online systems will enable stakeholders of Stella’s Animal Clinic to act or do online
transactions, which is being used by many business-competing companies such as hotels, airlines and the
likes, to make business operation a lot easier. Since online transactions, with the help of internet make it
possible to be available anytime, anywhere. The first subsystem is the online scheduling or reservation
system, which helps both customer and the company to manage appointments efficiently. And the second
subsystem; online ordering, used e-commerce which enable customers to purchase products and services
online.
Stella’s Animal Clinic is the company that the researchers expect in the future to benefit this
proposed study. This company is a Veterinary clinic, a grooming center and a store with a bunch of
products available for pets, the company is owned by Dr. Andrea Capistrano, while the company’s clinic
manager is Mrs. Amabel Capistrano, Dr. Andrea’s mother. Furthermore, Dr. Capistrano said that,
“Because I am a licensed Veterinarian and I love dogs and cats, and the name Stella is actually the name
of my pet cat.” that’s why she decided to build the Stella’s Animal Clinic and because of that reason, the
company gives pet services in the most authentic way since 2013 at Unit 25 Emerald Complex, P. Tuazon
Blvd, Project 4, Lungsod Quezon, kalakhang Mayila. And a year after (2014) Stella’s Animal Clinic
opened its first branch in Tiendesitas Pet Village at Ortigas Avenue Cor. E. Rodriguez Ave Pasig , Metro
Manila.
When the main Stella’s Animal Clinic in Quezon started their business year 2013, as a humble
start, the company uses the traditional monitoring of products and sales, scheduling appointments and
process of handling records from transactions and other important papers. As a minor problem, the owner
of the company found it difficult when it comes of human error. Lastly, Stella’s Animal Clinic aims to
equip itself with latest materials and facilities to fill the services needed by their customers in the most
convenient way for both staff and customers.

Page | 5
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
1.2 Technical Background
1.2.1 Equipment / Hardware
These are the equipment or hardware used by Stella’s Animal Clinic in terms of
accommodating customers’ transactions and records.
Table 1: Equipment / Hardware of Company

Equipment Specs Quantity

Laptop (HP Pavilion 15- Intel Core i7-2670QM Processor; 2
3040NR)
8GB 1600MHz DDR3 SDRAM
(2 DIMM); Radeon HD 8330
Telephone PLDT LINE 1

1.2.2 Software
The company is currently using the Microsoft Excel as their way of computing the sales of their
products. This thing is their way for keeping the records of the sales and the person in charged to this,
found it difficult. Also, the company doesn’t have any access with software in terms of scheduling,
monitoring and customer’s record and information.
1.2.3 People ware / Manpower
The Stella’s Animal Clinic has an authorized customer service staff that accommodates their
customers and at some point, the owner lets them compute for the sales of the shop at the end of the
operating day. This company’s customer service staff will be given access to the system as Front Desk.

Figure 1: Organizational Chart

This is the company’s organizational chart, showing the lines of responsibility inside Stella’s
Animal Clinic. And will further explain in Manpower Hierarchy and their Roles.

Page | 6
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
Table 2: Manpower Hierarchy / Roles

MANPOWER HIERARCHY
(HIGHEST POSITION TO ROLES
GROOMER)
Owner The owner of the Stella’s Animal Clinic, the person who
computes the sales/revenue of the company, the owner is the
veterinarian of the company and also the one that will use the
Online Scheduling, Sales and Inventory System.
Assistant nurse The one who help and support the veterinarian in terms of
surgery and injections of pets.
Manager The one who accommodates the incoming customers, who
respond in calls of the customers, who make schedules and
appointments, and also the one who will use the system.
Assistant Manager The person that will help and assist the role of the Manager in
the company whether the latter is present or not.
Groomer 1 & 2 Skilled Employees that will groom the customers pet.

1.2.4 Network Infrastructure / Architecture

The company has no internet connection that they may use to their Pet Shop Business and when it
comes in keeping records they still operate to use manual process which is do not have an access to the
1.2.5 Storage, Backup and Recovery Procedure
The company is storing their data in an alphabetical arrangement of the customer’s surname, kind
of surgical services and brings it together in the file shelves, and when they need the file they search for it
in the shelves. The records of the customers do not have any backup and recovery.
1.2.6 Security Procedures
The company does not allow any unauthorized person to view and access the files to make the
records secured and lessen. Authorized persons are only the ones who have understanding in terms of
their organized files. They have the usual security in their facility when they are operating to protect the
clinic including the records, while they have to lock the shop for the same reason, when they’re not
around.

Page | 7
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
1.2.7 Policies and Procedures
Business Rules
 The company is operating their services from Monday to Sunday at 9am to 6pm.
 Only accept the confinement or surgical operation with the signed Contract.
 If there is a new customer, he/she must fill-up a sign-up form before acquiring
the services.
 The company does not charge boarding services after surgery, not at least the end
of the day or their operating hour. (6pm) However, their charge for Boarding
services itself is 300 pesos per height of pet.
 Doubling of payment / fee is needed, especially if the fur of the pet is matted.
Because the equipment for the service will be paid.
 The range of time of grooming will take around 15-30mins per pet, depending of
the size of pet, the case (maybe the pet needs medication), and the type of cut the
owner wants.

Context Diagram
This diagram shows the actors; customers, staffs, owner and what they can do within the
company.

Figure 2: Context Diagram

Page | 8
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Data Flow Diagram

This data flow diagram shows the manual process of Stella’s Animal Clinic. With the
customer, classified if a regular or a newbie there the process will take place depending in the
classification of the said customer. After the transaction, the details regarding the latter between the
customer, the services, products and sales will all generate reports to the admin.

Figure 3: Data Flow Diagram

Page | 9
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
1.3 Problem Analysis
1.3.1 Fishbone Diagram
The main problem of the chosen company is their poor monitoring of sales and schedules, and the
poor record management. And the causes are shown in the diagram.

Figure 4: Fishbone Diagram

1.3.2 Problem and Solution Statement

The main problem of the company is their process of managing the sales, inventory and
customers’ record. The owner found it difficult to compute the sales especially in the pet medicine and
products. Second, all transactions between company and customers are only in manual process, even if
it’s organized it is still time consuming to find. In addition, the developers will give a solution to their
scheduling process where there are times that confirmed schedules and home service appointments are
unclear to their calendar. There researchers found a solution through creating a system that will monitor
the sales and inventory, scheduling for customers and also the file keeping of records.

Page | 10
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
Table 3: Problem-Requirements Matrix

BR. Page PROBLEM REQUIREMENTS

8 Limited cabinet for files Computerized Database with
8 No back-up files user-friendly environment
8 Use of Folders and Papers /
Numerous records to track
8 Slow generation of inventory and
sales report / Hard time locating Sales and Inventory System
files.
8 Limited staff to handle and
organize customer and inventory
records / Hassle for customer to Scheduling System
go to shop just to get a
reservation.
8 Reservation through calls

1.3.4 Purpose and Description

The researcher will propose a solution to the problems stated in the problem and solution
statement through creating a system Stella’s Animal Clinic Online Scheduling with Sales and Inventory
System which will give a proper file handling of customers records, efficient scheduling for customers,
helpful monitoring of sales for the company and availability to see or view the reserved appointments of
the customer.

1.3.5 Specific Objectives

 To be able to evaluate the current situation of Stella’s Animal Clinic.

 To be able to distinguish the improvement that the system will give to the Stella’s Animal
Clinic.
 To be able to propose a solution to manual process of file handling, schedules and
appointments, and give a proper monitoring to the sales of the company.

Page | 11
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
1.3.6 Scope and Limitations

The researchers proposed this system with the scope of Online scheduling for customer and Sales
and Inventory Management for the owner/company. This system will maintain all those record of
customers’ information which includes pets as well as their respective owners and what products they will
buy using the system. The records are secured in this system because this system is only for the company
of Stella’s Animal Clinic and its customers. Also, all the services that the company offers will be viewed
by the system thus easy access. The ones that can access the system are; Admin (can access the system as
a whole), employees (can only manage transactions with customers and monitor reserved schedules by
customer), and customers (can log in, register pets and reserve preferred dates and needed services). The
system can only record transactions that are already done. It does not accept installments.
By using this Online Scheduling, Sales and Inventory System, the company will be notified if
they are nearly out of stocks. However, in system, the researchers do not include online payment for the
purchased products because the company does not support deliveries.

Page | 12
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
Chapter 2
Reviews of Related Literatures and Systems

Now that we are living in an ever-changing world, technology is viewed as the most resourceful
tool in keeping up with the pace. Without the use of technology, communication would be limited to
using mail for delivery, encyclopedias for research, and especially used for business transactions and
promotions. In the business world, information and security is critical. The company needs to have a
secured and effective way of handling the records and effortless handling of time for their customers.
Systems have been a big impact and become beneficial to both company and public.

According to a blog (Client Resources, 2017), systems plays a significant role to the company or
businesses. It is necessary for entrepreneurs to incorporate them into their businesses. Systems are also
enabling employers to monitor and manage their staff. It allows them to interact with each other and
connect them to the operational strategies of the business.

Modern inventory systems will help the businesses to maintain and monitor profitability.
According to Johnston (n.d.), without a system, you could be wasting money on inventory without aware
of it. You may be buying too much, or not buying enough. You could be spending the money counting
and trying to value your inventory.

Osei (2015) studied about the inventory management at St. Martins Hospital in Agroyesum, Ghana;
whether it had any effects on the hospital’s services. This thesis provided several insights on how
effective inventory management can be when it comes to a business’ success.

Almera, et al. (February 2018) The Sales and Inventory System will help the Cheddar Burst Burger
to manage their sales and inventory report, records of handle sales transaction and inventory of their
items. Through this, it will be keeping all information recorded that be always needed of the organization.
Through inventory of items, company employees will be able to monitor quantity of items on hand and
quantities of items need to be ordered from supplier.

Dimaano, et al. (2018) Inventory System manages the records of all sold products in more
organized way. It monitors how many products produced and sold for today. Sales system serves as the

Page | 13
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
main system that is responsible in tracking of sales to determine which products are moving faster and
how many sales a company is making and how much profit is being earned. Maintains sales history and
records the sales of the company in daily, monthly and annual. It produces sales report.

Camacho, et al. (2018) In relation to this, reservation will develop an Online Reservation, Ordering
and Sales System for a hassle-free transaction not only for the consumers but for the company employees
as well. To their chosen company or store which is the Kanzhu Hand Pulled Noodles, located at Wilson
St., San Juan City. An Online Fine-Dine Transaction system will not only upgrade their current system
but will also help their business to become known not only in San Juan City but also in other places.

Chinchilla, et al. (2018) The project that is being proposed is a system for truck monitoring, billing
and payment management. This is to help TRI-B Express Trucking Services to have faster and easier way
of recording and updating their data. In billing it includes information like: their mode of payment and
sending of invoice and collecting payments received from the client. And in truck monitoring which some
of the information Is their recommended required units’ necessary for particular load, distance of the
place and the availability of their unit. This will give the company an accurate and easy access user
interface with a secure and organize storage that will facilitate their transactions.

Dela Paz, et al. (2018) The gym service management system aims to help the gym in terms of
managing its classes and services, managing and monitoring the equipment and lockers, membership
plans, scheduling classes and services and delegating trainer’s/instructors’ assignment. It aims to help the
gym to have a proper and accurate management. The sales system aims to aid the gym in terms of
tracking sales data (daily, monthly, and annually), maintaining sales history, and improving the sales
pricing in a more facile way. It aims to help in making the gym’s sales reports accurate and adequate. All
the records and transactions that were done by the administration will be recorded, updated and deleted
(in case the operation does not exist anymore) in this system.

Their study is almost the same with ours but in today’s modern age where computer has become a way of
life, it is evident that a majority of the country’s institutions still do not adapt the high technology.
Particularly in most animal clinic facilities, daily clinic transactions are still done on paper. What we
propose is an online VET system. The main advantage of this system is that it greatly simplifies the
process for both the customer and the clinic. Online Clinic Management System is web based project. The
main objective is to develop the software that covers all the aspects of management and operations of

Page | 14
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
clinics. It enables healthcare providers to improve operational effectiveness, reduce costs, reduce medical
errors, reduce time consumption and enhance delivery of quality of care (JaypeeDizon 2014).

According to the paper written by Cut Fiarni et al. (2015) with a title “Automated Scheduling
System for Thesis and Project Presentation Using Forward Chaining Method with Dynamic Allocation
Resources” Poor scheduling practices would cause double-assignations of lecturers, prolonged
postponement and cancellations of presentations as well as inefficient use of time and resources. That is
true because we have seen it face to face.

Page | 15
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
Chapter 3
Methodology
3.1 Requirements Analysis
3.1.1 Requirements Feature Matrix
This table shows the requirements and its features that the system holds to help Stella’s Animal
Clinic operate electronically for faster operation.

Table 4: Requirement-Feature Matrix

Real-time Secured View the View Computeriz Stock

Online and log-in offered calendar with e handling Management
Offline activity services available of service with
Database intended of dates for transaction expiration
System for admin company appointments records and stock
and alert
employee

√ √
Computerized
Database with
user-friendly
environment

√ √
Sales and
Inventory System

√ √
Online Scheduling
System

Page | 16
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
3.1.2 Use Case Diagram
This diagram shows the actors of the system and what they can accessed in the system.

Figure 5: Use Case Diagram

Page | 17
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
3.1.2.1 Use Case per Module

Figure 6: Per Use Case Online Product Ordering

Figure 7: Per Use Case Online Registration (Log-in Module)

Page | 18
POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Figure 8: Per Use Case Walk-ins Reservation System

Figure 9: Per Use Case Online Reservation / Scheduling

Page | 19
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Figure 10: Per Use Case Point of Sales

3.1.2.2 Use Case Report

The following tables show the descriptions of the Use Case Diagrams above.Use case report
explains who are the actors executing commands in the system, the pre and post conditions for the
execution, the basic flows or what can be done in the system and alternative flows if there are issues that
counter the basic flows of the system.

Table 5: Online Ordering System Use Case Report_Customer and Staff

Use Case Online Ordering System

Actor(s) Customer – the one that will give order details
Staff – the one that will handle order details
Pre-Condition Customer has an access to GroomEx website (Network Availability)
Customer will provide order details needed
Basic Flows  Customer will choose a products and add to cart
 Customer can delete a product from the cart
 Customer will click the check-out button if their order(s) is final
Alternative Flows  System will show the list of the products

Page | 20
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
 System will add the products to the cart
 Staff confirmed the order of the customer(s)
Post Condition If the customer already ordered, they can pick up and pay their order(s) to the
company.

Table 6: Log-in Module Use Case Report_Admin and Customer

Use Case Online Registration (Log-In Module)

Actor(s) Customers – the one that will give information needed for sign up / login
Admin – the one that will handle the online transaction and responsible for file
handling.
Pre-Condition Customer will provide information for signing up
Customer and Admin will have to enter his/her username and password for
login
Customer and admin has an access to GroomEx website (Network availability)
Basic Flows  New customer provide their information needed for signing in
 Old customer provide username and password for logging in
 Admin give their username and password to log in

Alternative Flows  Input wrong password and email. Display error message
 Retype the password and email
Post Condition The user successfully sign-in in the website

Table 7: Walk-in Reservation System Use Case Report_Customer and Staff

Use Case Walk-Ins Reservation System

Actor(s) Customers–the one that will give order details
Staff – the one that will handle the order details
Pre-Condition The staff should be logged in to GroomEx
Customer provide information to the staff for reservation details
Basic Flows  Staff click the button for reservation
 Staff ask the customer for their information
 Staff input customer details and reservation details
Alternative Flows  System will show a reservation details form
 System will show the reservation details made by the customer
Post Condition The customer successfully made the reservation. And will have pay the
reservation fee.

Table 8: Online Reservation System Use Case Report_Customer and Staff

Use Case Online Reservation System

Page | 21
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
Actor(s) Customers – the one that will provide the reservation details
Staff – the one that will handle the reservation details
Pre-Condition Customer will provide information needed for online reservation
Customer and Staff has access to GroomEx website (Network availability)
Basic Flow  The customer should click the ‘Book an Appointment’ in the
reservation button
 The customer will give the information needed for reservation
Alternative Flow  System will display the form for reservation details
 Input wrong details. Display an error message
Post Condition The customer successfully made reservation online and will pay for the
reservation fee.

Table 9: Point of Sale Use Case Report_Customer and Staff

Use Case Point-of-Sale

Actor(s) Customers – the one that will provide order details
Staff – the one that will handle the order details
Pre-Condition Customer will provide details about his/her order
Customer and Staff has access to GroomEx website (Network availability)
Basic Flow  The customer will order to the company
 The customer will give his/her order details
 The system will enable the cashier to see point-of-sale
Alternative Flow  System will display chosen categories of products and services as well
as the respective price.
Post Condition After customer received order, he/she will pay the amount of order to cashier
(staff).

Page | 22
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

3.2 Design Specifications

3.2.1 Activity Diagram
This activity diagram shows the flow from one activity to another activity of the actors in the
system; GroomEx. (Base on the Use Case Diagrams).

Figure 11: Activity Diagram_ Transactions (Online Ordering)

Page | 23
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Figure 13: Activity Diagram_ Sign in Figure 12: Activity Diagram_ Log in

Figure 14: Activity Diagram_Pet Registration (After customer login)

Page | 24
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Figure 15: Activity Diagram_ Online Scheduling / Reservation

Page | 25
POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Figure 16: Activity Diagram_Sales Invoice

Figure 17: Activity Diagram_Purchase Products to Supplier

Page | 26
POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Figure 18: Activity Diagram_Generating Reports

Page | 27
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
3.2.2 Class Diagram

Figure 19: Class Diagram Online Ordering

Figure 20: Class Diagram Inventory

Page | 28
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
3.2.3 GUI Design

Figure 21 Appointment link for user customer

Figure 22 Veterinarian Profile

Figure 23 Veterinarian Information

Page | 29
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Figure 24 Set Appointment

Figure 25 Date Added Preview

Figure 26 Customer's information

Page | 30
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Figure 27 Appointments' List

Figure 28 Veterinarian’s account

Figure 29 Adding appointment

Page | 31
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Figure 30 Home User Interface

3.2.4 Database Schema

Figure 31: Database Schema

Page | 32
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
3.2.5 Data Dictionary

Table 10: Orders

Key Fields Data Type Length Sample

PK OrderNo int 11 1
DateOrdered datetime 05/08/2018
PaymentMethod varchar 50
Status varchar 20 Cancelled

Table 11: Order Details

Key Fields Data Type Length Sample

PK RefNo int 11
OrderNo int 11
UserID int 11
PetID int 11
SuppliesID int 11
Quantity int 11 2
Amount double 500.95
Status varchar 20 Successful

Table 12: User Type

Key Fields Data Type Length Sample

PK UserTypeID int 11
UserType varchar 50

Table 13: User List

Key Fields Data Type Length Sample

PK UserListID int 11
UsertypeID int 11
Email varchar 30 j123@sample.com
Username varchar 50 employee1
Password varchar 100 ********
DateAdded date 08/20/2018

Table 14: Pet

Key Fields Data Type Length Sample

PK PetID int 11
CategoryID int 11
Breed varchar 50

Page | 33
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
PetBirthdate date
Description varchar 200
UserID int 11
PetName varchar 50

Table 15: Veterinarian

Key Fields Data Type Length Sample

PK veterinarianID int 11
UserListID int 11
LastName varchar 50
FirstName varchar 50
Address varchar 200
ContactNo varchar 20
Experience int 11
Photo varchar 200
AdditionalInfo varchar 300
Status varchar 20

Table 16:Pet Status

Key Fields Data Type Length Sample

PK StatusID int 11
Status varchar 50

Table 17: Pet Supplies

Key Fields Data Type Length Sample

PK SuppliesID int 11
CategoryID int 11
ProductName varchar 30
SuppliesCat varchar 30
Brand varchar 30
Price double 30,2
Available int 11

Table 18: Pet Category

Key Fields Data Type Length Sample

PK categoryID int 11
category varchar 50

Table 19: Appointment

Key Fields Data Type Length Sample

PK appointmentID int 11
UserOneID int 11
Page | 34
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES
UserTwoID int 11
Date date
Time varchar 50
Reason varchar 300
DateAdded date

Table 20: User

Key Fields Data Type Length Sample

PK appoinmentID int 11
UserOneID int 11
UserTwoID int 11
Date date
Time varchar 50
Reason varchar 300
DateAdded date

Table 21: Comment

Key Fields Data Type Length Sample

PK commentID int 11
user varchar 20
Comment varchar 500
DateAdded date
Status varchar 20

Table 22: Review

Key Fields Data Type Length Sample

PK ReviewID int 11
UserID int 11
PetID int 11
SuppliesID int 11
ReviewTitle varchar 80
Review varchar 200
DateAdded date
Status varchar 20

3.3 Development Methodology

3.3.1 Process Model
The process model that we used in developing this system is the Prototyping Methodology
because it already gives us researchers a clear idea about the functional process of our software/system.
For us researchers, this model enables us to validate the systems’ functional essence to the users and make
essential changes before creating the authentic final solution.

Page | 35
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

Table 23: Work Done in every Phase of Prototyping Methodology

Phase Work Done

Requirements Analysis After the problem analysis, we’ve move on to
requirements analysis, in this phase; we give every
requirement to solve the problems their own
features.
Design/ Building and Prototyping/ Refining In these phases, our back and front end
Prototype programmers decided to start planning to design
separately, and later on merge the modules for
refining the prototype.
3.3.2 Development Tools
In developing the proposed system the researchers used Sublime and Macromedia Dreamweaver
8 as our IDE since this IDE has a built-in PHP programming language and PHP is our programming
language, because we already have a background knowledge and understanding in this programming
language. As for our database, we are using php, javascript, css and ajax.

Page | 36
 POLYTECHNIC UNIVERSITY OF THE PHILIPPINES

References

Client, R. (2017), The Importance of System and Process to your Business, Retrieved: May 8, 2018,
From: http://outsourcingangel.com/the-importance-of-system-and-process-to-your-business/

Kevin, J. (n.d), Roles of Inventory Systems, Retrieved: May 8, 2018, From:

http://smallbusiness.chron.com/role-inventory-systems-61265.html

Osei Mensah, Esther (2015). The effect of inventory management practices on service delivery at St.
Martin’s hospital, Agroyesum, Amansie-west (Thesis).

Jaypee Dizon (2014), “Online Veterinary Management System” Retrieved March 21, 2018 from:
https://prezi.com/n1lqvkumkv2z/online-veterinary-management-system/

Cut, F.(2012), “Automated Scheduling System for Thesis and Project Presentation Using Forward
Chaining Method with Dynamic Allocation Resources” Retrieved March 21, 2018 from:
https://www.sciencedirect.com/science/article/pii/S1877050915035942

Keziah Camacho, Joanna Angela La Pena, Ron Jermaine Mercado, Miguel Lorenzo Milanes, Ella Rose
Solera, and John Carlo Villanueva (2018). Kanzhu Hand-Pulled Noodles Online Ordering, Reservation
and Sales System. (Thesis)

Benjamin Chinchilla, Anna Marie Domingo, Adrian Magnayon, Michelle Mendoza and Jay Mark
Oandasan (2012). TRI-B Truck Scheduling, Billing and Payment System. (Thesis)

Yvonne Lance Dela Paz, Cris Jaen Jr., Vanessa Jane MAkabenta, Jelaiza Rubio, Arjie Sadia (2018) Gym
Service Management and Sales System. (Thesis)

Jelo Ann Joyce Dimaano, Erwin Elizan, Kaycelyn Esguerra, Alberto Lejano III, Kent Derrick
Manalaysay (2018). Online Ordering, Sales and Inventory Management System (Thesis).

Sittie Almera P. Bin Alinor, Ma. Kassandra Caseres, Vannesa Llano, Monique Quintana, Rodel Seriño
(February 2018). Online Ordering And Sales and Inventory (Thesis)

Page | 37