UNIVERSITY INSTITUTE OF THE GULF OF GUINEA

HIGHER INSTITUTE OF ADVANCED TECHNOLOGIES

P.O.BOX 12489 Douala-Cameroon Fax:(237) 233 42 89 02
Tel: (237) 233 43 04 52 / 233 37 50 60
website: www.iug-univ.com

DEPARTMENT OF COMPUTER ENGINEERING

ACADEMIC INTERNSHIP REPORT

CONCEPTION AND REALIZATION

OF A
PHARMACY MANAGEMENT SYSTEM

An Internship carried out from the 21th of JUNE to the 26th of AUGUST 2022
OPTION: SOFTWARE ENGINEERING
at STARTECH in the Fulfilment for the award of the Higher National Diploma
WRITTEN AND PRESENTED BY:

TCHINDA LONGBOU ADELAIDE

Student of Software Engineering Year 2
UNDER THE SUPERVISION OF:

Academic Supervisor: Professional Supervisor:

Mr. NSANKONG Boris Mr. YOLA Valery
 pharmacy management system

2023-2024 Academic Year

WRITTEN BY TCHINDA ADELAIDE 2

 pharmacy management system

CERTIFICATION
This is to certify that an internship with the theme “CONCEPTION AND

REALIZATION OF A PHARMARCY MANAGEMENT SYSTEM” was

carried out from the 21th of June to the 26th of August 2022 and this report was

written by TCHINDA LONGBOU ADELAIDE in partial fulfillment of the

requirement for the award of the Higher National Diploma (HND) in Software

Engineerings.

ACADEMIC SUPERVISOR:

MR NSANKONG Boris
SIGNATURE:
DATE:

PROFESSIONAL SUPERVISOR:

MR YOLA Valery
SIGNATURE:
DATE:
 pharmacy management system

DEDICATION

TO MY LOVELY FAMILY
 pharmacy management system

ACKNOWLEGMENT
The accomplishment of this work required the assistances of some people.

Failing to quote them individually here, they receive my most sincere thanks. I

am particularly grateful to:

 Mr. CEDRIC DJAMBOU, President of the UIG for the establishment of

this structure for the purpose of training students.

 Mr. NSANKONG Boris, my academic supervisor, who have been a

source of inspiration and motivation for me. Always guiding me and

giving advice on how to do things not only during the internship but also

in real life.

 Mr. YOLA Valery, my professional supervisor for having given me his

attention throughout this period of internship, for his support, his trust,

his availability, his advices and his precious remarks.

 MY lovely and SUPPORTIVE FAMILY for all their moral and financial

support especially for furthering my education.

 pharmacy management system

ABSTRACT
Pharmacy Management system is an application that helps pharmacist in the

management of the pharmacy in a systematic way. Pharmacy Management

System can make the work easier by giving the details of medicines when the

medicines enter the system. A computers give the details of the medicine like

the expiry date. It becomes very difficult in big medical stores to handle the

details of all medicine manually, so by using this pharmacy management system

we can maintain the record of all the medicines.it is fed with information

whenever a new medicine is being added and it also provide with expiry date

with search bar. When we enter the name of the medicine it gives the detail of

the medicine
This technology platform is implementing is this system with the use of visual

studio code and the use of programming language like HTML, JAVASCRIPT,

CSS, BOOSTRAP, PHP using MYSQL for SQL database.

 pharmacy management system

RESUME
Le système de gestion de la pharmacie est une application qui aide le
pharmacien dans la gestion de la pharmacie de manière systématique. Le
système de gestion de la pharmacie peut faciliter le travail en donnant les détails
des médicaments lorsque les médicaments entrent dans le système. Un
ordinateur donne les détails du médicament comme la date de péremption. Il
devient très difficile dans les grands magasins médicaux de gérer manuellement
les détails de tous les médicaments. Ainsi, en utilisant ce système de gestion de
pharmacie, nous pouvons conserver l'enregistrement de tous les médicaments. Il
est alimenté en informations chaque fois qu'un nouveau médicament est ajouté
et il fournit également avec date de péremption avec barre de recherche.
Lorsque nous entrons le nom du médicament, il donne le détail du médicament
Cette plate-forme technologique met en œuvre ce système avec l'utilisation du
code Visual Studio et l'utilisation d'un langage de programmation comme
HTML, JAVASCRIPT, CSS, BOOSTRAP en utilisant MYSQL.
 pharmacy management system

PREFACE
Founded in 1993, the University Institute of the Gulf of Guinea is a group of

three higher education institutions based on the same campus in Bassa-Douala.

Specialized in fields as varied as Commerce and management, communication

and information, industry and new technologies, and paramedical training, its

offer allows students to adapt their course as they evolve.

IUG trains young professionals in the Technical, Medical and Business

environment. Since its creation in 1993, the advance school of management has

been striving to answer the urgent calls of economic operators in need of

foremen and management staff. With the launching of the HIGHER

NATIONAL DIPLOMA, the university Institute of the Gulf of Guinea is

becoming the first bilingual Higher Institution of learning in central Africa.

The Cameroon government has taken as duty to train and educate youths in all

fields of vocational training, in order to build up their professional skills. IT IS

IN THIS LIGHT THE ORDER NO 008/CAB/PR of 19/03/1993, brought about

the creation of private state university and higher professional institute among

which is ISTA (INSTITUT SUPÉRIEUR DESTECHNOLOGIES AVANCÉES).

ISTA was created by the ministerial order No 05/0038 of the 12th January 2005.

It had as mission to employ good lecturers who are devoted and willing to train

students to obtain the higher national diploma (HND), after a two-year course.

Below are some of the professional trainings offered in IUG.

 pharmacy management system

Computer Engineering, Accountancy, Banking and finance, Transport and

