INTERNATIONAL HIGHER POLYTECHNIC INSTITUTE OF ANGOLA

Created by Presidential Decree No. 168/12 of July 24

DEPARTMENT OF ENGINEERING AND ARCHITECTURE

FINAL MONOGRAPH PROJECT

DEVELOP A DESKTOP APPLICATION FOR THE

MANAGEMENT OF THE FARMACY OF LIGHT 3

Prepared by: José Micole Quissanga

Luanda, 2022
 INTERNATIONAL POLYTECHNIC HIGH INSTITUTE OF ANGOLA
Created by Presidential Decree No. 168/12 of July 24
DEPARTMENT OF ENGINEERING AND ARCHITECTURE

FINAL MONOGRAPH PROJECT

DEVELOP A DESKTOP APPLICATION FOR THE

MANAGEMENT OF THE LIGHT PHARMACY 3

Prepared by: José Micole Quissanga

Guided by: Jofrásio da Silva Pedro

Final course work presented to

Department of Engineering e
Architecture of the Higher Institute
International Polytechnic of Angola
as a requirement for obtaining the degree of
Bachelor's degree in Computer Engineering.

Luanda, 2022
DEDICATION
 EPIGRAPH

A responsible young person studies not just for the pleasure of rewards or fear of
immediate punishment. He knows that he is not doing a 'favor' to the teachers or the family.
He believes he is building his own future. That is what motivates him.
António Estanqueiro
 THANKS

.
 SUMMARY

A desktop pharmacy management application is software that can be installed

on a computer and is used to perform specific tasks facilitating management and
administration of the pharmaceutical establishment focused on generating results
positive and in the excellence of the quality of service offered to customers.
With the aim of developing a desktop application for managing pharmacies.
A case study was conducted at Farmácia da Luz 3 with the aim of improving management.
of services, contribute to the technological development of pharmacy and provide a
quality service to customers and efficiency, as we are in the era of
technology has emerged to facilitate and improve our activities.
For the development of this project, the agile methodology was used
software development SCRUM and the following tools: Programming Languages of
programming: Java, Database: MYSQL Query Browser, Software of
development: NetBeans IDE 8.0.2, Data modeling: Visual Paradigm for
UML to ensure ease in the development process and DBDesigner 4 for
develop the Entity Relationship [Link] the implementation of the system
allow yourself to achieve better results regardinginvoice issuance, stock management,
sales management, user control, product registration, issuance of
daily, weekly and monthly reports, thus facilitating the day-to-day activities of pharmacists and
ensure efficient service.
Desktop. Management. Pharmacy. Clients.
 ABSTRACT

TABLE OF CONTENTS
LIST OF ABBREVIATIONS AND ACRONYMS

UML – Unified Modeling Language

SQL – Structured Query Language
GDP - Gross Domestic Product
WHO – World Health Organization
IT - Information Technology
HIS - Hospital Information System
NGO - Non-Governmental Organizations
UC- Use Case
ISIA - Higher Polytechnic Institute of Angola
INDEX OF FIGURES
LIST OF GRAPHS
GENERAL INDEX
CHAPTER I: INTRODUCTION
1.1.2 JUSTIFICATION OF THE THEME

1.1.3 DELIMITATION OF THE THEME

1.1.4 FORMULATION OF THE PROBLEM
1.2 FORMULATION OF HYPOTHESES
1.3 OBJECTIVES
1.3.1 General Objective
1.3.2 Specific Objectives
1.4 STRUCTURE OF THE WORK
CHAPTER II: THEORETICAL FOUNDATION
2.1 HEALTH
2.1.1 HEALTH IN ANGOLA
2.2 PHARMACY
2.2.1 CLASSIFICATION OF PHARMACIES ...
2.2.2 TYPES OF PHARMACIES
[Link] COMMUNITY PHARMACY
[Link] COMPOUNDING PHARMACY

[Link] HERBAL PHARMACY

[Link] HOMEOPATHY PHARMACY

[Link] HOSPITAL PHARMACY

2.2.3 DIFFERENCE BETWEEN PHARMACIES AND DRUGSTORES……………

2.3 HISTORY OF PHARMACY

2.3.1 THE PHARMACY IN THE WORLD

2.4 DESKTOP APPLICATION

