-
Designing A Hospital Inventory Management System
[A CASE STUDY OF UNIVERSITY OF IBADAN HEALTH SERVICES (JAJA CLINIC)] -
-
-
3.6.0 SYSTEM DESIGN
3.6.1 Input design
The whole process of the existing system starts when the patient health condition has been observed by the medical doctor and prescription made in the patient prescription card to know the type of drugs to use and when to use them. It also involves the input to the system that will be manipulated to produce the required output.
The patient name: - The name of the student/staff that is collecting the drug(s).
Drug prescribed: - The type of drugs prescribed.
Dosage mentioned: - The dosage for each drugs prescribed by the medical doctor is stated in the drug allocation.
3.6.2 Output design
This is the output of process analysis on input, it refers to the final report from input processing, through the input and process analysis, the management of the hospital can ascertain how drugs are dispensed without encountering any problem. The following are the output analysis.
The number of drugs in stock, dispensed daily, weekly, monthly, or yearly is known, knowing when to re-order will help the management and administration of the hospital in making decisions for them to achieve their goal. This will also help them to know the number of patients involved to budget and plan for good services for them.
This will also help them to enhance efficiency, effectiveness and operational management of the hospital.
3.6.3 Database design
In discussing a database, we must differentiate between the database schema, which is the logical design of the database, and a database instance, which is a snapshot of the data in the database at a given instant in time. The concept of a relation corresponds to the programming- language notion of a variable. The concept of a relation schema corresponds to the programming-language notion of type definition. It is convenient to give a name to a relation schema, just as we give names to type definitions in programming languages. We adopt the convention of using lowercase names for relations, and names beginning with an uppercase letter for relation schemas. In general, a relation schema consists of a list of attributes and their corresponding domains
The database schema for the application is shown below:
-
-
-
ABSRACT - [ Total Page(s): 1 ] Coming Soon ... Continue reading---
CHAPTER ONE - [ Total Page(s): 2 ] CHAPTER ONE1.1 INTRODUCTIONLack of knowledge of the availability of some drugs in hospitals can affect the treatment of patients in hospitals. The hospital inventory management system is a system that maintains inventories of drugs. It is stored in the system database, which helps the Hospital management, Staff, Doctors and Nurses in taking absolute care of the patients in the Hospital. Hospital inventory management system also involves the clinical sphere of healthcare service performa ... Continue reading---
CHAPTER TWO - [ Total Page(s): 3 ]In some clinics, a computer is used, albeit in an experimental way to interview patient before or after they see a doctor in order to collect information for the patient’s record and even to assist with the diagnostic process. It is suggested that patients are more relaxed and honest and frank with their replies when faced with an impersonal machine. The computer may assist in medical diagnosis; for example, there are programs that can carry out electro-cardiogram analysis to determine bo ... Continue reading---
CHAPTER FOUR - [ Total Page(s): 9 ]CHAPTER FOUR4.1 SYSTEM REQUIREMENTSThe requirements needed for the successful running and implementation of this software are described below and are divided into two parts which are the hardware requirements and software requirements.4.1.1 HARDWARE REQUIREMENTSIn order for the software developed using to function properly, the following is the minimum hardware requirement:i. 1GHz Intel Pentium IV processorii. Minimum of 250GB hard disk spaceiii. Minimum of 2GB of a ... Continue reading---
CHAPTER FIVE - [ Total Page(s): 1 ]CHAPTER FIVESUMMARY, CONCLUSION AND RECOMMENDATION5.1 SUMMARYThe positive effect and the advantage of computer can never be over emphasized to large extent, computer has been useful to almost all the field of human endeavors and therefore, it will serve a great deal in the hospital inventory of drugs dispensing, ordering and re-ordering at the University of Ibadan health services (Jaja Clinic) if the new system is implemented.5.2 CONCLUSIONIn conclusion hospital inventory management ... Continue reading---
REFRENCES - [ Total Page(s): 1 ]REFERENCES1. Oxford advance beginners dictionary by Edward Jonathan (2005) 5th edition.2. Dr. Tom Hasting, Harvard University, journal (Hospital management, 1996)3. The Role of Hospital Inventory. Vanguard Newspaper August 9th (2007) Pg 6-18.4. The Danger Of Over-stocking And Under-stocking, Donal (2005)5. Computer and Society. Osuagwu (2007),6. The role of effective health care delivery in Nigeria. Olanrewaju (2006)7. A study on effective stock taking a ... Continue reading---
-
ABSRACT - [ Total Page(s): 1 ] Coming Soon ... Continue reading---