logistics, Electrical Power System, Telecommunication, Nursing.

 pharmacy management system

LIST OF TABLES
Table 1: Internship activities carried out in the company...................................21
Table 2: Admin table...........................................................................................40
Table 3: Medicinelist table..................................................................................40
Table 4: pharmacist table....................................................................................40
Table 5: purchase table.......................................................................................40
Table 6: invoice table..........................................................................................41
Table7:Sales table...............................................................................................41
Table 8: Manag Medicine stock table.................................................................41
Table 9: Out of stock table..................................................................................41
 pharmacy management system

LIST OF FIGURES
Figure1: Organization chart of StarTech Academy............................................12
Figure2: Waterfall Model....................................................................................25
Figure3 : Use case diagram of the Pharmacist....................................................34
Figure4: Welcome and login screen....................................................................42
Figure5: Admin dashboard.................................................................................43
Figure6: pharmacist landing page and dashboard..............................................44
Figure7: Medicine in stock.................................................................................46
Figure8: User logout of the system.....................................................................46
 pharmacy management system

LIST OF ABBREVIATIONS
AMD: Advanced Micro Devices
CSS: Cascading Style Sheet
CPU: Central Processing Unit
DB: Data Base
DBMS: Database Management System
HTML: Hypertext Markup Language
IUG: University Institute of the Gulf of Guinea
ISTA: HIGHER INSTITUT OF ADVANCED TECHNOLOGIES
IDE: Integrated Development Environment
JS: JavaScript
PDF: Portable Document Format
PHP: Personal Home Page Hypertext Preprocessor
SDK: Software Development Kit
SQL: Structured query Language
SDLC: System Development Life Cycle
XAMPP: Linux Apache MySQL PHP Perl
XML: Extensible Markup Language
UML: Unified Modelling Language
 pharmacy management system

TABLE OF CONTENTS

CERTIFICATION....................................................................................................................i

DEDICATION.......................................................................................................................ii

ACKNOWLEGMENT............................................................................................................iii

ABSTRACT.........................................................................................................................iv

RESUME.............................................................................................................................v

PREFACE............................................................................................................................vi

LIST OF TABLES.................................................................................................................vii

LIST OF FIGURES..............................................................................................................viii

LIST OF ABBREVIATIONS....................................................................................................ix

TABLE OF CONTENTS..........................................................................................................x

GENERAL INTRODUCTION..................................................................................................1

THE PROBLEM STATEMENT........................................................................................................2

AIM OF THE STUDY AND OBJECTIVES.........................................................................................3

RESEARCH QUESTIONS:..............................................................................................................3

SIGNIFICANCE OF STUDY:...........................................................................................................4

STRUCTURE OF THE WORK IN PARTS..........................................................................................4

CHAPTER ONE: GENERAL PRESENTATION OF THE COMPANY...............................................6

SECTION ONE: CREATION AND EVOLUTION OF THE COMPANY...................................................6

1.1.1 CREATION OF THE COMPANY.............................................................................................................6

1.1.2 EVOLUTION OF THE COMPANY..........................................................................................................7

 pharmacy management system

SECTION two: ORGANIZATION AND OPERATION........................................................................8

1.2.1 ORGANIZATION..................................................................................................................................8

1.2.2 FUNCTIONING..................................................................................................................................10

CHAPTER TWO: COURSE OF THE INTERNSHIP TRAINING SECTION OR DEPARTMENT.........14

SECTION one: PRESENTATION OF SERVICE OF RECEPTION.........................................................14

SECTION two: ACTIVITIES OF THE TRAINING COURSE...............................................................15

2.2.1: Chronological program of activities and effectiveness....................................................................15

2.2.2: justification of the internship report topic (mission)......................................................................21

CHAPTER THREE: PRACTICAL PHASE.................................................................................24

SECTION ONE: PROJECT MANAGEMENT...................................................................................24

3.1.1 Project development approach................................................................................................24

3.1.2 SOFTWARE DEVELOPMENT LIFE CYCLE MODEL OF PHARMACY MANAGEMENT SYSTEM

(Waterfall Model).....................................................................................................................................26

SECTION TWO: TOOLS USED AND RESULT OBTAINED................................................................39

3.1.3: TOOLS USED...................................................................................................................................39

3.1.4: RESULT OBTAINED...........................................................................................................................42

CHAPTER FOUR: DIFFICULTIES ENCOUNTERED AND SUGGESTIONS...................................47

SECTION ONE: DIFFICULTIES ENCOUTER...................................................................................47

SECTION TWO:SUGGESTION…………………………………………………………………47

GENERAL CONCLUSION....................................................................................................48

REFERENCES.....................................................................................................................49
 pharmacy management system

GENERAL INTRODUCTION
This report is a short description of our two-months internship carried out as

compulsory component of the HND examination. The internship was carried out

at STARTECH from the 21 June to the 24 August 2023.

Pharmacy Management System is a software developed for the management of

medicines and clients in a pharmacy. It facilitates in accessing the details of

medicines in stock/system. The system will help making things easier like it will

allow the pharmacist to maintain the supply and organizations of drugs.

Also it has benefits like easy to find medicine because we have search bars and

also easy to add medicines into the system. The main purpose for this academic

internship was for us to learn how to apply our academic skills acquired to the

professional world. In addition to that, we had to learn new things that was very

Important for us to know and was not taught in school. We will be introducing

the project and research. We will further look at the necessity of this study,

research objectives, questions and significance. Last but not the least, this report

gives the detailed description of pharmacy management system.

This report is divided into two part one and two has two chapter each
Part One: This part is made up of 2 chapter, which are further divided into 2 section.

 Chapter one talk about the general presentation of STARTECH as a functioning body,

including its orangs with their functions.

 Chapter two talk about the internship environment, and how everything went on, as a