2.4.1 ADVANTAGES AND DISADVANTAGES OF DESKTOP AND WEB APPLICATIONS ...
2.5 INFORMATION SYSTEM IN PHARMACIES
CHAPTER III: METHODOLOGY, ANALYSIS AND INTERPRETATION OF
RESULTS
3.1 TYPE OF STUDY
3.2 METHODS AND INSTRUMENTS USED FOR DATA COLLECTION
3.3 PROCESSING AND TREATMENT OF INFORMATION
3.4 GATHERING OF INFORMATION
3.5. ANALYSIS AND INTERPRETATION OF RESULTS ………………………..
3.6 SYSTEM REQUIREMENTS ...
3.7 SPECIFICATION
3.7.3 ENTITY RELATIONSHIP MODEL
3.8 IMPLEMENTATION
3.8.1 TECHNIQUES AND TOOLS USED ...
[Link] JAVA
[Link] MYSQL ...
[Link] MYSQL QUERY BROWSER ...
[Link] NETBEANS IDE 8.0.2
[Link] SCRUM AGILE DEVELOPMENT METHODOLOGY ...
3.9 OPERATIONALITY OF IMPLEMENTATION ...
CHAPTER I: INTRODUCTION
The community pharmacies that we currently know are characterized by two
different functions: the promotion of public health and the transmission of knowledge
regarding the medications. However, for it to reach this format, the pharmacy
has undergone several changes throughout the history of humanity: from the first
uses of plants for medicinal purposes, until the emergence of the pharmacy and, finally,
moving towards community pharmacy centered on the needs of society,
adding to the profession various activities provided by professionals
Pharmacists. The profession can be practiced in hospitals, in the industry and in
wholesale distribution, among others, being that the pharmacist is designated as
"medication specialist" is one of the public health agents. To each of these
sectors exist associated with distinct areas such as scientific, technological, technical and
among others.
The technological field has undergone immeasurable evolution in recent years in terms of
very significant in the historical sphere. Nowadays, the professional has to
update to keep up with the launch of thousands of new programs daily.
Electronic communication has also made a great leap for technology. There are some
years, to communicate with someone instantly I had access to the telephone, however,
for the attachment of documents, written information, among others, were linked
only to the post office service, where information could take days, weeks and
take months to reach the final recipient. Today, in the age of technology, all of this can
to be done in a matter of seconds. (Chinarelli, 2012).
In the field of health, the use of computerization must be linked to the need for
speed and objectivity at work, not only in the evolution of instruments and
machinery that facilitates the life of health professionals, just like in the part
administrative, which encompasses sales control, report management, registration
of clients and medications, among several other features that make it easier
the life and work of people who use computerization in this field.
 1.1.2 JUSTIFICATION OF THE THEME

The need to find viable solutions to meet the need for

improving the management of Farmácia da Luz 3 motivated us to spare no effort in
present an appropriate solution for the situation of the Pharmacy in question, which is the
need for a stock management system that allows issuing invoices, reports,
register products, users, clients, suppliers and to facilitate and increase the
quality of the services at Farmácia da Luz 3, given that we are in an era
digital/technological, it is necessary to automate and ensure the security and integrity of
data, also facilitating the work of the employees.
 1.1.3 DELIMITATION OF THE THEME
The project will be limited to the process of stock management, sales, and registration of
users, products, suppliers, issuance of reports and invoices.
Being a Desktop application, it has some limitations due to its nature such as
like:
1.1.4 FORMULATION OF THE PROBLEM
The Pharmacy of Light 3, located in the Sagrada Esperança neighborhood, Encafé street is a
private establishment for the sale of medicines and other products that are part of
the basic needs of the surrounding population. It has existed for more than 3 years, but does not
has a system for issuing invoices, controlling sales, stock management and
report issuance. The lack of a system has caused a lot of embarrassment in
issuance of the financial report, in stock control and in customer service. As the
Will the system to be implemented improve the management of Farmácia da Luz 3?
1.2 FORMULATION OF HYPOTHESES

H1: The system to be developed could improve the management of services at the Pharmacy of
Light 3.

H2: The system to be developed will contribute to technological development of

Pharmacy of Light 3.
.
1.3 OBJECTIVES

1.3.1 General objective

Develop a Desktop management Application for Farmácia da Luz 3.

1.3.2 Specific Objectives

1. Conduct a study on the main concepts of Pharmacy management.

