Final-Pharmacy-Easy (AutoRecovered)

Pharmacy Easy: Online Medicine Ordering App
Davao Del Norte State College
New Visayas, Panabo City
A proposed project title submitted by:
Ariel A. Alayon
Aj V. Delos Reyes
Kristine C. Gerbolingo
Dexter B. Lomod David
Jones M. Lumen
June 2023
i
Approval
ii
Acknowledgement
Primarily, praises and thanks to God almighty for His showers of blessing to our
research work to complete the research successfully.
We would like to express deep and sincere gratitude to our adviser, Engr. Rogelio A.
Masangkay, faculty member of the Institute of Computing of Davao Del Norte State College,
for allowing us to do research and for providing invaluable guidance throughout our research
journey. His dynamism and motivation have deeply inspired us. He taught us the
methodology to carry out the study and to present our research work as clearly as possible.
Moreover, we would like to thank the panelists headed by the Panel Chairman, Sir
Jumar S. Buladaco, our panel member Sir Ian Jay Padios, and Dr. Hazel A. Gameng for their
comments, suggestions, and for criticizing our research so that it would become better and
successful.
To all partnered organizations, the 2M Pharmacy, we would like to give our most
profound gratitude for accepting the endorsement of our chosen organization for our capstone
project. Without them, our project would not be visible, and we would not be able to
accomplish it.
Special thanks to all the team members for showing their expertise and spending time
and working on Improving our communication skills, especially when we were occasionally
constructing the project. Appreciation and thanks are given to them for constantly lending
their hands to comprehend and provide the project with everything they have.
Finally, we want to thank our parents for their financial and emotional support.
For providing a reliable internet connection which is essential for our online queries
iii
and communication. To our close friends who unconditionally encouraged us so that we can
complete our project. Thank you very much. God bless, and more power.
-The developers
iv
Abstract
Online shopping is popular, especially for those who cannot leave home due to the
epidemic, like the elderly needing medicine. The project "Pharmacy Easy: Online
Medicine Ordering App" aims to simplify ordering medicine through a user-friendly
interface. It features walk-in orders, generic name medicines, supplier name, sales &
inventory reports, and product expiration report for convenient online ordering. The
app lets you easily search and find medications using filters like drug name. With an
extensive medicine database, you will quickly find what you need and enjoy a secure
ordering process. Users can easily add items to their cart and checkout using the
app's various payment options like Gcash and In Cash. The team used the waterfall
software development model to help the structure of the project processes from start
to finish. The system underwent unit and integration testing to ensure usability and
protection from intruders. Moreover, the system was deployed to users for 6 weeks
to ensure operational acceptability. During the system deployment the developers
provided a user training on the initial prospect user of the app, the 2M Pharma,
including its owner and staff. At the end of the deployment phase, the developers
evaluated thirty-four customers, one Admin, and two staff to measure its quality
based on the ISO 25010 software quality model. As a result, The Pharmacy Easy
App received an average weighted mean of 4.79, which means that the system got a
high acceptance rate from the user. The result implies that the developed system
meets the user requirement in terms of functional suitability, performance efficiency,
reliability, usability, compatibility, and security. Based
on the results, the pharmacy easy app provides an innovative and convenient way of
ordering medicine. It also, facilitates the pharmacy workflows and keeps a system to
efficiently manage medication dispensing of prescriptions and keeping track of

v
inventory.
Keywords: Pharmacy Information System, Online medicine ordering, Inventory
management for Medicine.
vi
Tables of Contents
PRELIMINARY PAGES Page No.
Title Page…………………………………………………………………… 1
Approval Sheet……………………………………………………………… 2
Acknowledgement…………………………………………………………… 3
Abstract……………………………………………………………………… 4
Table of Content………………………………………………………… 5
List of Figures………………………………………………………………… 9
List of Tables…………………………………………… 10
CHAPTER 1 – INTRODUCTION
Background of the Study………………………………………………………… 11
General Objectives………………………………………………………………. 14
Specific Objective………………………………………………………………… 14
Significance of the Project………………………………………………………. 15
Scope and Limitation……………………………………………………………. 16
Definition of Terms………………………………………………………………. 16
vii
CHAPTER 2 – METHODOLOGY
System Planning……….……………………………………… 18
Project Team Organization…….…………………………. 19
Work Breakdown Structure……………… 20
GANTT Chart………………….………………… 21
System Analysis……………………………………… 23
viii
Existing System Business Process…………….……………… 24
Context Data Flow Diagram……………………………… 24
Use Case Diagram…………………………………………… 25
Diagram 0 Flow Diagram……………………………… 26
System Flowchart…………………………………………… 27
Technology and Tool…………………………………………… 30
XAMPP Control Panel…………………………………………… 30
Sublime Text…………………………………………………. 31
PHPMyAdmin……………………………………………… 32
Android Studio………………………………………. 32
System Design…………………………………………… 33
Entry-Relationship Diagram…………………………… 33
Data Dictionary……………………………………… 34
System Implementation………………………………………… 38
System Maintenance………………………………… 40
CHAPTER 3 – RESULT AND DICUSSION……………………………… 41
CHAPTER 4 – CONCLUSION AND RECOMMENDATION

Conclusion………………………………………. 61
Recommendation……………………………………. 61
REFERENCES………………………………… 63
ix
APPENDICES
APPENDIX A – RECOMMENDATION AND DEPLOYMENT…………… 65
APPENDIX B – DEFENSES MINUTES………………………….... 66

APPENDIX C - CERTIFICATES………………………….… 67
APPENDIX D – QUANTITATIVE RESULTS…………………………… 70
APPENDIX E – EVALUATION SHEETS………………….…………… 71
APPENDIX F – ERRORS FOUND………...……….…………………………… 72
APPENDIX G – SAMPLE REPORTS ……….…………………………… 73
APPENDIX H – SYSTEM SCREENSHOTS………………...……………… 74
APPENDIX I – PHOTO DOCUMENTATION…………………………………… 75
APPENDIX J – CURRICULUM VITAE…….……………………… 76
x
List of Figures
FIGURE Page No
Figure 1. Project Team Organization……. …..…………………… 20
Figure 2. Work Breakdown Structure…………………………… 21
Figure 3. GANTT Chart………………….………… 22
Figure 4 & 5. Existing System Business process of | pharma Sys…………… 24
Figure 6. Context Data Flow Diagram …………….………… 25
Figure 7. Use Case Diagram ………………………………. 26
Figure 8. Diagram 0 Data Flow……………………………………… 27
Figure 9.1 System Flowchart in Admin …….……………………… 28
Figure 9.2 System Flowchart in Customer…………………………… 29
Figure 9.3 System Flowchart in Pharmacy Assistant…………………… 30
Figure 10. XAMPP Control Panel v3.2.2………………………………… 31
Figure 11. Sample Code of using Sublime Text……………………… 32
Figure 12. PHPMyAdmin Interface……………………………………… 32
Figure 13. Android Studio………………………………………………… 33
Figure 14. Entry-Relationship Diagram ………………………………… 34
xi
List of Tables
TABLE Page No
Table 1. Admin Table…………………...…………… 34
Table 1.2 Pharmacy Table………………….………………… 36
Table 1.3 Medicine Table…………………………………………. 36
Table 1.4 Payment Table……………….…………….………………… 37
Table 1.5 Supplier Table…….………………………………………… 37
Table 1.6 Customer Table…...…………………………………………… 37
Table 2. Scale of the evaluation sheet of Pharmacy easy……………… 39
Table 3. The Summary of the overall quantitative results of Pharmacy Easy: Online
Medicine Ordering App with Online Ordering Medicine using Pharmacy Easy App
40
based on the project
objectives.…………………………………………
Medicine Ordering App with Online Ordering Medicine using

47
Pharmacy Easy App for the system performance efficiency………………….
Medicine Ordering App with Online Ordering Medicine using