whole

WRITTEN BY TCHINDA ADELAIDE 1

 pharmacy management system

Part two: Part two is made up of two chapter; chapter 3 and 4. Chapter 3 and is

subdivided into two section while chapter 4 is subdivided to 2 sections.

 Chapter 3 talks about system analysis and program design.

 Chapter 4 is about the implementation and testing of the system.

WRITTEN BY TCHINDA ADELAIDE 2

 pharmacy management system

THE PROBLEM STATEMENT

 Pharmacy operation heavily depend on manual method for tracking inventory, leading

to errors stock outs and difficulties in maintaining stock levels.

 Lack of customer relationship, resulting in a less personalized and efficient service.

 The encounter difficulties in overseeing the entire pharmacy operation, managing user

role, and ensuring data security with the existing decentralized and manual processes.

 The faces challenges in tracking sales, understanding product performance and

providing personalized service due to absence of a system sales management.

WRITTEN BY TCHINDA ADELAIDE 3

 pharmacy management system

AIM OF THE STUDY AND OBJECTIVES

The purpose of developing pharmacy management system is making pharmacy

organization computerized by creating neat work through minimizing or

eliminating waste of time as well as removing the resource such as papers for

data saving
The objective to create a pharmacy management system is to perform the

following tasks:
 To be useful in handling medicine
 To be useful to track and keep users
 To enable retrieval of information when ever needed from the system
 To also reduce human error
 To maintain a digitalize record of medicines

RESEARCH QUESTIONS:
 How can we free information from human error making?
 How can we avoid manual or traditional recording of date in a pharmacy?
 How can we improve the management system of pharmacies?
 How can we avoid time consumption made during data recording?

WRITTEN BY TCHINDA ADELAIDE 4

 pharmacy management system

SIGNIFICANCE OF STUDY:
1. The will research will permit the pharmacist to know more about
2. To understand the importance of a good management of a pharmacy.
3. It will help other pharmacies to also adopt and implement these

recommendations to improve their systems.

STRUCTURE OF THE WORK IN PARTS

This work has two parts with two chapters each, details are as follows:
 Chapter one is the general presentation of the enterprise that is; Historical

background, products and services, organizational structure, functions of

departments and geographical location.

 Chapter two will present an introduction to the literature review, the

theoretical review and internship activities.

 Chapter three deals with the presentation of methodology of research.

That is a recall of the objectives, resources of data, definition of terms,

methods of data collection, methods of data analysis and the result

obtained.
 Chapter four finally will give a summary of the problems encountered

during the research, recommendations to them and a final conclusion of

the research.

WRITTEN BY TCHINDA ADELAIDE 5

 pharmacy management system

PART one
THE FRAMEWORK (ENVIRONMENT) OF
THE TRAINING COURSE

WRITTEN BY TCHINDA ADELAIDE 6

 pharmacy management system

CHAPTER ONE

GENERAL PRESENTATION OF THE COMPANY

The StarTech academy is a limited liability company specializing in the

provision of services and training in the field of ICT. The company has been

operating in Cameroon for almost four years already and is registered in the

trade register with the number: RC / DLA / 2021 / B / 3445.

Section one: CREATION AND EVOLUTION OF THE COMPANY

1.1.1 CREATION OF THE COMPANY

Created in June 2021, the STARTECH academy SARL is a company whose

main mission was to provide IT services.

Following a clear observation which is that of the glaring unemployment of

young graduates, the company has decided to contribute in its own way to

reduce the phenomenon which is constantly growing. In fact, we realized

that the majority of students go to school with the sole objective of obtaining

their diploma at the end of the year. This and these do not give any

importance with regard to the acquisition of practical know-how. This is why

we find more and more in our environment people who claim to be engineers

and yet they are unable to produce scientific work up to the skills they are

supposed to have. This is why, as a corporate citizen, the StarTech

Academy's mission is to support these young learners with a view to initially

enabling them to acquire a practical skill thanks to the training sessions that

we provide. organize and then integrate our various projects in progress.

WRITTEN BY TCHINDA ADELAIDE 7

 pharmacy management system

1.1.2 EVOLUTION OF THE COMPANY

The StarTech Academy since its creation until today has stood out thanks to

a number of achievements among which we can mention among others:

 School management software: Phoenix Shoomann functional in 05

schools only in the city of Douala.

 Commercial management software: LOGESCO functional in two shops

in the city of Douala.

 Pharmacy management software: PHARMA-SOFT functional in

pharmacies in Yaoundé and Ebolowa.

 A tontine management software: functional LOGIT in a meeting group in

the quarry district in Douala.

 A mobile application for the sale and exchange of articles: BiZi available

on the stores (APP store and Play store).

 A mobile application for learning to cook: Gooo available on the stores

(APP store and Play store).

Besides computer programming, we also excel in network security and

administration, computer maintenance, home automation and even

renewable energies. In a very short time, we expect to really establish

ourselves in the software market with the creation of a whole specific

department for the development of “Made in Cameroon” applications.

WRITTEN BY TCHINDA ADELAIDE 8

 pharmacy management system

SECTION 2: ORGANIZATION AND OPERATION

1.2 ORGANIZATION
The organizational structure of StarTech Academy includes five (5) main

departments namely:
 StarTech Software
 StarTech Network
 StarTech Computer
 StarTech Energy
 StarTech Academy (General Manager)

 StarTech Software

The “StarTech Software” department is responsible for producing

applications for any type of environment. The applications in question can

be:
 Mobiles: These are applications running on Android & IOS

terminals.
 Web: Web applications are those running through a browser by means

of web pages. Websites also fall into this category.

 Desktop: Desktop applications are those that can be installed on a

computer.
 Home automation: Home automation applications make it possible

to control the electronic systems that we design.

This department is also responsible for designing and administering