2. Characterize the pharmaceutical management systems that exist in the global market
to understand the nature of its functioning.
3. Describe the technologies, methodology, and tools used in the proposed solution.
4. Carry out the analysis and design and generate the output artifacts (diagrams) from the
selected methodology.
5. Develop the proposed system based on the artifacts generated in the Analysis stage.
and Design.
6. Identify viable mechanisms for data registration.
7. Conduct tests of the implemented functionalities.
1.4 STRUCTURE OF THE WORK

The work is organized in the form of chapters. The first chapter presents a
introduction about the subject and its objectives, with the aim of providing the
necessary information for your understanding. The second chapter describes the
concepts that are part of the theoretical foundation of this work. The third chapter
it deals with the implementation of the system, detailing the specification and development of

same. It still brings the operationality of the system, shows the techniques and tools
used to develop the system. The fourth chapter presents the conclusions, well
as suggestions for other future work.
CHAPTER II: THEORETICAL FRAMEWORK
This chapter addresses topics to be presented in the following sections, which
fundamentals the development of the desktop pharmacy management application, such as
Health
information, Information System in Pharmacies, Related Works and State
art.

2.1 HEALTH
Health is a fundamental human right and one of the main indicators.
of development and the quality of life of populations, having consequences
directly in the present and future of individuals, communities, and countries. (CAPSA, 2016).

In this way, health is considered one of the elements of quality of life and a
the objective conditions for human development, and not as its
set. From this point of view, health must be identified as vitality
psychic-physiological, that is, as a psychophysiological capacity for active exercise of
each individual for their fulfillment in life. Health, psychobiological capacity, is,
certainly, a partial condition for individuals' fulfillment in life, a
condition that, at the same time, encompasses and is conditioned by the determinations of
your existence as a biological being. (FARIA, 2009).

2.1.1 HEALTH IN ANGOLA

The health status of the Angolan population is characterized by low life expectancy.
at birth, high rates of maternal and infant mortality, a heavy burden of diseases
transmissible and increasing chronic and degenerative diseases as well as mortality
avoidable premature.

Despite the efforts of recent years, the health sector remains underfunded, which
it has not allowed consistent advances, especially in the more isolated areas.
The total health expenses are calculated at 5% of GDP. The expenditures
government spending on health accounts for only 4.1% of total expenditure, which is
relatively low even when compared to the average of African countries
Sub-Saharan - 9.5%. Public spending on health was, in 2005, 1.5% of GDP.
while with education it represented 2.6% and with military expenditure 5.7%.

The Health Service System of Angola has three levels. The first level is
consists of health centers / municipal hospitals, rural and urban, and also by
health centers of companies totaling 228. This 1st level also includes the
health posts and the sanitary units of companies, totaling 1453. The second
The level is made up of General Hospitals, under provincial control, totaling 32.
the third level is made up of Central Hospitals, which are of national reference,
total of 8. (WHO 2010, p.17).
PHARMACY
The word "pharmacy" derives from the Greek term pharmakon which takes the meaning of
medicine. This term is associated with the Greek goddess Pharmakis who was the holder of knowledge.
therapeutic of plants.
The Pharmacy is a unit for the provision of services aimed at providing assistance.
pharmaceutical, health care and individual and collective sanitary guidance, in which
process the manipulation and/or dispensing of magistral, official medicines,
pharmacopeial or industrialized, cosmetics, pharmaceutical inputs, products
pharmaceuticals and related.

2.2.1 CLASSIFICATION OF PHARMACIES

Pharmacies are classified according to their nature as:
I - pharmacy without manipulation or drugstore: dispensing establishment and
drug trade, medications, pharmaceutical inputs and related items in their
original packaging;
II - pharmacy with compounding: establishment of formula compounding
master's and official, drug trade, medications, pharmaceutical supplies and
correlates, understanding the dispensing and the private unit service
hospital or any other equivalent medical assistance.

2.2.2 TYPES OF PHARMACIES

The difference between pharmacies is related to the type of medication they have.
manipulated or sold. The medications sold in pharmacies can be from
plant or chemical origin. The function of the drugs may also vary, being able to be
cosmetics, homeopathic, dietary supplement (used in orthomolecular medicine)
among others.

[Link] COMMUNITY PHARMACY

Also known as a retail pharmacy, the community pharmacy is the most common type.
pharmacy acquaintance. It is this type that is known to be the most traditional like the pharmacy of
pharmacist.