49
Pharmacy Easy App for the system reliability………………………………….
Table 6. The Summary of the overall quantitative results of Pharmacy Easy:
Online Medicine Ordering App with Online Ordering Medicine using

50
Pharmacy Easy App for the system Usability…………………………………...
xii
Online Medicine Ordering App with Online Ordering Medicine using Pharmacy
52
Easy App for the system compatibility……………………………….
Online Medicine Ordering App with Online Ordering Medicine using Pharmacy
54
Easy App for the system security…………………………………
Table 9. Overall total results of the System’s Function based on 55
evaluation………………….
xiii
Chapter 1
INTRODUCTION
Background of the Study
Recently, technology has played an increasingly vital role in all management aspects to
effectively computerize most people's occupations.
In addition, the pharmacy practice encompasses the evaluation and interpretation of
medical orders, the administration of pharmaceuticals, the dispensation of prescribed drugs
from trained medical practitioners, the review of prescribed drug regimes, and the proper
storage of drugs. According to the American Pharmacists Association, a pharmacy's mission
includes ensuring adequate medication usage and enjoyment of pharmacological services to
obtain optimal therapeutic effects. [1]
Moreover, due to convenience, the possibility for cost savings, and anonymity, the
Internet has become an acceptable method of purchasing drugs over the last two decades.
Early research on using the Internet to buy medicines shows that the likelihood of acquiring
or purchasing prescription drugs online is highly remote (Desai et. 2015). However, recent
data reveal that the number of people using internet pharmacies and buying drugs and other
health products online is rising [3].
Additionally, the Pharmacy apps provide healthcare professionals with the
opportunity for a quick, user-friendly way of accessing important medical information to
support patient care.[4] According to an early definition by Fung et al., an online pharmacy is
an internet-based vendor (legal or illegal) which sells medicine and may operate as an
independent internet-only site, an online branch of "brick-and-mortar"
pharmacy, or sites representing a partnership among pharmacies. An online pharmacy
13
is a website offering to deliver, distribute, or dispense medication on the Internet directly to
consumers [6,7]? The rapid expansion of the Internet, the ever-increasing digital health, the
shift away from direct doctor-patient relationships to self-diagnosing, consumer experience in
online purchases, the ease of mail-order trade, and distance selling have all aided the growth
of the online pharmacy market [8,9]. The provision of medications through the Internet has
evolved in many ways and according to multiple models in various parts of the world. It is
because the regulatory, economic, and cultural settings differ. The internet pharmacy market
in the United States is primarily prescription-based, whereas, in Europe, this segment is
forming on a nonprescription- based basis [10].
Similarly, the online purchase of pharmaceuticals outside the regular supply chain
poses several patient safety concerns, including the possibility of receiving counterfeit
medications. Counterfeit medicine is estimated to account for 10% of all medicines sold
worldwide, ranging from less than 1% in wealthy countries to more than 30% in
underdeveloped countries such as Africa, Asia, India, and Latin America [11,12].
In addition, the Union Health Ministry has released guidelines for e-pharmacies to
register with the Central Drugs Standard Control Authority (CDSCO), India's major licensing
and regulating organization for pharmaceutical sales [13], to legitimize online drug sales.
Mobile devices have accelerated this tendency, which provides portability, mobility,
personalization, and ubiquity. Consumers use the Internet to get health information and
various health services and goods. Pharmaceutical e-commerce has grown significantly with
the digital health industry's continued rise. B2C online pharmacies can be online extensions
of brick-and-mortar pharmacies or third-party
B2C platforms that provide a virtual transaction platform for consumers and drug
14
vendors while maintaining a neutral identity. The growing market share of online pharmacies
is due to the outstanding customer experience and simplicity of transactions during online
buying [14, 15].
Accordingly, the developers have chosen a pharmacy that has a broad customer base
due to its size and quantity of service. Because of the rising demand for medications in many
places, the number of clients is rapidly expanding. As a result, the pharmacist is kept busy
and spends a significant amount of time managing and controlling their business data.
Meanwhile, the pharmacist must ensure customer pleasure. The 2M Pharmacy in Barangay
Salvacion, Bangoy St, Panabo City provides medicines to their barangay. However, they will
need to help accommodate the customer on time due to the long queue of people wanting to
buy medicine. And every time it has an inventory report prepared for pharmaceutical
supplies, 2M Pharmacy staff will have to recount every medicine and supply and check their
logbooks and Excel files. This is a time-consuming activity. This process has many risks, like
miscalculating inventory, losing inventory cards, and other undesirable issues. Tracking
medicine expiration is also a primary task that needs to be synthesized so that staff is
prompted automatically to act according to inventory protocols.
Furthermore, the 2M Pharmacy has an inventory system, but according to the
pharmacist, they will need another method that increases accuracy and improves the safety
and efficiency of their pharmacy store. Hence, the project development team developed a
Pharmacy application to address the problems encountered by the pharmacy.
General Objectives
The proponents aimed to develop an online Pharmacy with mobile and web
applications.
15
Specific Objectives
Specifically, the system includes the following functions:
1. Allow the customer using the mobile app to:
a. Register and login.
b. Search for medicine.
c. Determine the generic and brand name of the medicine.
d. Order medicine online.
e. Upload doctor’s prescription.
f. Select the date and time to pick up the order.
g. Pay for purchases of medicine through Gcash.
h. View purchase history.
2. Allow the admin to update the Stocks.
3. Accept walk-in customers to order products.
4. Accept and/or reject customer orders made thru mobile app.
5. Allow the admin to monitor the following:
a. Medicine stocks.
b. View Sales history.
c. Monitor medicine purchases.
6. Generate the following reports:
a. Inventory of stocks of medicines.