databases (SQL, NoSQL).

WRITTEN BY TCHINDA ADELAIDE 9

 pharmacy management system

 StarTech Network

The main role of this department is to design the network architecture for

companies. These main missions among others are:

 Design custom network architectures for companies.
 Perform the installation and maintenance of corporate networks.
 Implementation of network services (Telephony, Mail, Internet, etc.).
 Network administration (Windows, Linux, Cisco…).
 Installation of video surveillance and access control systems.
 Audit of security systems.

 StarTech Computer

Through this department, we offer maintenance services for computer

equipment. Our services are:

 Hardware maintenance: troubleshooting, assembly and disassembly

of computer equipment.
 Software maintenance: Installation and updating of operating systems,

 management of computer parks, etc.

 StarTech Energy

Revolutionary department which mainly works in the field of renewable

energies. The main missions are:

 Electrical network installation thanks to solar panels.

 Maintenance and supervision of the electrical network.

WRITTEN BY TCHINDA ADELAIDE 10

 pharmacy management system

 StarTech Academy

The academy responsible for carrying out training is managed by the general

management of the company. The academy's missions are:

 Offer practical and innovative training in the fields of ICT

 Identify the best learners and integrate them into our various projects.
 Support project leaders who need our expertise.

1.3 FUNCTIONING
The company regularly organizes training sessions and practical workshops

with the aim of helping all people (students or not) to acquire real knowledge

and skills. We also offer vacation internships for students to allow those to

experience the realities of the business world. It should be noted that at the end

of our various training sessions we integrate the best students into our various

projects in progress.
The StarTech Academy with the aim of always satisfying customers, works

daily around the objectives and values that it has set for itself.

 Goals and values

 Goals
Training-Research-Innovation is our motto and to be able to honour it, the

company has set itself the following objectives:

 Satisfy customers in general businesses by offering a quality

service respecting International standard.

WRITTEN BY TCHINDA ADELAIDE 11

 pharmacy management system

 Respect of delivery deadlines accompanied by an efficient after-

sales service to ensure customer satisfaction

 Provide innovative solutions to the ills that plague our society.

 Offer quality training to our different learners.

 Continuously monitor technology.

 Values

 Quality: The StarTech Academy places a lot of emphasis on product

quality and service efficiency. This quality of products and services

requires respect for procedures, but also the quality of the people: you,

your skills and your creativity.

 Creativity: StarTech Academy considers the creative act to be the

very essence of its existence. Thanks to your enthusiasm, your

inspiration and your deep emotions, the company believes you are

capable of transforming information into real development strategies.

 Team spirit: thanks to participatory management and thanks to the

team spirit, the company wants everyone to contribute to achieving

their vision. It is the effort of each at his level that will allow the

development of the company.

 Integrity: this is one of the essential human qualities in the

professional life of StarTech Academy. More than a simple image,

integrity brings the confidence of peers and the hierarchy, but also it

gives the company a solid reputation.

WRITTEN BY TCHINDA ADELAIDE 12

 pharmacy management system

 Organizational chart

Figures 1: Organization chart of StarTech Academy

Direction
General

Direction Direction StarTech

Technique Commercial Academy

StarTech Service Offre De

Software Marketing Stage

StarTech Service Suivi Des

Network Apres Vente Projects

StarTech
Energy

StarTech
Computer

WRITTEN BY TCHINDA ADELAIDE 13

 pharmacy management system

 General management: It develops general managerial policy, defines

short, medium and long-term objectives and coordinates all of the

company's activities.
 Technical direction: the technical direction is at the centre of the

operation of the company. This is where all projects are thought out,

planned and carried out. it contains all the main departments of the

company and obviously works under the watchful eye of senior

management.
 Sales Department: It defines the sales and marketing policy for products

and services, takes care of the permanent search for new customers and

also ensures the effectiveness of the after-sales service.

 Academy StarTech: its mission is to offer innovative training in

different fields of N.

WRITTEN BY TCHINDA ADELAIDE 14

 pharmacy management system

CHAPTER TWO

COURSE OF THE INTERNSHIP

This chapter is made up of two sections. Section 1 which gives a Brief

summary on the reception and Section 2 which gives a Brief summary of the

internship activities carried out by the intern during his internship and

justification of topic studied.

SECTION1: PROGESS OF THE INTERNSHIP

2.11. Presentation and Reception
On the first day of internship, we were pleasantly received by the members of

the staff and they further introduced themselves by stating their names, years of

experience in the field, projects done and projects still in completion. Also, we

were asked to introduce our self by stating our names, school, years of

experience in the field, projects completed (if any) or projects still in process.

Again, we were asked the reason for choosing to do internship here and the

objectives to accomplish after doing internship there.

Furthermore, after the general introduction of both the interns and the

members of the staff, we later met with our respective professional supervisor.

We were given a quiz to evaluate and test our competency. A structure was laid

out on how the program would look like throughout the internship period.

WRITTEN BY TCHINDA ADELAIDE 15

 pharmacy management system

SECTION 2: ACTIVITIES OF THE TRAINING COURSE

This section is further divided into two parts which are: Chronological program

of activities and effectiveness and the justification of the topic.

2.2.1: Chronological program of activities and effectiveness

This section provides the activities performed by the intern during his two

months of internship. This report is based mostly on the activities that were

carrying out during my internship period which ran from June to August 2023 at

StarTech Academy.
Difficulties
Period Activities Results Solutions
Encountered

WEEK 1 Introduction and The presentation when

21-06-2023 presentation of interns well and each and

To and staff members. every one presented
27-06-2023
him or herself.

Notion of HTML, CSS HTML, CSS and Working with Research on

and JavaScript. JavaScript was clearly functions in the topic

understood. JavaScript

Project 1: Creation of a We took less than two Time Design a