[Link] COMPOUNDING PHARMACY

This establishment sells compounded medications, that is,

prepared in a laboratory by a qualified professional. However, for the
it is essential to present a prescription for the manipulated medication to be produced
medical. Based on the medical prescription, the compounding pharmacy prepares a formula.
specific, with the exact dosage and quantities for each client. The pharmacy of
manipulation differs from other types by providing specific products for its
customers, in addition to providing quality and attentive service and employees
qualified.

[Link] PHYTOTHERAPY PHARMACY

This pharmacy sells medications whose preparation base is the

plants. The components used in the preparation of herbal medicines can be leaves,
stems, roots, flowers, and seeds of plants that have pharmacological effects
proven. Despite the benefits generated by medicinal plants, it is necessary
be careful during the preparation of these medications. The quality must be checked.
of the plant used, as well as the presence of the healing substances. Without the due
quality control, the medication can pose a danger to the user, due to
of toxic effects (contamination by microorganisms or pesticides).

[Link] HOMEOPATHIC PHARMACY

Homeopathy seeks to treat the patient as a whole, not just addressing one
specific disease. The principle of this practice is to rebalance the organism
human, since the emergence of diseases indicates an imbalance. Homeopathy
deals with both physiological diseases (gastrointestinal problems, gynecological,
dermatological and respiratory issues) as well as emotional problems. However, it is not
It is advisable for patients with more serious illnesses, such as cancer and AIDS, to abandon
the traditional treatment.

[Link] HOSPITAL PHARMACY

Hospitals, whether public or private, have pharmacies

free provision of industrialized medications to the patients served there. To
Unlike other types of pharmacies, hospital pharmacies do not require authorization.
to work, since they do not sell the medications.

2.2.3 DIFFERENCE BETWEEN PHARMACIES AND DRUGSTORES

Even though both sell medications, there is a difference between a drugstore and a pharmacy.
Both are establishments for the dispensing and trade of drugs, medications,
pharmaceutical supplies and related items in their original packaging. However,
Pharmacies will be able to carry out broader activities than drugstores.

The pharmacy is an establishment for the preparation of magistral and officinal formulas,
trade in drugs, medications, pharmaceuticals and related materials,
understanding the dispensing and the private care of a hospital unit or
or any other equivalent medical assistance.

While the drugstore is an establishment for the dispensing and sale of drugs,
medications, pharmaceutical supplies and related items in their original packaging.

In other words, the pharmacy is the place that has a laboratory for the preparation of formulas.
prescribed by qualified professionals (such as doctors, dentists, nutritionists, etc) and
which can also sell industrialized products, while the pharmacy only
sells industrialized products and some other items, such as cosmetics, supplements of
first-aid and even convenience items.
However, a drugstore can also be referred to as a pharmacy, because it contains a laboratory.
inside it, however, these are rare cases, since most drugstores only
markets the medicines.

2.3 HISTORY OF PHARMACY

The mission of pharmaceutical practice is to provide medication and other products and services.
for health and to help people and society use them in the best possible way.
(WHO report, p. 4, 1996).

Until the early 20th century, the pharmacist was the reference professional for
society in relation to the medication, acting and exerting influence on
All stages of the medication cycle. At this stage, in addition to storage, distribution and
dispensation of the medication, the pharmacist was also responsible for the preparation
from, practically, everything
o arsenal available (GOUVEIA, 1999).
At first, there was a distancing of the pharmacist from these
establishments.

Over time, it became clear that it is the doctor's responsibility.

for the results of pharmacotherapy and, to the pharmacist, provide support services
adequate and specialized knowledge about the use of the medication.
According to Bonal (2001), the pharmacist is the last professional to intervene before that
the user takes their medication, which places them in a position of authority
which should be utilized for the benefit of the individuals assisted by the healthcare system.
Recognizing this opportunity, in the 1990s, Hepler and Strand, in the USA,
they propose a new model of patient-centered action, called Attention
Pharmaceutical.

In this way, the path to be recommended for pharmacies to become

characterized as health establishments is the provision of assistance
effective pharmaceutical, in which the pharmacist is the main agent in ensuring the use
safe and effective use of medications by the population.

2.3.1 THE PHARMACY IN THE WORLD

The Ebers Papyrus, dated 1550 B.C., contains over 8,000 medicinal formulas.
(DIAS, 2006).