b. Out of stocks medicine.
16
c. Receipt.
d. Near expiry medicines.
e. Add/Delete daily, weekly, and monthly sales.
Significance of the Project
The project provides benefits to the following:
Administrator. The project's automated and convenient system could reduce the effort
required by the administrator to record, organize, and retrieve data.
Customer. The project would make it easier for customers to purchase medicine and
manage its availability, thereby reducing their effort.
Future Developers. The project could serve as a valuable reference for future
developers in the development of related systems, particularly those involving
cashiering and inventory management.
Cashier. The project's system would enable staff to reduce their effort in managing
customer payments and inventory.
Scope and Limitation
Scope:
The Online Pharmacy system consists of both a website and a mobile application. The
website serves as a comprehensive platform for managing all pharmacy operations, including
sales and inventory. It enables the administrator to add new batches of pharmaceuticals to the
database, delete outdated drugs, and update a drug's current dosage and indications.
Additionally, the system provides
alerts to the administrator when any medications are approaching their expiration
dates. The mobile app allows customers to conveniently order medicines online and pick
17
them up at their preferred time.
Limitation:
The system does not support online consultations with doctors or lab test payments. It
also does not include an accounting system. Furthermore, the system exclusively caters
online medicine purchases and pick-ups and does not offer delivery services to customers'
locations.
Definition of terms
Medicine. Medicine is the science and practice of diagnosing, treating, and preventing
diseases. In an operational sense, medicine can be ordered online through web or mobile apps
to reserve drug medication.
Receipt. A receipt is a document that acknowledges the receipt of money or property
following the sale or transfer of goods or services. All receipts must include the date of
purchase.
Report. A report is a computer program that takes data from a source such as a database,
XML stream, or spreadsheet, and uses it to produce a document in a format that is readable to
a specific human audience. In an operational sense, a report displays the list of customer
transactions with their respective invoices.
SMS Notification. SMS notifications are text messages that are sent when an event occurs.
An event can be something as exciting as an app update or as urgent as a weather alert. SMS
stands for "Short Message Service," and these notifications are sent the same way as any
other text message. Operationally, the admin will notify the customer via SMS when their
reserved medicine is ready.
System. A system is a set of interconnected parts working together as a mechanism or
18
network. In an operational sense, the system is designed for monitoring stock inventory and
processing sales through an online medical system.
19
Chapter 2
METHODOLOGY
The purpose of this chapter is to exhibit system flow and strategies connected to this
study. It is a scientifically proven, systematic, disciplined project development and
implementation approach.
The developers have used System Development Life Cycle (SDLC) Methodology in this
project. System Development Life Cycle is a traditional methodology for developing,
maintaining, and replacing for successful system development. The project managers and
development team used the waterfall methodology to determine the performance needed to
understand what to design, describe the inputs, and examine the project's predicted output.
In addition, following the requirements analysis, the developers created a system
design to aid in hardware specification and the definition of overall system architecture. The
developers developed the software code to move on with the project implementation.
Constant software testing is performed on the completed project to uncover any defects or
faults. The program was deployed in the end user's environment once fully functioning and
tested. The project development team would carry out maintenance if any changes are
required due to client requests.
System Planning
The project development team submitted a formal request to develop a project to Ms.
Maria Fe Salaysay, the pharmacy's owner. The project development team conducted an
environmental scanning and interviewed the pharmacy owner regarding the problems
encountered when buying drugs in the pharmacy. The project
20
development team identified that, at times, many customers are buying from the said
pharmacy and some of them were not easily entertained or catered to on time.
Additionally, the current way of pharmacy buying is time-consuming for the
customer, and sometimes they are stuck in a long queue. Every detail the developers got in
interviewing their organization is of excellent value and helps them plan how to solve their
problem. Hence, the project development team discovered that the pharmacy needs a mobile
and web application for ordering medicine and inventory management to make the processes
time-efficient and hassle-free.
Project Team Organization
The organization of the project development team is shown in Figure 1. These refer to
providing distinct duties to each team member to focus on their job areas in constructing the
system. The project manager, who is responsible for monitoring and mandating the overall
progress of the development, is part of the core team. The assistant programmer is in control
of the project's visual output. The system analyst controls the system's overall data flow
analysis. The programmer oversees maintaining the database, the function, and the code.
Finally, there is the documenter, who is in control of documentation.
21
Figure 1. Project Team Organization
Work Breakdown Structure
Figure 2 shows the work breakdown framework for the design of the Pharmacy Easy
Application. The work breakdown structure (WBS) is a tool for breaking a construction
project into sub-projects, tasks, sub-tasks, and work packages. The picture depicts the
systems' life cycle processes, starting with system development and concluding with systems
maintenance. Before progressing to the next objective, each one has been successfully
accomplished, indicating that each activity builds upon the previous one.
22
Figure 2. Work Breakdown Structure
GANTT Chart
Figure 3 shows the Gantt chart for planning and scheduling projects. It helped the
developers to assess the project duration, determine the resources needed, and plan the order
in which the tasks were completed. The system planning includes environmental planning,
title proposals, title defense, and client interview. It is followed by the system analysis
reviewing the existing business process and system requirements, constructing Use Case,
Context flow, and Data flow diagram, and identifying the technology and tools that were
identified and performed. After the system analysis, the system design was executed, which
included the creation of ERD
23
and class diagrams. The system Implementation followed, including the system
implementation and testing plans. Lastly is system maintenance of the system.
Figure 3. GANTT Chart
System Analysis
24
After gathering information, the project development team was able to classify and
recognize the problems and information needed to perform the task. The problems
encountered have also been analyzed based on the environmental scanning conducted by the
team to gain some ideas on how to solve their problems. The development team has
formulated a logical design of the "pharmacy easy" and the processes and techniques needed
for its development. The project development team examined many relevant systems/s. It
developed various concepts, methods, and strategies to improve the existing system and
construct a user-friendly web-based and mobile-based system for the pharmacy during this
phase.
Moreover, after gathering information, the project development team classified and
identified the problems and information needed to perform the task. The team analyzed the
problems encountered based on environmental scanning to gain insights into how to solve
them. In this phase, the team formulated a logical design of "Pharmacy Easy," along with the
processes and techniques needed for its development. The team examined many relevant
systems and developed various concepts, methods, and strategies to improve the existing
system and create a user- friendly web-based and mobile-based system for the pharmacy.
Furthermore, the system analysis phase utilized various diagrams to comprehend and
analyze the system flow. The developers reviewed the pharmacy's previous business process
to identify the improvements needed in the current system. To illustrate the software data
flow and identify the system's end-users, the developers constructed and built the Use Case
Diagram, Context Flow Diagram, Diagram 0 Data flow Diagram, and System Flow Chart.
Additionally, the developers determined the technology and tools required to complete the
software project.
25
Existing System Business Process
Figures 4 and 5 depict the existing system business process of 2M Pharmacy, which
has been operating for several years. Customers physically visit the shop to purchase the
required medicine, resulting in a lot of time and effort wasted. If a customer needs to
exchange the product, they must visit the shop again. The entire process is dependent on
physical interactions.
Figure 4 & 5. Existing System Business Process of | pharmaSys
Context Data Flow Diagram
Figure 6 shows the Context Flow Diagram, which illustrates the interactions of the
pharmacy system with the administrator, customer, and pharmacy. In this diagram, the
administrator entity inputs medicine stocks, program details, and medicine dispensed to the
system. The system processes the inputted data and provides
26
information on inventory status, expiration status, and medicines received by the customer.
Additionally, the system's flow starts from the admin process, where the request for
pharmacy registration, addition of medicine products and categories, and medical information
are approved or disapproved. The report is automatically saved into a database and is
available for printing services. The system admin reports at the end of every transaction to
validate customer transactions.
Figure 6. Context Flow Diagram
Use Case Diagram
A Use Case Diagram is used to model the functionality of a system using actors and
use cases. Use cases refer to a set of actions, services, and functions that the system needs to
perform. In this context, the system being developed or operated is a website, and the "actors"
are people or entities working under defined roles within the system, as shown in Figure 7.
27
Figure 7. Use Case Diagram
Diagram 0 Data Flow Diagram
The Diagram 0 Data Flow Diagram is shown in Figure 8. The data flow diagram maps
out the flow of information of all the processes occurring in the
system.
28
Figure 8. Diagram 0 Data Flow
System Flowchart
The System Flowchart is shown in Figure 9. A system flowchart shows the graphical
representation of the data flow in the system and represents the work process of the system.
29
Figure 9.1 System Flowchart in Admin
30
Figure 9.2 System Flowchart in Customer
31
Figure 9.3 System Flowchart in Pharmacy Assistant
Technology and Tool
XAMPP Control Panel v3.2.2
XAMPP is designed to be a development server in a box. There are many other
WAMP packages, but XAMPP for Windows is among the most complete and easiest to
install. This does however come at the expense of security, so XAMPP is not meant to be
used as a production server (Gralla, Gabe, 2011). The project development team used the
XAMPP Control Panel in the project to stand as pages of the internet even without
connection to it. It helps create the software project for it is fast, reliable, secure, and free and
can provide support for creating and manipulating databases.
32
Figure 10. XAMPP Control Panel v3.2.2
Sublime Text
The Sublime Text is shown in Figure 11. Sublime Text 3.0 comes with an alternate
theme, called Adaptive, which users of the editor may enable. It uses, better inherits, colors
from the color scheme. The latest version of the editor comes with three new colors schemes
on top of that (Martin Brinkkmann, 2015). The project development team used the Sublime
Text as a code editor for the system development. It is where the developers edit functional
codes with ease. The developers can inspect and resolve the code right in the editor.
PHPMyAdmin
32
The PHPMyAdmin is shown in Figure 12. The developers used the PHPMyAdmin as
a database management system. This was also used to build and create a local database for
the system to run in any server. Also, PHPMyAdmin allows the developers to display images
stored in the database and directly connect data on the server.
Figure 12. PHPMyAdmin Interface
Android Studio
Android Studio is the official integrated development environment (IDE) for
developing android application, which is based on IntelliJ IDEA. This tool was used for
implementing the e-medication app. The screenshot shows the interface of Android studio
version 1.2 which was used for implementation of this project.
33
Figure 13. Android Studio
System Design
The developers created the Entity Relationship Diagram (ERD) to conceptualize the
data flow of the Pharmacy Easy: Online Ordering App. This aided the developers in
analyzing the function and identifying the many entities engaged in the system to
demonstrate the static structure of classifiers in a system. Furthermore, the end-user may
quickly comprehend the flow and operation of the system. The developers also constructed a
Data Dictionary in which distinct tables were identified, including the properties, data type,
keys, and description.
Entity-Relationship Diagram
The Entity-Relationship Diagram (ERD) is shown in Figure 14. The Entity-
Relationship diagram has entities included. The developers used the entity relationship
diagram to identify the relationship of the entities involved in the system.
34
Figure 14. Entity-Relationship Diagram
Data Dictionary
Table 1.1 Admin Table
Field Name Data Type Description
Admin_ID (primary key) Int, not null Contains the admin Id
Admin_name Varchar (255), not null Contains the admin name
Username Varchar (255), not null Contains the username
Password Varchar (255), not null Contains the password
Email _address Varchar, not null Contains the email address
The table 1 illustrates the collection of description of data on the proposed project,
Pharmacy Easy: Online Medicine Ordering App.
35
Table 1.2 Pharmacy Table
Pharmacy_ID (Primary Key) Int, not null Contains the pharmacy id
Pharmacy_Name Varchar (255), not null Contains the pharmacy name
Contains the address of the