webpage with Html, days to finish the management study time

CSS and JavaScript. webpage with notions table

acquired.

WRITTEN BY TCHINDA ADELAIDE 16

 pharmacy management system

Correction of project 1 The correction when

and additional sub perfect but some had

projects. some difficulties with

JavaScript.

Project 2: Creation of Project 2 was realized Unable to

the Facebook homepage in 3 days and each and understand

with HTML, CSS and every one had student

JavaScript from something to present. explanation of

Scratch. their project

Project 3: Recreation of The projects were not It was new in Had to revise

Facebook home page realized by all the using library of some tools of

with the Notion of member or the interns code like that bootstrap and

WEEK 2 framework like which were doing the of Bootstrap make use of

29-06-2023 Bootstrap 4 and Latest same specialty with and was tutorials

To Version. me but I did not difficult to videos

05-07-2023 really succeed. manipulate

class name

Project 4: Applying the Presentation of each

Bootstrap and member of the group

JavaScript on a successfully took

webpage of our choice. place and both the

directors and prof.

supervisors of each

intern came.

WRITTEN BY TCHINDA ADELAIDE 17

 pharmacy management system

Project 5: Creation of Each and every one

Administrator presented his or her

Dashboard with his design admin

various functions of dashboard to the

different components. supervisor.

WEEK 3
Project 6: Creation of Each and every one Presentation of
07-07-2023
Registration form with presented his or her project some
To
HTML CSS and design admin interns were
13-07-2023
JavaScript and dashboard to the unable to

Bootstrap 5.0 supervisor. present their

project.

Poor

management of

time ,

WEEK 4 Introduction to back- Since it was new, we To distinguish Research

15-07-2023 end Web Development had difficulties in between a made

To with PHP and MySQL. understanding it the programming
21-07-2023
first day but when language use

smooth the following in server side

days.

With the use of the All our project made

notion of PHP and from Week 1 to Week

MySQL, creation of a 4 was updated by

WRITTEN BY TCHINDA ADELAIDE 18

 pharmacy management system

back-end with all the adding a backend code

project done on Week1, to it even if it was just

Week 2 and Week 3 to print out an output.

respectively.

Project 5: User Input The project when all

verification and well and each and

Validation phase every one had an idea

on how to implement

the verification and

validation phase

during form

submission.

WEEK 5 Supervisor propose

& some projects for

WEEK 6 those who were in
23-07-2023 Introduction to our
need and concerning
To various HND project
those whom already
08-08-2023
had an HND project,

they detailly explained

the project to him.

Requirement Analysis The task was

and Feasibility Study successfully complete

by each intern.

WRITTEN BY TCHINDA ADELAIDE 19

 pharmacy management system

System Analysis and Basic knowledge was

System design acquired but still was

theoretically.

Designing of Entity Blueprints of the ER

Relational Diagram and diagrams and UML

Implementation of the diagrams of each

Database for the project intern’s project was

drowned and

supervised by our

supervisor.

Practical on HTML Every intern started

CSS and JavaScript on implementing their

Real life projects and projects with the

WEEK 7
previous projects necessary language
12-08-2023
acquired during the
To
ongoing of the
18-08-2023
internship.

Practical When well

WEEK 8 End of PHP We had good

19-08-2023 knowledge on how to

To submit a form, interact
24-08-2023
with the relational

database by

WRITTEN BY TCHINDA ADELAIDE 20

 pharmacy management system

performing the CRUD

operations.

Beginning of the We knew how to

creation of web locally host our

application with all websites and web

those notions application.

Table 1: Internship activities carried out in the company

WRITTEN BY TCHINDA ADELAIDE 21

 pharmacy management system

Part 2: justification of the internship report topic (mission)

The adoption of a Pharmacy Management System (PMS) is justified by its

transformative impact on traditional pharmacy operations. In the healthcare

landscape, efficiency, accuracy, and patient safety are paramount, and a digital

system provides a comprehensive solution to address these imperatives. The

relevance of a PMS is underscored by the complex challenges faced by

traditional pharmacy management, such as manual record-keeping, inventory

discrepancies, and the potential for errors in prescription processing. The

system's ability to streamline these processes is a compelling reason to embrace

digital transformation in pharmacy operations. Moreover, the PMS significantly

enhances accuracy, reducing errors in prescription filling and inventory

tracking. This not only contributes to operational efficiency but also ensures a

safer and more reliable patient experience. In a sector where precision is non-

negotiable, the PMS becomes an indispensable tool for maintaining the highest

standards of pharmaceutical care. Regulatory compliance is another critical

aspect, and a well-designed PMS facilitates adherence to industry regulations

and standards. It ensures accurate record-keeping, reporting, and the secure

handling of sensitive patient information, aligning seamlessly with data

protection laws.
In the era of technological advancements, embracing a Pharmacy Management

System is not just a matter of convenience but a strategic imperative for

pharmacies to stay competitive and provide enhanced services. The PMS

WRITTEN BY TCHINDA ADELAIDE 22

 pharmacy management system

represents a forward-looking approach to pharmacy management, leveraging

modern technologies to meet the evolving demands of the healthcare landscape.

WRITTEN BY TCHINDA ADELAIDE 23

 pharmacy management system

SECOND PART: PRACTICALS AND

FIELDWORK

WRITTEN BY TCHINDA ADELAIDE 24

 pharmacy management system

CHAPTER THREE

PRACTICAL PHASE
This chapter is made up of two sections. Section 1 which gives a Brief

summary on the project management (job placement) of the pharmacy

management system including UML diagrams and Section 2 which gives the

result obtained.

SECTION ONE: PROJECT MANAGEMENT

3.1.1 Project development approach

3.1.1.1 Software Process Model

To solve actual problems in a pharmacy, software developer or a team of