The first pharmacy, called Botica, was only opened in 754 BC.
Baghdad, current Iraq (FCFRP-USP, 2006).

Galeno (122-199 AD), considered the 'Father of Pharmacy', proposes a theory in

which medications should have properties opposite to the causes of the disease
to be able to combat it (BARROS, 2002; DIAS, 2006).
In the 19th century, the first Schools of Pharmacy emerge in universities and
also the first laws and regulations, as well as some codes of ethics.
(ZUBIOLI, 2005).

Important therapeutic discoveries of the 1930s and 1940s, related to

antimicrobials, drove the scientific community in the search for new
methodologies, starting the process of growth in the industrial sector. With this, the
compounding pharmacies were no longer necessary, as the medications already came
ready in the form of pharmaceutical specialties (ANGONESI, 2008).

The Code of Ethics of the American Pharmacists Association (AphA), established in 1952,
that pharmacists could not discuss the therapeutic effects of
medications with the patients and that they should refer them to the doctor or
dentist, in case there were any doubts.

Questions about the social function of pharmacies have begun to arise.

1969, with the modification of the professional Code of Ethics in the US, the pharma-
therapists were encouraged to make available to each patient all of their
skills and knowledge.

The global movement to revalue the role of pharmacists in assistance to

health gained momentum with the report from the World Health Organization (WHO)
titled 'The Role of the Pharmacist in the Health Care System', prepared
in December 1988.

In 1990, Hepler and Strand published a paper in the journal Hospital Pharmacy
what would influence the entire pharmaceutical profession in the following years: Opportunities
Opportunities and responsibilities in pharmaceutical care
pharmaceutical attention). These authors argue that community pharmacists
they must be prepared to take on the responsibility of preventing morbidity and mortality
related to the irrational use of medications and adopting a patient-centered approach
patient. This new model of action has been called 'Pharmaceutical Care',
Translated into Portuguese as 'Pharmaceutical Care'.

2.4 DESKTOP APPLICATION

By definition, a desktop application is any software that can be installed on a
A computer is used to perform specific tasks. Some desktop applications
they can also be used by multiple users in a networked environment.
Software development began with desktop applications, that is, those that could
to be used directly on the computer, without relying on an Internet connection. With the
With the advent of the internet, web applications gained importance. Examples of applications
desktops are Word, Excel, Media Player. Examples of web applications are the
e-commerce, social media. (Dênis, 2017)
Currently, every technology enthusiast or someone who has a simple computer
at home he is known as "desktop. But where did this word come from and
When did we start using it? The term was coined earlier, but it became established.
it was the same with the publication of "Computers and Automation," from November 1966,
that already brought up topics discussed until the present days.

The text that popularized the term was written by Rudy Stiefel, president of the firm of
Infotran consultancy
"Desktop" was first used in the United States in 1958, when the
people characterized objects that could be placed on a table. In this
At that time, computers were much larger than today's PCs, they were
really big, capable of occupying an entire room.
In the mid-1960s, however, this scenario was changing, just like the whole
market. This is what "Computers and Automation" highlighted in the article that popularized
on desktop. Below, the introduction of "Computers large or small? In which direction will
Where are they going? ('Large or small computers? In what direction are they going?')
by Rudy Stiefel, then president of the engineering consulting firm Infotran.
Web applications use a web browser such as Mozilla Firefox, Internet Explorer,
Google Chrome, among others, as an interface. This is one of the reasons why
web applications are so popular nowadays, after all every computer has
browsers and internet, allowing access to the same application from any system
operational (Linux, Windows, Android, MacOS), which does not occur with applications
Desktop, which normally works on only one or the other operating system.
Although, with some type of work, it is possible to do the same code.
function on different operating systems. (Dênis, 2017)
 2.4.1 ADVANTAGES AND DISADVANTAGES OF DESKTOP AND WEB APPLICATIONS

Desktop applications Web Applications

More reliable and secure as it is difficult to access. They run a greater risk of being modified.
internal application code by a malicious user

The authentication and security mechanisms

They present better mechanisms of
they can be good or bad, it depends on the architecture
authentication and authorization
from the application

They risk a disaster affecting the They run the risk of becoming unavailable for
application, as they may be exposed to a some time, especially if there is
malicious user problems with the Internet connection

The user experience can be good The user experience can be good

Large data entries work in a way Large data entries can become
well smooth committed

They make good use of the machine's resources.