Address Varchar (255), not null
Pharmacy
Password Varchar (255), not null Contains the password
Username Varchar (255), not null Contains the username
Table 1.3 Medicine Table
Medicine_ID (Primary Key) Int, not null Contains the medicine id
Brand_Name Varchar (255), not null Contains the branded medicine
Generic_Name Varchar (255), not null Contains the generic medicine
Price Int, not null Contains the prices medicine
Image Binary, not null Contains the image medicine
Table 1.4 Payment Table
Payment_ID (Primary Key) Int, not null Contains the payment
Payment_Name Varchar (255), Contains the paymentname
not null
Total _payment Int, not null Contains the total payment
36
Table 1.5 Supplier Table
Supplier_ID (Primary Key) Int, not null Contains the id of the supplier
Contains the name of the
Supplier_Name Varchar (255), not null
supplier
Contains the address of
the supplier
Contains the information of the
Information Varchar (255), not null
supplier
Table 1.6 Customer Table
Customer_ID (Primary Key) Int, not null Contains the customer id
Customer_Name Varchar (255), not null Contains the customer’s name
Contains the address of

the customer
37
System Implementation
Since the Pharmacy Easy system development still needed to be completed, the team
planned to present it to their panelists and adviser for feedback on its overall performance. It
gave them an idea of any suggested improvements or recommendations for the system. After
receiving consent from the panels, the system was installed at 2M Pharmacy located in
Barangay Salvacion, Bangoy St, Panabo City, Davao Del Norte. The developers installed
XAMMP and Sublime text software on the computer unit at the pharmacy and provided
instructions to the staff and owner on how to use the developed system.
During the deployment stage, developers found three errors or lacking functionalities in
the six weeks of system deployment. In the first week, the developers found an error in a
mobile application that made some mobile numbers belong to people with disabilities. The
action taken to fix it was updating the feature used for validation because it was outdated and
manually adding those numbers to the backend that were not included in the validation
feature.
In week two, errors were found on the web application when adding the supplier’s
name for each product. The action taken was to add a drop-down button in the product
registration section of the system that indicates all supplier names for the medicine.
38
This change makes it easier for the administrator to add the supplier's name to the medicine
when registering a new product.
During weeks three and four, no errors or functionalities were found to be lacking.
However, in week five, the developers discovered errors in adding senior and persons with
disabilities discounts, as well as maximizing the space of the website. To fix these errors, the
developers added a checkbox tag that triggers a function. This function reduces the total price
by 20% whenever the checkbox is checked. If the checkbox is unchecked again, the total
price reverts to its original value with no discount. The total price is stored in a variable that
acts as a holder for the original price before applying the discount.
To address the next error, the order list was relocated to the bottom of the product list.
Additionally, when accepting orders through the application, the buttons for accepting,
denying, and paying the order were moved to the top area. This change allows the admin to
navigate the system more easily. In the last week, no errors or missing functionalities were
reported.
Furthermore, the developers evaluated the system's overall functionality with the
estimated monthly customer base of 2M Pharmacy. There was an identified user population
of 50 customers per month with a 10% margin of error, using Slovin's formula, which is n =
N / (1 + Ne²).
Where:
n = sample size.
N = user population e
= margin of error
39
The sample size for the user evaluation was thirty-four users, who were randomly
selected to rate and evaluate the Pharmacy Easy system using an evaluation sheet prepared by
the developers to assess the system's specific objectives. The evaluation sheet contained
several questions that were rated on a scale of 1 to 5, where 1 is the lowest and five is the
highest, and users were also encouraged to provide comments and suggestions. The
evaluation was conducted with three groups: (1) the administrator or pharmacy owner, (2)
staff who evaluated the website, and (3) the thirty-two customers who evaluated the mobile
application. The developers approached customers at the establishment and asked them to
evaluate the system through the evaluation sheet. The scale focused on whether the system
met the requirements and was beneficial. Table 2 below shows the evaluation sheet's scale
used to determine if the system meets the objectives and requirements.
Table 2. Scale of the evaluation sheet of Pharmacy easy.
Rating Range Description Equivalence Description
The system meets all the
5 4.5 – 5 Strongly Agree requirements of the system’s
objective.
The system meets more than the
4 3.5 – 4.49 Agree
Average of the system objectives.
The system meets the minimum
3 2.5 - 3.49 Fairly Agree requirements of the system’s
objectives.
40
The system meets the less than
2 1.5 – 2.49 Disagree the minimum requirements of the
system’s requirements.
The system does not meet the
1 1.0 – 1.49 Strongly Disagree requirements of the system’s
objectives.
System Maintenance
During the maintenance phase, the first plan is to demonstrate the developed system
to the staff and the owner to ensure they are familiar with its functionality and navigation.
Moreover, the developers provided a copy containing the necessary solutions to be
implemented whenever they encounter any issues or errors. To ensure the smooth
performance of the system, the team also decided to provide 2M Pharma with their contact
information so that they could inform them immediately if any problems arise.
41
Chapter 3
RESULT AND DISCUSSION
This chapter evaluated the Pharmacy Easy: Online Medicine Ordering App using an
evaluation sheet from the users. It includes analyzing and interpreting the gathered
information based on the survey.
In addition, the Summary of the overall quantitative results of Pharmacy Easy: Online
Medicine Ordering App with Online Ordering Medicine using Pharmacy Easy App is shown
in Table 3 below. It shows the system’s objective to be rated, the Summary of the average
weighted mean, and its descriptive equivalent.
Medicine Ordering App with Online Ordering Medicine using Pharmacy Easy App based on
the project objectives.
No. User (AWM)

Descriptive
System Functions of AWM
Equivalent
Staff Admin Customer
user
Functional Suitability
1. I can easily create and log Strongly
34 5 5 4.78 4.79
in to my account. Agree
2. The system allows me to

Strongly
instantly search the
34 5 5 4.90 4.91
Agree
available medicines
42
3. I can conveniently update
Strongly
medicine stocks using
2 5 5 - 5
Agree
the application.
4. I can efficiently record

Strongly
the walk-in customers’
2 4 5 --- 4.5
Agree
order.
5. The app conveniently

