31-07-2012, 03:57 PM
DISTRIBUTED DATABASE PHARMACY MANAGEMENT SYSTEM
pharmacy2.pdf (Size: 1.11 MB / Downloads: 475)
ABSTRACT
The Distributed Database Pharmacy Management System (PMS) is
developed especially for Pharmacy Murni, which is located at Batu Pahat, Johor.
This application is developed to manage the medicine inventory and provide backup
and recovery for security management of information in the pharmacy. It is an online
system which can only be access within three main users; there are database
administrator, pharmacist and pharmacist assistant. Only authorized user can login
into the system and view the PMS application. The database administrator will
maintain the backup and recovery and user privilege to view the system. Besides
that, pharmacist's job is to manage the sales record of medicine besides using the
medicine selector to choose the suitable medicine for specific symptom name.
Furthermore, the pharmacist assistant job is to manage the order, payment and
supplier details. On the other hand, this PMS application is focused more on database
management of medicine besides maintaining the backup and recovery for the
records in the database. The methodology of this system is System Development Life
Cycle, SDLC and Database Life Cycle, DBLC. An analysis study has been done
based on the current manual system and all the problems statements and
requirements have been identified.
INTRODUCTION
Project Background
Most of the pharmacies nowadays, like to use file system because it is a
traditional way and peoples are comfort with that way. But today, the technologies
has changes a lot and because of that almost all the application in the world prefer to
use computer as their stored information place. More recently, the pharmacy
management is focused on storing stock information such as types of medicines,
price, medication review and drug information. Currently, to keep track on sales
transaction such as stock and order information, manual recording system is used by
the pharmacist. This system has many disadvantages because the pharmacist always
busy with the sales transaction rather than managing the patient who comes to the
pharmacy.
Project Significance
For project significance, it will be explain based on user level such as database
administrator and pharmacist in the pharmacy. PMS provides backup and recovery to
ease the work of database administrator. Besides that, this project will help to ease
the staff works in the pharmacy and increase the work performance of the staff in
case of PMS's usability. The pharmacies can spend more time in serving the
customer who comes to the pharmacy and because of that the pharmacy will get
more attention to the public.
In addition, this project is better compared to manual system which using files
system to keep the sales record. It is because of the security issues that is
implemented in this system will help to increase security level in maintaining the
records information. Besides that, in terms of accessibility the data will be remains
save because of the different level of users had been applied in this project.
Conclusion
In this chapter, a new system will be proposed for Pharmacy Murni at Batu
Pahat which is called as Pharmacy Management System (PMS). Furthermore, the
scenario of this company can be seen through this chapter. There are many problems
appear when the file system is used to store and searching staffs information,
medicine, order details and supplier's information. Therefore, this new system is
proposed to improve the file system by developing a simple and user friendly system
to the manager and staffs. Lastly, every record will be maintained in the database and
will be easier to manage. The next chapter will be cover about Literature Review and
Project Methodology.