They share resources with other users and even
even with other companies

They tend to be more restrictive regarding access to They make better use of interaction resources.
other Web applications with the Web and other tools

They are easier to be developed They are more difficult to develop.

They usually cannot be accessed from anywhere

They are accessible from anywhere
place

Restricted to an operating system Do not depend on the operating system

Table 1 – Advantages and disadvantages of Desktop and Web applications.

2.5 INFORMATION SYSTEM IN PHARMACIES
Computerization is very important for reducing work time, greater
reliability and speed in the production of information, particularly in relation to
health system, which is complex and has numerous components. The use of
Computer science in a pharmacy service aims to facilitate the pharmacist's actions,
improving patient access to faster and updated information; facilitating the
stock management providing better access to acquisition statistics,
waivers and stock sizing; and achieve maximum efficiency with the least
cost when better evaluating the workload and distributing resources (BRAZIL, 1994).
The computerization of the pharmacy provides, more quickly, various information that
they can facilitate management, such as working hours, the number of professionals
involved, the data of each medication, its validity, storage conditions,
the cost control per patient or per ward, among others (BRAZIL, 1994).
Computer science can contribute significantly to distribution (dispensing).
two medications, regardless of the chosen system, with the system that presents
the best yield is that of unit dose. The computerized system reduces the possibility
of medication errors and also allows unused products to be returned to
pharmacy stock, generating savings for the institution (BRAZIL, 1994).
Even in collective dispensing systems, computerization brings various
benefits, such as automatic stock replenishment, product coding and
use of forms. Regarding information about medications, the use of
Computer science is essential for access to the various existing catalogs (BRAZIL, 1994)
CHAPTER III: METHODOLOGY, ANALYSIS AND INTERPRETATION OF
RESULTS

This chapter presents the characteristics of the developed system. Furthermore, they are
described the gathering of information, analysis, and interpretation of the data,
specification of functional and non-functional requirements, the use case diagrams and
the activity diagram. The modeling of the diagrams was done using the tool
Visual Paradigm for UML. For modeling the Entity-Relationship Model
(MER) used the MySql Query Browser tool. The
techniques and tools used in the implementation process, the operability of
system and the results obtained.

3.1 TYPE OF STUDY

This research is based on bibliographic research. As for its nature, it is research.

Applied because it is motivated by the solution of concrete problems,
practical and operational and is also called empirical research, as the researcher
you need to go to the field, talk to people. As for the approach to
the problem is qualitative and descriptive research, as it is concerned with describing the
phenomena through the meanings that the environment manifests. As for the objectives
Descriptive research is that which analyzes, observes, records, and correlates aspects.
(variables) that involve facts or phenomena, without manipulating them. As for the
technological procedures is a field study because the problem is a reality in
which needs to be deepened through direct observation, if the explanations were captured and
interpretations of what occurs in that reality.

3.2 METHODS AND INSTRUMENTS USED FOR DATA COLLECTION

The scientific method used is: observation because it is the visualization of a fact or
phenomenon, repeatedly and, problematization because it corresponds to the execution of
Questioning about the observed fact. Technique used: Sample - where it worked -
only with part of the universe, as only the people involved in the process
were interviewed.
The instrument used for data collection was the structured interview.
where the information was obtained through previously formulated questions.

3.3 PROCESSING AND HANDLING OF INFORMATION

The process and treatment of all information was done using the tools Word, Excel.
the Visual Paradigm for UML.
3.4 GATHERING INFORMATION

The developed solution arose from the need to automate and improve the
inventory management services, control of entries and exits, issuance of invoices and
reports, product registration, clients, user control, and data security
from the Pharmacy. A system was developed for the management of the pharmacy, in such a way
to facilitate the control of activities in the Pharmacy of Luz 3. It was taken into consideration
requirements such as ease of use, interactivity, task automation, agility
in communication and data integrity.
The proposed system allows the manager to register products, users, companies,
suppliers, grant permissions to users, issue reports and to users issue
invoices, reports.
Currently, the Pharmacy has no management system.
To ensure the security of the pharmacy's private information, the system has the
access control according to the user profile. This way, each type of
user registered with the necessary permissions to carry out their work.

3.5. ANALYSIS AND INTERPRETATION OF RESULTS