Strongly
allows me to accept or
2 5 5 -- 5
Agree
reject online orders.
6. I can effectively monitor the following using the application:
Strongly
1.1. Medicine
2 5 5 - 5
Agree
stocks.
Strongly
1.2. Sales history. 2 5 5 5
Agree
Strongly
1.3. Medicine
2 5 5 - 5
Agree
purchases.
Strongly
Average Weighted Mean of Question Number 6 5
Agree
7. The app can correctly and completely generate the following reports:
Strongly
7.1. Inventory of stocks. 2 5 4 - 4.5
Agree
43
Strongly
7.2. Out of stocks
2 5 5 - 5
Agree
medicine.
7.3. Official Receipt. 2 3 1 - 2 Disagree
Strongly
7.4. Near expiring medicines. 2 5 5 - 5
Agree
7.5. Daily, weekly, and Strongly

2 5 5 - 5
monthly sales. Agree
Average weighted Mean of Number 7 4.3 Agree
8. I can easily determine the

Strongly
medicine’s generic and
32 - - 4.68 4.68
Agree
brand names.
9. I can conveniently order

Strongly
medicine online through the
32 - - 4.75 4.75
Agree
application.
10. The application facilitates

Strongly
the uploading of doctors’
32 - - 4.84 4.84
Agree
prescription efficiently.
11. Through the application, I
can conveniently select the Strongly

32 - - 4.78 4.78
date and time to pick up my Agree
ordered medicines.
44
45
12. I can easily upload proof
Strongly
of payment through the
32 - - 4.84 4.84
Agree
system.
13. I can seamlessly view my

Strongly
transaction history through
32 - - 4.78 4.78
Agree
the application.
Strongly
Average Weighted Mean of Functional Suitability 4.78
Agree
1. can easily create and log in to my account.
This question had a result and an average weighted mean of 4.79 - Strongly Agree.
This presented that the customers were very satisfied and were strongly agree on the
implementation of the system when they register and Login their account. This means also
that the system meets the requirements of the Pharmacy Easy app’s objective where they can
easily register and login an account. They registered an account on the Pharmacy Easy
Mobile app thru mobile online.
2. The system allows me to instantly search the available medicines
This question gathered the average weighted mean of 4.91 - strongly agree. It shows
that the system meets the requirements of the Pharmacy Easy app’s objective wherein the
customers can instantly search the available medicines thru the app.
3. I can conveniently update medicine stocks using the application.
A result of an average weighted mean of 5 - strongly agree which shows that the
admin can easily update the medicine stocks.
46
4. I can efficiently record the walk-in customers’ order.
It had a result with an average weighted mean of 4.5 - strongly agree. It indicates
that the admin efficiency records the walk-in customer order. And the system meets the
requirements of the system’s specific objective.
5. The app conveniently allows me to accept or reject onlineorders.
This question 5, gathered a result of 4.5 average weighted mean - strongly agree.
The result shows that the admin can accept or reject orders online.
6. I can effectively monitor the following using the application:
6.1. Medicine stocks.
This system’s question had a result of an average weighted mean of 5 - strongly
agree. It shows that the admin is allowed to monitor the medicine stocks. And it meets the
requirements of the system’s specific objective.
6.2. Sales history.
View sales history objectives gathered a result of an average weighted mean of 5 -
strongly agree. That shows that the admin is allowed to monitor view sales history which
the system’s objective met as regards the requirements of the system’s specific objective.
6.3. Medicine purchases.
Monitor medicine purchase’s objective had a result of an average weighted mean of 5
- strongly agree. It means that the admin can monitor the customer medicine purchases
either walk-in or through mobile app online. This objective meets the requirements of the
system’s specific objective.
47
For the objective six, which evaluated the admin side, the total average weighted
mean is 5 - strongly agree. This shows that the system meets all requirements of the
system’s objective.
7. The app can correctly and completely generate the following reports:
7.1. Inventory of stocks.
The question objective had a result of 4.5 average weighted mean - strongly agree. It
indicates the admin can generate the reports of inventory of stocks medicine, which means
the system meets all the requirements of the system’s objective.
7.2. Out of stocks medicine.
Out of stocks medicine’s objective, result of five average weighted mean - strongly
agree. This result shows that the admin can generate the reports of out-of-stock medicines.
The means the system meets the requirements and its objectives.
7.3. Receipt.
The admin commented that the official receipt is for the issued seller to the buyer as written
evidence on the sale of service or property or leasing properties, which the proponent
changed the Official Receipt to Receipt, which is a customer receipt. The average weighted
mean of this objective is 2 - disagree.
7.4. Near expiring medicines.
This had a result of five average weighted mean - strongly agree. This result shows
that the admin can generate reports of near expiry medicines, which means that the system
meets all requirements and the system objectives.
7.5. Daily, weekly, and monthly sales.
48
In question objective 7.5, it had an average weighted mean of 5 - strongly agree. It
indicates that the admin can generate reports, can add, or delete the daily weekly and monthly
sales. This specific objective meets the requirements of system’s specific objective.
In the question 7, the general total average weighted mean is 4.3 - Agree. This shows
that the system meets more than the average of the system objectives.
8. I can easily determine the medicine’s generic and brand names.
This item had a result of an average weighted mean, 4.68 - strongly agree. It shows
that the customer can easily determine the generic and brand name of medicine by typing
specific name or brand name in the app and it meets the system requirements of the
Pharmacy Easy app’s objective.
9. I can conveniently order medicine online through the application.
It had a result of average weighted mean of 4.75 - strongly agree. It indicates that
the customer can order a medicine thru online. And the system meets the requirements of the
system’s specific objective.
10. The application facilitates the uploading of doctors’ prescription efficiently.
This item gathered a result of 4.84 average weighted mean - strongly agree. The
result shows that the customer can upload the doctor’s prescription by purchasing medicine
that need the prescription of the doctor or physician. This means the system meets the
requirement of the system’s specific objective.
11. Through the application, I can conveniently select the date and time to pick
up my ordered medicines.
49
This system’s question objective gathered a result of 4.78 average weighted mean -
strongly agree. The result shows that the customer can conveniently select a date and time
to pick up their medicine orders which means that the system meets the requirements of its
specific objective.
12. I can easily upload proof of payment through the system.
This item gathered a result of 4.84 average weighted mean - strongly agree. The
result shows that the customer can easily upload the proof of payment through the mobile
app. This means the system meets the requirements of its specific objective.
13. I can seamlessly view my transaction history through the application.
This question objective gathered a result of 4.78 average weighted mean - strongly
agree. The result shows that the customer can view their transaction history through the
mobile app which means that the system meets the requirements of its specific objective.
For the Functional Suitability questionnaire, the overall total average weighted mean
is 4.78 with a descriptive equivalence of Strongly Agree. This shows that the system meets
all the requirements and specific objectives.
Medicine Ordering App with Online Ordering Medicine using Pharmacy Easy App for the
system performance efficiency.
50
14. The system works properly on my device.
No. User (AWM)

Descriptive
Equivalent
user
Performance Efficiency
14. The system works properly Strong

34 5 5 4.84 4.85
on my device. Agree
15. The system loads the Strongly

34 5 5 4.68 4.70
content quickly Agree
16. The system responds to

Strongly
every operation I make 34 5 5 4.75 4.76
Agree
immediately.
Strongly
Average weighted Mean of Performance Efficiency 4.77
Agree
This functionality had a rating with an average weighted mean of 4.85 - strongly
agree. It shows that the Pharmacy Easy System and app work properly to any device.
15. The system loads the content quickly.
agree. It shows the Pharmacy Easy System and app were loaded quickly.
16. The system responds to every operation I make immediately.
agree. It shows that the Pharmacy Easy System and app work without any logging or
crashing the system.
51
Moreover, the overall result of Performance efficiency functionality had an average
weighted mean of 4.77 - strongly agree. It means that the Performance Efficiency
functionality meets all the requirements of the system’s objective.
system reliability.
No.
User (AWM) Descriptive
Equivalent
user
Reliability
17. The system automatically
prompts me if I have
Strongly
inputted the wrong
34 5 4 4.87 4.85
Agree
credentials of password and
username.
18. I can upload the necessary