developers must incorporate a development strategy that encompasses the

process, methods and tools layers and generic phases. This strategy is often

referred to as process model or a software developing paradigm. A process

model for software developing is chosen based on the nature of project and

application, the methods and tools to be used, and the controls and deliverables

that are required. All software development can be characterized as a problem-

solving loop in which four distinct stages are encountered: Status, Problem

definition, technical development and solution integration. Regardless of the

process model that is chosen for a software project all of the stages coexist

simultaneously at some level of detail.

WRITTEN BY TCHINDA ADELAIDE 25

 pharmacy management system

This project follows the waterfall model which is made up of the following

steps: Requirement definition, System analysis, System design, Implementation,

Integration and System Testing, Operation and maintenance.

WRITTEN BY TCHINDA ADELAIDE 26

 pharmacy management system

Figures 2: Waterfall Model

Source: Student interns

3.1.2 SOFTWARE DEVELOPMENT LIFE CYCLE MODEL OF THE

PHARMACY MANAGEMENT SYSTEM (Waterfall Model)

3.1.2.1 Requirement Analysis and Feasibility study

User Characteristics
This system will be use by three users which are Administrators, inventory and

Salesman. As all of these have different requirements the modules are designed

to meet their needs and avoid any type of confusion. The Uses of all three User

Modules have been described below.

System users can perform the following functions in the system:

 Administrator
o Create, update, modify, and deactivate user accounts

within the system.it may assign different roles and

permission to ensure each user has appropriate access to

features and data.

o It is responsible for ensuring the security of the pharmacy

management system. This involve implementing system

logs and addressing.

o It configures and customize system setting based on the

pharmacy’s requirements. This may include setting up

inventory parameter, defining sales processes and

configuring security settings.

WRITTEN BY TCHINDA ADELAIDE 27

 pharmacy management system

 Inventory
o It responsible for managing stock level, receiving and

updating inventory with new shipmememts, and ensuring

product are adequately stocked.

o It Seles, updating stock levels, and checking product

availability for customers.

o It turnover. product, popularity and stock aging to aid in

decision-making and planning.

 Salesman
o It processes sale transaction at the point of sale, include

scanning product entering quantities, and generating

invoices or receipts.
o Interact with customers, providing assistance, answering

inquiries about products and ensuring accurate and timely

deliberyof product, and ensuring a positive shopping.

o Retrieve products from the inventory to fulfill customer

orders, ensuring accurate and timely delivery of product to

the customers.

System Requirement
1. Hardware:
a. Core i5
b. 6GB RAM
c. 300GB hard drive space

WRITTEN BY TCHINDA ADELAIDE 28

 pharmacy management system

2. Software:
a. Operating system: Windows 7, 8, 10, 11 or later version or Marcos X.
b. Front-end: HTML, CSS, JavaScript, Bootstrap 4 and 5.
c. Back-end: PHP and MySQL, Apache Server.
External Requirements:
i. Ethical Requirements:
Product Software should be negotiated with human Ethics and it is wished

that the software should be used with Ethical requirements. Any non-ethical

use of this software will be at the user’s own risk.

ii. Legislative Requirements:
 Privacy Requirements:
Privacy of any particular things and strategy will be served based on

prior negotiation and it should be cleared purposed for that

requirement.
 Safety Requirements: Safety will be provided based on the requirement of
the members and necessary critical points.

3.1.2.2 System Analysis

 STUDY AND WEAKNESS OF THE CURRENT SYSTEM

 Current System

In the present system all work is done on paper. The whole session

attendance is stored in register and at the end of the session the reports are

generated. We are not interested in generating report in the middle of the

session or as per the requirement because it takes more time in calculation.

So, we are not able to get employees regularity report and take necessary

WRITTEN BY TCHINDA ADELAIDE 29

 pharmacy management system

action on employees whenever we want because of having very time-

consuming process.
 Weakness of the current system

1. Not User Friendly:

The existing system is not user friendly because the retrieval of data is

very slow and data is not maintained efficiently.

2. Difficulty in report generating:
We require more calculations to generate the report so it is generated at

the end of the session. And the employee not gets a single chance to

improve their Attendance.

3. Manual control:
All calculations to generate report are done manually so there is greater

chance of errors.
4. Lots of paperwork:
Existing system requires lot of paper work. Loss of even a single

register/record led to difficult situation because all the papers are needed

to generate the reports.

5. Time consuming:
Every work is done manually so we cannot Generate report in the middle

of the session or as per the requirement because it is very time consuming.

 REQUIREMENTS OF THE NEW SYSTEM

1. User Requirement
The User requirements for the new system are to make the system fast,

flexible, less prone to errors and reduce expenses and save time.

WRITTEN BY TCHINDA ADELAIDE 30

 pharmacy management system

 Time can be saved in scheduling the salary if it were available to

make question banks to store questions for different Employee in

advance and can be used as per required.

 A system that can automate the checking of answers which are pre-

stored so that results can be generated as soon as the Employee gives

the reason.
 A facility that can generate result charts as per required without

manual interference for providing how a task is to be done instead

only asking what is to be done.

 The system should have Employee & its salary records on hand

which can be used as per required only by authorized personnel.

 The New system should be more secure in managing Employee

records and reliable enough to be used in any condition.

 Finally, it should prove cost effective as compared to the current

system.

2. FEASIBILITY STUDY
A key part of the preliminary investigation that reviews anticipated costs and

benefits and recommends a course of action based on operational, technical,

economic, and time factors. The purpose of the study is to determine if the

systems request should proceed further.

 Economically Feasibility:
The system being developed is economic with respect to Business or point

of view. It is cost effective in the sense that has eliminated the salary work

WRITTEN BY TCHINDA ADELAIDE 31

 pharmacy management system