3.6 SYSTEM REQUIREMENTS
The requirements describe what the system should do. They are classified into
functional requirements and non-functional requirements. Functional requirements are
features that the system must have and the behavior of the system in
specific situations, and may also specify what the system should not do.
Non-functional requirements are constraints on the services or functions provided by
system, such as usability, hardware, security.
Table 1 presents the functional requirements planned for the system and its
traceability, that is, link to the associated use case(s).
FUNCTIONAL REQUIREMENTS Use case

The system must allow user registration.

The system must allow the registration of products.
The system should allow for the registration of companies.

The system must allow the registration of suppliers

The system must allow the issuance of invoices.
The system must allow the issuance of reports.
The system should allow inventory management.
The system must allow for the cancellation of invoices.

Table 2 – Functional Requirements

Table 2 presents the non-functional requirements of the system.

NON-FUNCTIONAL REQUIREMENTS

The system must use MySQL Query database

Browser
The system will be developed in the Java language.

NetBeans will be used to develop the System

The system will be a Desktop Application

Table 3 - Non-functional requirements.

3.7 SPECIFICATION
Next, the use case diagrams and the entity model are presented.
relationship. The diagrams were generated using Visual Paradigm for UML. The
The entity relationship model was developed using DBDesigner 4. The UML is
a diagrammatic language, used for detailing, visualization, and
software system documentation. Its main objective is to promote the
communication among a varied group of participants (Silva & Videira, 2001).

3.7.3 ENTITY RELATIONSHIP MODEL

3.8 IMPLEMENTATION
This session shows the techniques and tools used, the operation of
implementation, as well as the coding of the system.

3.8.1 TECHNIQUES AND TOOLS USED

For the development of the system, the NetBeans tool and the SGB were used.
MYSQL Query Browser and Java as the programming language for system development.