Strongly
files such as proof of
34 5 5 4.81 4.82
Agree
payment and
prescription instantly
19. The system displays
Strongly
accurate information on the
34 5 5 4.84 4.85
Agree
purchase history of
the product.
52
Strongly
Average Weighted Mean of Reliability 4.84
Agree
17. The system automatically prompts me if I have inputted the wrong
credentials of password and username.
This functionality had a rating with an average weighted mean 4.85 - strongly agree.
It shows that the system automatically prompts when the users input wrong credentials of
password and username.
18. I can upload the necessary files such as proof of payment and prescription
instantly.
This functionality had a rating with an average weighted mean 4.82 - strongly agree.
It shows that the customer can easily upload the payment and doctor’s prescription in the app.
19. The system displays accurate information on the purchase history of the
product.
agree. The result shows that the system and app have worked properly and displayed the
accurate information in the Purchase history of the product.
Furthermore, the overall result for Reliability functions had an average weighted mean
of 4.84 - strongly agree. It means that the Reliability functions meet all the requirements of
the system’s objective.
system Usability.
53
20. I am comfortable navigating through the system.
No. User (AWM)

Descriptive
Equivalent
user
Usability
20. I am comfortable navigating Strongly

34 5 5 4.81 4.82
through the system. Agree
21. The interface of the

Strongly
system is pleasing and easy 34 5 5 4.78 4.79
Agree
to learn.
22. I can quickly receive

Strongly
feedback whenever I forgot
34 5 5 4.84 4.85
Agree
to attach some
photos.
Average Weighted Mean of Usability 4.82 Strongly
Agree
agree. It shows that the users are comfortable using the system and app.
21. The interface of the system is pleasing and easy to learn.
agree. It shows that the users pleased the proponent UI design, and they can easily navigate
the system or app.
54
22. I can quickly receive feedback whenever I forgot to attach some photos.
agree. It shows that the system would prompt a message that they need to attach their photo
if the user forgot to attach their photo.
Furthermore, the overall result of Usability functions had an average weighted mean
of 4.82 - strongly agree. It means that the Usability functions meets all the requirements of
the system’s objective.
system compatibility.
No. User (AWM)

Descriptive
Equivalent
user
Compatibility
23. The system works on
various browsers such as Strongly

34 4 3 4.71 4.64
Chrome, Mozilla Firefox, Agree
and Internet Explorer.
24. The system loads in any

Strongly
different internet connection
34 5 5 4.81 4.82
Agree
such as fiber
and mobile data.
55
25. When I use the system on
Strongly
smaller or bigger screens, it
34 5 5 4.84 4.85
Agree
did not have any issues
with screen displays.

Strongly
Average Weighted Mean of Compatibility 4.77
Agree
23. The system works on various browsers such as Chrome, Mozilla Firefox,
and Internet Explorer.
agree. It shows that the system can work in any browser, and this means that the system
meets the requirements and set objectives.
24 The system loads in any different internet connection such as fiber and
mobile data.
agree. It shows that the system can load any different internet connections.
25. When I use the system on smaller or bigger screens, it did not have any
issues with screen displays.
agree. It shows that the system can use several types of screens without any issues with the
display in the screen.
56
Furthermore, the overall result of Compatibility functions had an average weighted
mean of 4.77 - strongly agree. It means that the Compatibility functions meets all the
requirements of the system’s objective.
system security.
26. The system requires a strong and unique password.
No. User (AWM)

Descriptive
Equivalent
user
Security
26. The system requires a

Strongly
strong and unique
34 5 5 4.78 4.79
Agree
password.
27. The system ensures OTP

Strongly
security for the user’s 34 5 4 4.70 4.71
Agree
data.
28. The system places

Strongly
restriction on the data I 34 5 5 4.78 4.79
Agree
am permitted to view.
Strongly
Average Weighted Mean of Security 4.76
Agree
57
This functionality had a rating with an average weighted mean of 4.79 - strongly agree.
It shows that the system was built to secure the created user account and it is not easily
hacked.
27. The system ensures OTP security for the user’s data.
This functionality had a rating with an average weighted mean of 4.79 - strongly agree.
It shows that the system ensures the user’s data security of customer and the admin.
28. The system places restriction on the data I am permitted to view.
agree. It shows that the system ensures the place restriction of the user’s data.
The overall result of Security functions had an average weighted mean of 4.76
- strongly agree. It means that the Security functions meet all the requirements of the
system’s objective.
Table 9. Overall total results of the System’s Function based on evaluation.
Average Weighted
System Functions Descriptive Equivalence
Mean
Functional Suitability 4.78 Strongly Agree
Performance Efficiency 4.77 Strongly Agree
Reliability 4.84 Strongly Agree
Usability 4.82 Strongly Agree
Compatibility 4.77 Strongly Agree
Security 4.76 Strongly Agree
58
General Average
4.79 Strongly Agree
Weighted Mean
For the overall total results of the System’s Function evaluation, with twenty- eight
(28) questions of Pharmacy Easy App, there were twenty-seven (27) questions that gained a
rating of Strongly Agree while one (1) question had an Agree rating. The rating based on
the evaluation sheets from the respondents of 2M Pharmacy of Bangoy Street Brgy.
Salvacion Panabo City have one (1) admin, one (1) staff and thirty-two (32) customers who
utilized the Pharmacy Easy App. The total of general average result of the evaluation of
Pharmacy Easy App: Online Medicine Ordering App using the Pharmacy Easy App was 4.79
in with a strongly agree descriptive equivalent. This shows that the Pharmacy Easy App
meets all the requirements of the system’s objective.
59
Chapter 4
CONCLUSION AND RECOMMENDATION
This chapter discusses the conclusion and recommendation of the capstone project
entitled Pharmacy Easy: Online Medicine Ordering App.
Conclusion
The Pharmacy Easy App were deployed by partnership with 2M Pharmacy. During
the deployment and maintenance phases, the developers evaluated, monitored, and inspected
the system to see if there were any bugs or errors, and then fixed them. The evaluation was
conducted with the owner, employees, and customers of 2M Pharmacy participating.
Moreover, the evaluation's findings include some primary data that were gathered
from the thirty-four end users who received evaluation forms at random. The ensuing
conclusion is that web applications and mobile apps satisfy consumers with a weighted
average mean of 4.79 and fully satisfy all system-specific objectives.
In addition, the first system’s specific objective which had an average weighted mean
of 4.79 with a strongly agree descriptive equivalent. The second, fourth and fifth system’s
specific objective resulted in an average weighted mean of five which had a descriptive
equivalence of strongly agree. And the third system’s specific objective gained a result of
an average weighted mean of 4.5, with a descriptive equivalence of strongly agree.
However, the sixth system’s specific objective had a result of average weighted mean of 4.3
which has an agree rating.
60
In conclusion, the evaluation of the System’s specific objective gained a general
average weighted mean of 4.78 and has a strongly agree descriptive equivalent which
means that it meets all the requirements of the system’s objectives.
Furthermore, this application was developed for the convenience of the customers of
2M pharmacy for them to easily order medicines online. And the Web application helped the
owner and employee of 2M Pharmacy to monitor and updates stocks, evaluate sales and
manage their inventory.
Recommendation
This section presented the recommendations and suggestions of developers regarding
the future implication of the Pharmacy Easy system.
The first recommendation of the developers is to improve and strengthen the system's
security features. Data and records of both the admin and customer sides must be secured and
safeguarded, especially since it involves money. Future developers should strengthen and add
security features that would guarantee the protection of the privacy and integrity of their data,
especially in creating accounts and logging in to their respective accounts. It should use
multifactor authentication and require complex and unique secure passwords and
authentication for all devices, prevent authentication bypass and require employees to store
passwords securely.
Moreover, to ensure the safeness of the data, both the admin and customer sides must
also Install antivirus and malware protection that would protect the device from viruses that
could destroy the data, slow down or crash the device, or allow spammers to send emails
through the account. Antivirus protection scans the files and incoming email for viruses and
deletes anything malicious.
61
Second, additional means of e-payment. There are many ways to pay online, and
future developers must have additional means of paying online, like cash and Pay Maya,
among others, this will give the customers an option, especially if they do not have a GCash.
The online chatbot must be added to cater their queries, especially in medicine.
Lastly, provide delivery services and GPS tracking. Future developers of the system
could add a delivery service in which instead of picking up the product they bought from the
store, the customer would have an option for product delivery and wait in their respective
houses when their product is delivered. Also, GPS tracking should be done when there is a
delivery service to benefit both parties - 2M Pharma and its customers. Developers also
recommend enhancing the generated report of the system. It includes the daily sales report
generated and the monthly sales report. Reports generated and printed should be more eye-
pleasing and presentable. Future developers should practice database normalization to
organize data tables properly. Database normalization helps to reflect data and relationships
without data loss or redundancy accurately.
62
REFERENCES
[1] CPP. (2009). Scope of Contemporary Pharmacy Practice: Roles, Responsibilities, and
Functions of Pharmacists and Pharmacy Technicians.
[2] Baker L., Wagner T., Singer S., Bundorf M. Use of the Internet, and email for health
care information: result from a national survey. JAMA 2003 May 14; 289(18):
2400-6.doi:10.1001/jama.289.18.2400.
[3] Desai K., Chewning B., Mott D. Health care use amongst online buyers of medications
and vitamins. Res Social Adm Pharm. 2015 Nov;11(6):844–58. doi:
10.1016/j.sapharm.2015.01.001.
[4] Aleksey Sukhanov. What is an App? [Accessed 18th October 2012]
[5] Fung CH., Woo H., Asch S. Controversies, and legal issues of prescribing and
dispensing medications using the Internet. Mayo Clin Proc. 2004 Feb;79(2):188–
94. doi: 10.4065/79.2.188.
[6] Orizio G, Merla A, Schulz PJ, Gelatti U. Quality of online pharmacies and websites
selling prescription drugs: a systematic review. J Med Internet Res. 2011 Sep
30;13(3): e74. doi: 10.2196/jmir.1795.
[7] US Congress 2008. [2018-05-22]. Ryan Haight Online Pharmacy Consumer
Protection Act of 2008.
[8] Mackey TK, Nayyar G. Digital danger: a review of the global public health, patient
safety and cybersecurity threats posed by illicit online pharmacies. Br Med Bull.
2016 Jun;118(1):110–26. doi: 10.1093/bmb/ldw016.
[9] Gabay M. Regulation of Internet Pharmacies: A Continuing Challenge. Hosp
Pharm. 2015 Sep;50(8):681–2. doi: 10.1310/hpj5008-681.