completely. The system is also time effective because the calculations are

automated which are made at the end of the month or as per the employee

requirement. The result obtained contains minimum errors and are highly

accurate as the data is required.

 Technical feasibility:
The technical requirement for the system is economic and it does not use any

other additional Hardware and software.

 Behavioral Feasibility:
The system working is quite easy to use and learn due to its simple but

attractive interface. user requires no special training for operating the system.

d. Features of the new system

The new system has been designed as per the user requirements so as to fulfill
almost all them.

 User Friendly:

The proposed system is user friendly because the retrieval and storing of

data is fast and data is maintained efficiently. Moreover, the graphical

user interface is provided in the proposed system, which provides user to

deal with the system very easily.

 Reports are easily generated:

WRITTEN BY TCHINDA ADELAIDE 32

 pharmacy management system

Reports can be easily generated in the proposed system so user can

generate the report as per the requirement (monthly) or in the middle of

the session. User can give the notice to the employees to be regular.

 Very less paper work:

The proposed system requires very less paper work. All the data is feted

into the computer immediately and reports can be generated through

computers. Moreover, work becomes very easy because there is no need

to keep data on papers.

 Computer operator control:

Computer operator control will be there so no chance of errors. Moreover,

storing and retrieving of information is easy. So, work can be done

speedily and in time.

3.1.2.3 SYSTEM DESIGN

Using UML Over MERISE for the development of the system
i. What is UML?
According to Brooch (2003), UML (Unified Modeling Language) is a

general-purpose Visual language that is used to specify, visualize,

construct, and document the artifacts of a software system.

It allows the modeling of all the phenomena of the business activity

(business process, information system, computer system, software

components, etc..) independently of the implemented techniques. A

model is an abstraction of reality; it allows:

WRITTEN BY TCHINDA ADELAIDE 33

 pharmacy management system

 To facilitate the understanding of the studied system (that is to say, it

reduces the complexity of the system studied);

 To simulate the system studied. As a result, as part of the modeling of

the information system, we will have to determine which approach to

use for our modeling.

3. UML DIAGRAMS
i. Use Case Diagram
Actors and use cases
Actors are external entities that interact with the system. Examples of

actors include a user role (e.g., a system administrator, a bank

customer, a bank teller) or another system (e.g., a central database, a

fabrication line). Actors have unique names and descriptions.

Use cases describe the behavior of the system as seen from an

actor’s point of view. Behavior described by use cases is also

called external behavior. A use Case describes a function

provided by the system as a set of events that yields a visible

result for the actors. Actors initiate a use case to access system

functionality. The use case can then initiate other use cases and

gather more information from the actors. When actors and use

cases exchange information, they are said to communicate.

WRITTEN BY TCHINDA ADELAIDE 34

 pharmacy management system

Figures 3 : Use case diagram of the system

Source: Student interns

WRITTEN BY TCHINDA ADELAIDE 35

 pharmacy management system

ii. Class Diagram

iii. Sequence Diagram

3.1.2.3 TESTING
The testing phase is an incredibly important part of app or website

development. The problem is that the chance of a bug appearing increases with

every line of code and the costs of bug fixing rise with the time. However, with

a proper website testing, none of that has to happen. So, if the application

testing runs smoothly, the app or website is ready to be deployed

Web Testing Basic Steps:
Step 1: Functionality Testing
First step of the testing phase is to make sure that the web application is

functionally correct. Functionality testing checks the database connection, all

links in the web pages, cookies, forms used for submitting and/or getting info

from the user etc. It should be done early in the developing stages to speed up

the whole app-building process and it reduces risks toward the end of the cycle.

It boils down to performing a set of tasks that can be performed both

automatically with the use of a software program or manually with a human

tester.

Step 2: Usability Testing

When thinking about how to test a website, the second step should be usability

testing. This type of testing combines the previously mentioned functionality

testing with the overall user experience. Usability testing can be done by getting

WRITTEN BY TCHINDA ADELAIDE 36

 pharmacy management system

external testers that simulate your expected user base, or internally by the

developers themselves. If you want to perform external testing but don’t know

where to find suitable testers, apps like Apple’s Test Flight might help you.

Step 3: Interface Testing

This web page test checks whether or not all interaction between the app server

and the web server run smoothly. Not only the communication process needs to

be tested, but the displaying of error messages as well. Also, this test is used to

determine whether the interruptions by the server and/or by the user are handled

properly.
Step 4: Compatibility Testing
In the era of portable devices and all kinds of screens, compatibility testing is

important to ensure that your web app displays as it should on all device types.

The developers need to run the browser compatibility test to check if the app is

displayed correctly in different browsers. Another test to run is the mobile

browser compatibility which, as the name suggests, is supposed to confirm that

the app displays correctly across mobile browsers. Different popular browsers

include Chrome, Internet Explorer, Safari, Firefox etc.

Step 5: Performance Testing
Once you know your site is functional and responsive, you need to check its

performance under a heavy load. Performance testing includes testing under

different internet speeds as well as under normal and peak loads. Even in a

wider context it might be a good idea to test your overall web server

WRITTEN BY TCHINDA ADELAIDE 37

 pharmacy management system

performance on a basic level, through a website speed automated test, as page

speed influences user experience a lot, and affects your public website’s SEO.

Step 6: Security Testing

Once the web application is developed, it has to be tested for security. This

type of testing includes all kinds of processes to determine the app’s weak

points and improve them as much as possible. Normally, a serious of fabricated

malicious attacks are used to test how the app responds and performs under

these circumstances. If security shortfalls are detected, it is important to find the

best way possible to overcome them. Understanding the security goals and

planning the test by considering the security needs of each of them. Identifying

and listing all potential threats and vulnerabilities Preparing the threat profile

based on the listed vulnerabilities and risks Preparing the test plan Automated

