Currently at Makerere University Hospital there is a manual file system used to manage information about the patient and because of this, record’s manager take long to access patient’s information. This causes a delay in the processing of patients information in order for the patient to be recommended to the available doctor. This study intends to design an online patients’ management system to solve the problem of delayed access to patients’ information.
In an effort to get all the required information, observations were made, interviews conducted so as to get a clear understanding of the requirements. Interviews revealed that a number of problems were associated with the manual system used.
All this information was then used in the analysis and design of the new system. Models like Data Flow Diagrams to illustrate the flow of data in the new system were developed during the analysis stage. Entity Relationship Diagrams were also used to model the data within the system and its relationship .The interface of the database designs were realized during the design stage.
The system was then developed using technologies like HTML, PHP, CSS, MySQL database server Dream Weaver as a developing environment. It was then tested and validated.
In conclusion A solution to the problem was implemented and this was an online patients’ management system which would manage records, student registration, stores patient’s information, doctor and eases access of information by the records manager. Therefore this system is ready and recommended for Makerere university hospital to use it.
Table of Content
DECLARATION
Approval
Dedication
Acknowledgment
Table of Contents
List of Figures
List of Tablesv
List of Acronyms
Abstract
CHAPTER ONE: Introduction
1.0 Introduction
1.1 Background to the problem
1.2 Problem Statement
1.3 Objectives
1.3.1 Main Objective
1.3.2 Specific Objectives
1.4 Scope
1.5 Significance
CHAPTER TWO: LITERATURE REVIEW
2.0 Management Systems
2.1 Database
2.2 Records Management Systems
2.3 Case Studies (Related Systems)
2.3.1 Case Study 1
2.3.2 Case Study 2
2.3.3 Case Study 3
2.3.4 Strength and weaknesses exhibited by the case studies
2.4 Conclusion
CHAPTER THREE:METHODOLOGY
3.0 Introduction
3.1 Study Population
3.1.1 Sampling
3.1.2 Sampling Technique
3.2 Data Collection Techniques
3.2.1 Document Review
3.2.2 Questionnaires
3.2.3. Interviews
3.3 Data Analysis
3.4.Data Processing
3.5 System Design
3.6 Systems Implementation
3.7 System Testing and Validation
3.7.1 Testing
3.7.2 Validation
CHAPTER FOUR:SYSTEM STUDY ANALYSIS AND DESIGN
4.1 System Study
4.1.1 Existing System
4.1.2 The new system ( on line Patients Management system)
4.2 System Analysis
4.2.1 User Requirements
4.2.2Functional Requirements
4.2.4 System Requirements
4.2.5 Software Quality Attributes
4.3 System design
4.3.1 Architectural overview of the patient’s management system
4.3.2 Process Modeling
4.3.3 DFDs for the system
4.4 Data modelling
4.4.1 Conceptual Data Model
4.4.2 Modeling relationships between entities
4.5 Database design
4.5.1 Conceptual design
4.5.2 Logical design
4.5.3 Physical design
CHAPTER FIVE:PRESENTATION OF FINDINGS AND SYSTEM IMPLEMENTATION
5.0 Presentation of Findings.
5.1 Introduction.
5.2 Research Findings.
5.3 system implementation
5.3.1 Sample screenshots from the system
5.4 Testing and validation
CHAPTER SIX: CHALLENGES,CONCLUSION AND RECCOMMENDATION
6.0 Challenges Encountered during the Research project
6.1 Conclusion and Recommendations
6.1.1 Conclusion
6.1.2 Recommendation
References
Appendices
Appendix A: Sample Questionnaires
Appendix B: System Usability Questionnaire
Appendix C:Interview Guide
List of Figures
Figure4. 1: level diagram/context diagram.
Figure 4. 2: level 1 DFD for patients management system
Figure 4. 3: System architecture
Figure 4. 4: Modeling relationship between entities.
Figure 4. 5 : The trends of files at MUH for the year 2012
Figure 5 . 6: People’s satisfaction about the existing system.
Figure 5. 7: The percentage of people’s views about the Patient Management system
Figure 5. 8 : Home page.
Figure 5. 9 : Students registration form.
Figure 5.10 : Registered students interface.
Figure 5. 11: The records Manager interface
Figure 5.12 : The medical personnel interface.
Figure 5.13: Health records of a recommended patient.
Figure 5.14:Medical personnel’s prescription interface to recommended patient.
Figure 5.15: Patient medical report.
Figure 5. 16:People’s views about the system's Effectiveness in Task Accomplishment.
Figure 5. 17 :The usefulness of system Aids and help Manual .
Figure 5. 18 :The views of people in MUH about the Overall Usability analysis.
List of Tables
Table4. 1: A Description of Hardware Requirements
Table 4.2: A Description of software requirements
Table4. 3: A description of DFD key elements and symbols
Table4. 5:A data dictionary for data stores
Table4. 7: Entities and their attributes.
Table 4.8: Description of entity Doctor
Table4. 9: stores information of drugs prescribed
Table 4.10:A description of entity student
Table4. 11:: Description of entity for records manager.
Table4. 12:Other patients
Table 5. 13: people’s view about the system's Effectiveness in Task Accomplishment
List of Appendices
Appendix A: Sample questionnaire
Appendix B: system Usability Questionnaire
Appendix c: Interview Guide
Appendix
D: Pseudo code
CHAPTER ONE: INTRODUCTION
1.0 Introduction
According to Ramkrishnan,R and Gehrke,J (2003) An online based Patient management system is a system used by records managers to manage their patients and cases.
1.1 Background to the problem
The access of patient’s information has been too slow and tiresome due to the large number of students who come for medication and others who come to register in the hospital for the first time as students of Makerere University.
The University hospital is using a file system to keep records for all the patients registered, were by only one record’s personnel is responsible for verifying and accessing all the patients records before being recommended to the medical personnel. The process is too slow and this causes a delay in offering services to both registered and none registered. Therefore there is a need for a computerized patient’s management system that will ease student’s registration, ease access to information by the record’s personnel hence reducing student and patient congestion at the University hospital
1.2 Problem Statement
Currently at the hospital there is a manual file system used to manage information about the patient and because of this records’ personnel take long to access patient’s information. This causes a delay in the processing of patients information in order for the patient to be recommended to the medical personnel. As a result many patients are not attended to, hence the need of a computerized patients management system at the hospital that will display patients information immediately.
This study therefore, intends to design a web based patient management system to solve the problem of delayed access to patients’ information.
1.3 Objectives
1.3.1 Main objective
To develop a computerized on line patients’ management system for Makerere University hospital.
1.3.2 Specific objectives
1. To collect data about the current system in order to identify requirements for patients management system
2. To design an effective the patient’s management system for Makerere University hospital based on the requirements collected.
3. To implement the patient’s management system for Makerere University hospital.
4. To test and validate the patient’s management system
1.4 Scope
This project focused on the development of patient’s management system for Makerere University hospital with the sole purpose of assisting the record’s personnel to ease information access to the patients hence reducing on the patient queue when they come for medication .The people contacted were the students, patients, medical personnel, and the director of the hospital. Only medical records and student’s information were considered and these included:
- Patient personal information
- Laboratory examinations
- Prescriptions and Treatment
- Follow up of the patient
Thus making information available to the records’ manager in the hospital with the purpose of promoting efficiency, quality and safety of patient records.
The effectiveness of management system for Makerere University hospital improves the access and maintenance of patient’s records,
Secondly providing the status of the patients in the short time possible whether registered or not registered and the recommended medical personnel.
It will reduce on the time wasted due to the queues made during the traditional file system of patient- doctor recommendation. This will reduce on the patient waiting for long period of time
Management systems such as the patient’s management system for Makerere University hospital will provide processes such as patient’s registration, retrieving of patient information doctor’s attendance and records management. It will also improve communication by offering an intellectual management base for medical personnel which ease the of patient’s information access
Medical Report generation with related data stored in the system.
Improved security, as regards to access to information stored on the system.
Reduced maintenance costs.