Pharmacy stock management system case study: Lindo pharmacy Malaba.

Abstract

This project was aimed at designing a web-based Pharmacy Stock Management System; a system to aid in the management and operation of the pharmacy. Methods that were used to gather information about the current system include; interviews, record review and questionnaires. From that information, requirements for the new system were obtained. The methodologies used include the Structured System Analysis and Design (SSAD) which was used for analysis and designing the system as well as the RAD (Rapid Application Development) which was easy to deliver a working system with all the modules worked upon one after the other. Furthermore, I went ahead and employed MySQL as a database management system, PHP as the technology which is an open source general purpose scripting language that is especially suited for web development and can be embedded into HTML. In addition, HTML (Hyper-text Mark-up Language) and CSS (Cascading Style Sheets) which are the core web scripting languages for building web pages and web applications were used. HTML provided the structure of web pages whereas CSS was mainly used to control the styling and layout of web pages. The system generates reports that are vital for the pharmacy administration.