testing on top of the manual testing Preparing the Security tests case document

Carrying out
the Security test cases execution, fixing identified defects, retesting Creating a

detailed report on the security testing, including the solved issues and the risks

that still persist

WRITTEN BY TCHINDA ADELAIDE 38

 pharmacy management system

SECTION TWO: TOOLS USED AND RESULT OBTAINED

In this section, we will talk about the reasons for the choice of tool

PART 1: TOOLS USED

I. Visual Studio Code

 It is free and open source.

 It has an industrial level of development environment

 It supports many other languages

 Visual studio Code tools has a lot of plugins which are quickly updated

with the latest technology that can be integrated into existing code.

II. MYSQL

 High speed. Using the SQL queries, the user can quickly and efficiently

retrieve a large number of records from a database.

 Free

 Portability

 Multiple data view

 XAMPP/WAMP Server

III. Data Conception Elementary Data Dictionary

The consistency and reliability of our database (DB) is based on structuring of

data that can be manipulated by the system easily. For this purpose, the database

is arranged respecting normalization. The database is made up of three tables:

One for collecting user data, the other for collecting data about projects

worked/working on and the customer’s table. The datatypes collected here are

more dates, varchar, text as shown in the phpMyAdmin screenshots below;

WRITTEN BY TCHINDA ADELAIDE 39

 pharmacy management system

PART 2: RESULT OBTAINED

Figures 4: Welcome and login screen

WRITTEN BY TCHINDA ADELAIDE 40

 pharmacy management system

Source: Student interns

Figures 6: Super admin dashboard

WRITTEN BY TCHINDA ADELAIDE 41

 pharmacy management system

Figures 7: Admin dashboard

Source: Student interns

Figures 8: Delegate landing page and dashboard

WRITTEN BY TCHINDA ADELAIDE 42

 pharmacy management system

Figures 9:Delegate perform attendance

Figures 10: Delegate attendance successfully created

WRITTEN BY TCHINDA ADELAIDE 43

 pharmacy management system

Figures 11: Attendance already exist

Figures 12: User logout of the system

WRITTEN BY TCHINDA ADELAIDE 44

 pharmacy management system

CHAPTER 4

DIFFICULTIES ENCOUNTERED AND

SUGGESTIONS
This chapter is made up of two sections. Section 1 which gives the difficulties

encounter on the building of the project and Section 2 which gives the

suggestion.

SECTION 1: DIFFICULTIES ENCOUTERED

 Lack of clear understanding of object-oriented concepts in PHP and

JavaScript.

 Problem of internet connection to access resources available online.

 Inadequate capital for transport during internship period.

 Problem of testing the application on different devices.

 Problem to install application on different operating system like Marcos

X.

 Problem to create the finger print authentication for user.

SECTION 2: SUGGESTIONS
For further studies, the system will be composed of the following functionality

 A finger print authentication for users of the system.

WRITTEN BY TCHINDA ADELAIDE 45

 pharmacy management system

 A mobile application for student to access the system and view their

attendance, time table, continuous assessment marks, personal

information.

 Administrator who is in charge of managing the attendance can contact

the delegate of each specialty.

 Last but not the least, a two-factor authentication for forget password.

WRITTEN BY TCHINDA ADELAIDE 46

 pharmacy management system

GENERAL CONCLUSION
The objectives of this project were to develop a pharmacy management system

which will facilitates the pharmacies to review all the report of the pharmacy in

a particular day or month of a year. This involve designing a user interface and a

database to collectively collect and store all attendance of each specialty of and

institute or school. This system is to replace the manual form in which the

school perform attendance and the way they store information which was highly

stressful and insecure. This website is divided in two main parts, the FRONT-

END and the BACK-END. The front-end is made up of HTML, CSS and

JAVASCRIPT, using frameworks like BOOTSTRAP and JQUERY and AJAX.

The web structure and the mark-up are handled by HTML and the styling is

done with CSS and BOOTSTRAP. The back-end handled with pure PHP and

SQL and stored in MARIADB database. Bringing this system to working was of

great use to the company. My internship at STARTECH was an overall good

experience. I learnt many things about the professional world though we were

dealing real client’s projects. As software engineers it is important to understand

and then see the real world and how our software impact an organization to

solve the problem of time and space complexity.

WRITTEN BY TCHINDA ADELAIDE 47

 pharmacy management system

REFERENCES
https://code-projects.org/attendance-management-system-using-php-source-

code/ 08-08-2021, 06:30pm

https:////www.w3schools.com/jquery/jquery_ajax_load.html 10-08-2021,

06:39pm
https:////www.w3schools.com/jquery/jquery_ref_ajax.html 15-10-2021,

08:30pm
https:////www.w3schools.com/index.html 18-10-2021, 09:30pm
https:////www.w3schools.com/php/php_echo_print.html 08-11-2021, 06:30pm
https:////www.w3schools.com/php/php_string.html 08-11-2021, 14:30pm
https:////www.w3schools.com/jquery/jquery_ajax_load.html 23-12-2021,

04:30pm
https://profile.oracle.com/myprofile/account/confirmed.jspx 08-01-2022,

10:30pm
https://dribbble.com/get-started#welcome 05-02-2022, 06:30pm
https://devdocs.io/javascript/global_objects/array/@@iterator 27-03-2021,

09:40pm
https://www.youtube.com/watch?v=p22goYs2wns 12-02-2022, 07:36pm
https://github.com/duclairdeugoue/HND_PROJECT 10-02-2022, 06:30pm
https://www.techopedia.com/definition/13132/project-management-software

18-03-2022, 06:30pm
https://itsourcecode.com/fyp/student-management-system-project/ 25-03-2022,

06:30pm

WRITTEN BY TCHINDA ADELAIDE 48