[Link] JAVA
Java is the object-oriented programming language developed by Sun.
Microsystems, able to create both desktop applications and commercial applications,
robust, complete and independent software, web applications. In addition,
It is characterized by being very similar to C++, eliminating the features
considered complex, among which are pointers and multiple inheritance.
In 1991, a small group of Sun employees including James Gosling moved.
for San Hill Road, a subsidiary company. The group was starting a project.
called Project Green, which consisted of the creation of modern technologies
software for consumer electronics companies, such as remote control devices
The cable TV. Soon the group realized that it could not remain tied to the platforms, because
the customers were not interested in the type of processor they were using and
creating a version of the project for each type of system would be unfeasible. They developed
So the operating system GreenOS, with the programming language Oak. They are
they were based on the inventor of Pascal, through the USCD Pascal language, which was the pioneer
from intermediate language or virtual machine.
In 1993, an opportunity arose for the Green group, now incorporated as
FirstPerson a Time-Warner, a company that was soliciting system proposals.
operational decoders and video on demand technologies. That was at the same
time when NCSA released MOSAIC 1.0, the first graphical web browser.
A FirstPerson bet on Time-Warner's TV tests, but this company preferred
opt for the technology offered by Silicon Graphics.
After yet another failure, FirstPerson dissolved and half of the staff was
working for Sun Interactive with digital video servers. However, the team
the remaining continued the project's work at Sun. Betting on the Web, given that the
projects were all focused on the WWW, the idea of creating a
browser com independence of platform what was o HotJava.
As the development team consumed a lot of coffee while they were working,
several cups of coffee were consumed until the project was ready. Finally, in
May 1995, Sun announced an environment called Java (in tribute to coffee cups)
of coffee) that achieved success thanks to the incorporation of this environment into browsers
popular browsers like Netscape Navigator and three-dimensional standards like the
VRML (Virtual Reality Modeling Language - Modeling Language for
Virtual Reality.
Sun considers the success of Java on the Internet as being the first step towards
use it in interactive television decoders on portable devices and others
consumer electronic products - just as Java had started in 1991.
Its portable nature and robust design allow for development across multiple
platforms, in environments as demanding as those of consumer electronics.
The first version of the Java language was released in 1996.

[Link] MYSQL

The Database Management System (DBMS) used is MySQL, a database

relational database. This type of database emerged in the early 1970s, following the
rules defined by Edgar Frank Codd. In addition to being relational, MySQL is multi-user and
multitasking, besides being open-source software and having a wide and complete
documentation (TONSIG, 2006). MySQL has a dual license policy, or
Yes, it is possible to use the tool for free under the Open Source license.
(GPL - General Public License), provided that you comply with the terms of the license. In
Web case, Scheduling, Client Management Android, iOS, Windows.
Customized environment for specialties Generate service provision contracts
development of a non-GPL system, which includes MySQL, is necessary
buy a commercial license (COSTA, 2013).
The choice of MySQL for the project was mainly due to its easy integration.
with the JAVA language, which will be used in this project. Also, since it is about a
of the most used DBMS, there is a wealth of online documentation available,
discussion groups and books that make it easier to find solutions to problems that may arise
to occur.
[Link] MYSQL QUERY BROWSER
The MySQL Query Browser is a graphical tool provided by MySQL AB for
create, run, and optimize SQL requests in a graphical environment. Just like the
MySQL Administrator was created to manage a MySQL server, the MySQL
Query Browser was created to help you select and analyze stored data.
inside a MySQL Database.
While all requests executed in MySQL Query Browser can also
to be executed via the command line using the mysql utility, the MySQL Query
Browser allows the execution and editing of data in a graphical way, which is more intuitive
for the user. MySQL Query Browser was designed to work with versions 4.0 or
superiors of the MySQL server.

[Link] NETBEANS IDE 8.0.2

NetBeans is an integrated development environment (IDE) for Java developed by
company Sun Microsystems.

The NetBeans IDE is a free, open-source integrated development environment.

open to software developers. The IDE runs on many platforms,
like Windows, Linux, Solaris, and MacOS. It is easy to install and use. The NetBeans IDE
provides developers with all the necessary tools to create applications
desktop, business, web, and cross-platform mobile professionals.

NetBeans was started in 1996 by two Czech students at the University of

Charles, in Prague, when the programming language Java was not yet so popular.
as it is currently. Firstly, the project's name was Xelfi, in reference to Delphi,
Thus, the aim of this project was to have functionalities similar to IDEs.
(integrated development environment) so popular in Delphi that were more
attractive for being visual tools and easier to use, but with the intent
of to be totally developed in Java.

In 1999 the project had already evolved into a proprietary IDE, named
NetBeans DeveloperX2 is a name that came from the idea of reusing components that
it was the basis of Java. At that time, the company Sun Microsystems had given up on its
Java IDE Workshop is looking for new initiatives and acquired the NetBeans project.
DeveloperX2 incorporating it into its software line.

[Link] AGILE DEVELOPMENT METHODOLOGY SCRUM

Scrum is a management methodology for controlling the work to be carried out.
development of software, in turn seeks to reduce the complexity of
development processes of the same, so that the team can focus on the construction
of software that meet the needs of businesses ([Link], 2020).
Scrum works with the definition of objectives that must be completed in a
defined period. These periods are called cycles or sprints, representing a
time interval, within which a set of activities must be executed
([Link], 2014). A distinguishing feature of the methodology in
the issue is how the functional requirements are collected. The requirements are
obtained in meetings with the entire development team and the client, when is
a set of requirements is formed, these are called the product backlog.
Backlog is made up of stories, which come from the English user stories (PHAM and PHAM,
2012). These stories are simple descriptions that describe a functionality and are
It is advisable that they are written from the user's perspective (PHAM and PHAM,
2012). In the planning meeting, which takes place before the start of a sprint, part of the
Stories are extracted from the backlog to form a sprint backlog.
Next, the team defines the tasks that they will be able to implement in the current cycle.
During each day of the sprint, the team holds a meeting (usually in the morning), which
are called Daily Scrum. The purpose of this meeting is to disseminate the
knowledge about what was done the day before, identify the impediments and
prioritize work for the day that begins ([Link],
2014). After the end of each sprint, a part of the system is delivered to the client so that
the same can then carry out the verification and validation. During this delivery, new
stories may arise, seeking correction of errors or the implementation of new ones
functions that were not suggested in the first phase. Thus starting a new cycle of
sprint. The choice of the Scrum methodology for this project was made in search of a
better organization for the requirements proposed by the client and for encouraging a
quick feedback on the developed features. Also, the Scrum
helps to avoid bureaucracies imposed by excessive documentation, which could
compromise the progress of development, especially because the author of this
the project is the sole responsible and executor of all stages corresponding to the
development. Thus, it is expected that through this methodology to make a
better monitoring of the progress of the work.

3.9 OPERATIONALITY OF THE IMPLEMENTATION

This section shows the application's screens and their functionalities for a better
understanding how the system works.