63
[10] Dudley J. Mail Order and Internet Pharmacy in Europe. Kidderminster UK:
James Dudley International Ltd; 2014. Entering the Digital Battleground.
[11] Dorsey PJ, Hellstrom WJ. Medscape. 2007. [2018-05-23]. The Illicit Sale of
Medications for the Treatment of Erectile Dysfunction
[12] Bate R. The Deadly World of Fake Drugs. Foreign Policy, Washington Post.
2008; 168:56–65.
[13] Shelar J., Delhi HC order: State FDA to crack down on e-pharmacies. The Hindu 2018.
[14] Mackey TK, Nayyar G. Digital danger: a review of the global public health, consumer
safety and cybersecurity threats posed by illicit online pharmacies. Br Med Bull.
2016;118(1):110–26.
[15] Gabay M. Regulation of internet pharmacies: a continuing challenge. Hosp
Pharm. 2015;50(8):681–2.
64
APPENDICES
65
APPENDIX – A
RECOMMENDATION
AND
DEPLOYMENT
66
APPENDIX – B
DEFENSES MINUTES
67
APPENDIX – C
CERTIFICATES
68
69
APPENDIX – D
QUANTITATIVES
RESULTS
70
Consolidated answer per question on survey questionnaire of admin and staff.
Rating
System functions AWM
1 2 3 4 5
Functionality Suitability - - - - -- -
1. I can easily create and log in to my account. - -- - -- 2 5
2. The system allows me to instantly search the - - - - 2 5

available medicines
3. I can conveniently update medicine stocks using - - - - 2 5

the application.
4. I can efficiently record the walk-in customers’ - - - 1 1 4.5

order.
5. The app conveniently allows me to accept or reject - - - - 2 5

online orders.
6. I can effectively monitor the following using - - - - - -

the application:
6.1. Medicine stocks. - - - - 2 5
6.2. Sales history. - - - - 2 5
6.3. Medicine purchases. - - - - 2 5
7. The app can correctly and completely generate the - - - -

following reports:
7.1. Inventory of stocks. - - - 1 1 4.5
7.2. Out of stocks medicine. - - - - 2 5
7.3. Official Receipt. 1 - 1 - - 2
71
7.4. Near expiring medicines. - - - - 2 5
7.5. Daily, weekly, and monthly sales. - - - - 2 5
Performance Efficiency - - - - --
8. The system works properly on my device. - - - - 2 5
9. The system loads the content quickly - - - - 2 5
10. The system responds to every operation I make - - - - 2 5

immediately.
Reliability - - - - -- 5
11. The system automatically prompts me if I have - - - 1 1 5

inputted the wrong credentials of password and
username.
12. I can upload the necessary files such as proof of - - - - 2 5

payment and prescription instantly
13. The system displays accurate information on the - - - - 2 5

purchase history of the product.
Usability - - - - --
14. I am comfortable navigating through the system. - - - - 2 5
15. The interface of the system is pleasing and easy - - - - 2 5

to learn.
16. I can quickly receive feedback whenever I - - - - 2 5

forgot to attach some photos.
Compatibility - - - - --
17. The system works on various browsers such as - - 1 1 -- 3.5

Chrome, Mozilla Firefox, and Internet Explorer.
18. The system loads in any different internet - - - - 2 5
72
connection such as fiber and mobile data.
19. When I use the system on smaller or bigger - - - - 2 5

screens, it did not have any issues with screen
displays.
Security - - - - --
20. The system requires a strong and unique - - - - 2 5

password.
21. The system ensures OTP security for the user’s data. - - - 1 1 4.5
22. The system places restriction on the data I am - - - - 2 5

permitted to view.
General Average Weighted Mean 4.83
73
Consolidated answer per question on survey questionnaire of Customer.
Rating
System functions AWM
1 2 3 4 5
Functionality Suitability - - - - - -
1. I can easily create and log in to my account. - -- 1 5 26 5
2. The system allows me to instantly search the - - - 3 29 5

available medicines
3. I can easily determine the medicine’s generic - -- 1 7 24 5

and brand names.
4. I can conveniently order medicine online - - - 8 24 5

through the application.
5. The application facilitates the uploading of - - - 9 23 5

doctors’ prescription efficiently.
6. Through the application, I can conveniently - - 1 5 26 5

select the date and time to pick up my
ordered medicines.
7. I can easily upload proof of payment through - - 1 5 26 5

the system.
8. I can seamlessly view my transaction history - - 1 2 29 -

through the application.
Performance Efficiency - - - - --
9. The system works properly on my device. - - 1 3 28
10. The system loads the content quickly - - 1 8 23
11. The system responds to every operation I - 1 - 5 26

