TRADE PROJECT
TITLE: PHARMACY SALES AND INVENTORY SYSTEM
CASE STUDY OF MWATATA NURSING HOSPITAL
CANDIDATE’S NAME:
INDEX NUMBER:703101/
SUPERVISOR:
INSTITUTION NAME: KISII NATIONAL POLYTECHNIC
SUBMITTED TO: KENYA NATIONAL EXAMINATION
COUNCIL FOR PARTIAL FULFILMENT OF THE AWARD OF
DIPLOMA IN INFORMATION COMMUNICATION AND
TECHNOLOGY
DATE: NOVEMBER, 2022
i
, DECLARATION
The is my original work and has not been submitted previously for a degree at this or any
other institute. For the award of diploma in Information Communication Technology
To the best of my knowledge it does not contain any material published or written by another
person, except as acknowledged in the text.
ii
, ACKNOWLEDGEMENT
First and foremost, I would like to express my sincere gratitude to my supervisor for the
continuous support he had gave me. His comments, encouragements, patience, enthusiasm,
knowledge and guidance helped me in all the time of this project and writing of the thesis.
Besides my supervisor, I would like to thank the rest of my lecturers in the Kisii National
Polytechnic, who helped me to improve my knowledge and professional qualifications
throughout this education study program. I take this opportunity to respect them as well.
In addition, I would like to thank my friends for helping me in various ways. When I had
problems in my implementation stage my friends always provided the guidelines to overcome
them. Without their guidance, the project could not have been successfully completed.
Finally, I must express my very profound gratitude to my mother and to my relations for
providing me with unfailing support and continuous encouragement throughout my years of
study and through the implementation of project and writing this thesis. This accomplishment
would not have been possible without them.
iii
, ABSTRACT
This project illustrates the designing and implementation of a web based Pharmacy Sales and
Inventory system for the. The primary aim of is to improve accuracy and enhance safety and
efficiency in the pharmaceutical store by minimizing issues occur in day to day operations.
Currently they are using a manual system which is very hard in handling. Managing the stock
with paper records based on the expiry dates and the quantity available in the stock are some
major problems identified in the problem domain. The system intends to minimize the
workload of the staff and increase the value of the business to gain the competitive advantages
in the pharmaceutical industry.
The system allows different tasks for different users. They are administrator who can logging
the system as different user roles to perform their functions separately. Administrator has all
privileges of the system. Create users, generate reports for managerial decisions, manage
employee attendance are some administrator tasks. In addition, the system will show a
notification about expiry dates of drugs and stock ending details. It is easy to handle stock
management through the software rather than working with paper records.
Customers are the main asset of the business. So, the system will help to reduce waiting time
of the customers. They can check the availability of the items before they come to the
pharmacy by using the search facility provided in the pharmacy web site.
iv
TITLE: PHARMACY SALES AND INVENTORY SYSTEM
CASE STUDY OF MWATATA NURSING HOSPITAL
CANDIDATE’S NAME:
INDEX NUMBER:703101/
SUPERVISOR:
INSTITUTION NAME: KISII NATIONAL POLYTECHNIC
SUBMITTED TO: KENYA NATIONAL EXAMINATION
COUNCIL FOR PARTIAL FULFILMENT OF THE AWARD OF
DIPLOMA IN INFORMATION COMMUNICATION AND
TECHNOLOGY
DATE: NOVEMBER, 2022
i
, DECLARATION
The is my original work and has not been submitted previously for a degree at this or any
other institute. For the award of diploma in Information Communication Technology
To the best of my knowledge it does not contain any material published or written by another
person, except as acknowledged in the text.
ii
, ACKNOWLEDGEMENT
First and foremost, I would like to express my sincere gratitude to my supervisor for the
continuous support he had gave me. His comments, encouragements, patience, enthusiasm,
knowledge and guidance helped me in all the time of this project and writing of the thesis.
Besides my supervisor, I would like to thank the rest of my lecturers in the Kisii National
Polytechnic, who helped me to improve my knowledge and professional qualifications
throughout this education study program. I take this opportunity to respect them as well.
In addition, I would like to thank my friends for helping me in various ways. When I had
problems in my implementation stage my friends always provided the guidelines to overcome
them. Without their guidance, the project could not have been successfully completed.
Finally, I must express my very profound gratitude to my mother and to my relations for
providing me with unfailing support and continuous encouragement throughout my years of
study and through the implementation of project and writing this thesis. This accomplishment
would not have been possible without them.
iii
, ABSTRACT
This project illustrates the designing and implementation of a web based Pharmacy Sales and
Inventory system for the. The primary aim of is to improve accuracy and enhance safety and
efficiency in the pharmaceutical store by minimizing issues occur in day to day operations.
Currently they are using a manual system which is very hard in handling. Managing the stock
with paper records based on the expiry dates and the quantity available in the stock are some
major problems identified in the problem domain. The system intends to minimize the
workload of the staff and increase the value of the business to gain the competitive advantages
in the pharmaceutical industry.
The system allows different tasks for different users. They are administrator who can logging
the system as different user roles to perform their functions separately. Administrator has all
privileges of the system. Create users, generate reports for managerial decisions, manage
employee attendance are some administrator tasks. In addition, the system will show a
notification about expiry dates of drugs and stock ending details. It is easy to handle stock
management through the software rather than working with paper records.
Customers are the main asset of the business. So, the system will help to reduce waiting time
of the customers. They can check the availability of the items before they come to the
pharmacy by using the search facility provided in the pharmacy web site.
iv