make immediately.
74
Reliability - - - - --
12. The system automatically prompts me if I - - - 4 28

have inputted the wrong credentials of
password and username.
13. I can upload the necessary files such as - - 3 4 27

proof of payment and prescription instantly
14. The system displays accurate information - - - 5 27

on the purchase history of the product.
Usability - - - - --
15. I am comfortable navigating through the - - 1 4 27

system.
16. The interface of the system is pleasing and - - 1 7 24

easy to learn.
17. I can quickly receive feedback whenever I - - 1 3 28

forgot to attach some photos.
Compatibility - - - - --
18. The system works on various browsers - - 1 7 24

such as Chrome, Mozilla Firefox, and
Internet Explorer.
19. The system loads in any different internet - 1 - 1 30

connection such as fiber and mobile data.
20. When I use the system on smaller or bigger - - - 5 27

screens, it did not have any issues with
screen displays.
Security - - - - --
21. The system requires a strong and unique - - 1 6 25

password.
22. The system ensures OTP security for the - - 1 7 24
75
user’s data.
23. The system places restriction on the - - - 9 23

data I am permitted to view.
Result of overall general average weighted mean.
System Functions Average Weighted Mean
Functional Suitability 4.78
Performance Efficiency 4.77
Reliability 4.84
Usability 4.82
Compatibility 4.77
Security 4.76
76
APPENDIX – E
EVALUATION SHEETS
77
APPENDIX – F
ERRORS FOUND
78
APPENDIX – G
SAMPLE REPORTS
79
APPENDIX – H
SYSTEM
SCREENSHOTS
80
APPENDIX – I
PHOTO
DOCUMENTATION
81
APPENDIX J
CURRICULUM VITAE
82
CURRICULUM VITAE
PERSONAL DATA
Full Name: Ariel A. Alayon
Address: Purok 1-A, Alejal Carmen, Davao del Norte
Mobile Number: 09512585266 Email: ariel.alayon@dnsc.edu.ph
Marital Status: Single Date of Birth: October 05,1997
Gender: Male Country of Origin: Philippines
Nationality: Filipino Language: Filipino, English
EDUCATIONAL ATTAINMENT
Graduated School Year
College Davao Del Norte State College 2023
High School Alejal National High School 2014-2015 2015
WORK EXPERIENCE
83
CURRICULUM VITAE
PERSONAL DATA
Full Name: Aj V. Delos reyes
Address: Purok 1-A, Balet Babak Igacos Davao del Norte
Mobile Number: 09704589421 Email: Aj.delosreyes@dnsc.edu.ph
Marital Status: Single Date of Birth: April 19,1999
Senior High Balet Senior High School 2018
Junior High Balet National High School 2016
WORK EXPERIENCE
 Radio broadcasting
84
CURRICULUM VITAE
PERSONAL DATA
Full Name: Kristine C. Gerbolingo
Address: Purok 7-A, Brgy. Tibal-og Sto. Tomas Davao Del Norte
Mobile Number: 09381537643 Email: kristine.gerbolingo@dnsc.edu.ph
Marital Status: Single Date of Birth: September 6,1999
Gender: Female Country of Origin: Philippines
Senior High Sto. Tomas National High School 2018
Junior High Sto. Tomas National High School 2016
WORK EXPERIENCE
 Wela School System – Quality Assurance Intern - 2023
85
CURRICULUM VITAE
PERSONAL DATA
Full Name: Dexter B. Lomod
Address: Purok 10 Bosque, Bunawan DC
Mobile Number: 09932765066 Email: dexter.lomod@dnsc.edu.ph
Marital Status: Single Date of Birth: December 03,1999
Senior High Bernardino B Bosque NHS 2018
Junior High Bernardino B Bosque NHS 2016
WORK EXPERIENCE
 Pisowifi/Pisonet Installer
 CCTV installer
 PTP internet service installer
86
CURRICULUM VITAE
PERSONAL DATA
Full Name: David Jones M. Lumen
Address: Purok 1, Quezon, Panabo City, Davao del Norte
Mobile Number: 09677141949 Email: davidjones.lumen@dnsc.edu.ph
Marital Status: Single Date of Birth: November 7, 1998
Senior High Southern Davao National High School 2018
Junior High Southern Davao National High School 2016
WORK EXPERIENCE
 Double Davao Printing and Paper Packaging Corporation -2022
87

Final-Pharmacy-Easy (AutoRecovered)

Uploaded by

Copyright:

Available Formats

Final-Pharmacy-Easy (AutoRecovered)

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Final-Pharmacy-Easy (AutoRecovered)

Uploaded by

Copyright:

Available Formats

Pharmacy Easy: Online Medicine Ordering App

Davao Del Norte State College

New Visayas, Panabo City

A proposed project title submitted by:

Dexter B. Lomod David

research work to complete the research successfully.

Medicine Ordering App" aims to simplify ordering medicine through a user-friendly

to ensure operational acceptability. During the system deployment the developers

meets the user requirement in terms of functional suitability, performance efficiency,

reliability, usability, compatibility, and security. Based

efficiently manage medication dispensing of prescriptions and keeping track of

Keywords: Pharmacy Information System, Online medicine ordering, Inventory

management for Medicine.

PRELIMINARY PAGES Page No.

Background of the Study………………………………………………………… 11

Significance of the Project………………………………………………………. 15

Scope and Limitation……………………………………………………………. 16

Project Team Organization…….…………………………. 19

Work Breakdown Structure……………… 20

Context Data Flow Diagram……………………………… 24

Use Case Diagram…………………………………………… 25

Diagram 0 Flow Diagram……………………………… 26

Technology and Tool…………………………………………… 30

XAMPP Control Panel…………………………………………… 30

CHAPTER 3 – RESULT AND DICUSSION……………………………… 41

CHAPTER 4 – CONCLUSION AND RECOMMENDATION

APPENDIX B – DEFENSES MINUTES………………………….... 66

Figure 1. Project Team Organization……. …..…………………… 20

Figure 2. Work Breakdown Structure…………………………… 21

Figure 3. GANTT Chart………………….………… 22

Figure 4 & 5. Existing System Business process of | pharma Sys…………… 24

Figure 6. Context Data Flow Diagram …………….………… 25

Figure 7. Use Case Diagram ………………………………. 26

Figure 8. Diagram 0 Data Flow……………………………………… 27

Figure 9.1 System Flowchart in Admin …….……………………… 28

Figure 9.2 System Flowchart in Customer…………………………… 29

Figure 9.3 System Flowchart in Pharmacy Assistant…………………… 30

Figure 10. XAMPP Control Panel v3.2.2………………………………… 31

Figure 11. Sample Code of using Sublime Text……………………… 32

Figure 12. PHPMyAdmin Interface……………………………………… 32

Figure 13. Android Studio………………………………………………… 33

Figure 14. Entry-Relationship Diagram ………………………………… 34

Table 1. Admin Table…………………...…………… 34

Table 1.2 Pharmacy Table………………….………………… 36

Table 1.3 Medicine Table…………………………………………. 36

Table 1.4 Payment Table……………….…………….………………… 37

Table 1.5 Supplier Table…….………………………………………… 37

Table 1.6 Customer Table…...…………………………………………… 37

Table 2. Scale of the evaluation sheet of Pharmacy easy……………… 39

Medicine Ordering App with Online Ordering Medicine using

Medicine Ordering App with Online Ordering Medicine using

Table 6. The Summary of the overall quantitative results of Pharmacy Easy:

Online Medicine Ordering App with Online Ordering Medicine using

Table 8. The Summary of the overall quantitative results of Pharmacy Easy:

Table 9. Overall total results of the System’s Function based on 55

Background of the Study

effectively computerize most people's occupations.

In addition, the pharmacy practice encompasses the evaluation and interpretation of

medical orders, the administration of pharmaceuticals, the dispensation of prescribed drugs