Design of a Patient Record System for Shashemene Referral Hospital

No Thumbnail Available



Journal Title

Journal ISSN

Volume Title


Addis Ababa University


Background: To provide quality of health care, medical practitioners require complete, accurate, and timely data. Practitioners need to know their patients’ medical history to avoid prescribing treatments that may have adverse effects. Though, most medical records are kept in voluminous paper files, typically located in doctors’ offices or other health service provider sites. These files are often not available when most needed in addition report generation from these files is also difficult and not timely. To overcome this catastrophic problems designing of a patient record system is mandatory Objective: The proposed project attempted to Design a Patient Record System for Shashemene Referral Hospital which enables the user of the system to use patient data effectively and to pass good decision on patient treatment. Methodology: The proposed project used Structured System Analysis and Design system development approach and it used different data collection tools i.e. (interview, observation and relevant document review techniques) to collect sufficient data needed for the system to be developed. Analysis and design of the proposed system was performed by using analysis and design technique i.e. Data Flow Diagrams (DFD) for process modeling, Activity Diagram and Entity Relationship Diagrams (ER) for data modeling, for programming language Hypertext Preprocessor (PHP) and Hyper Text Markup Language (HTML) were proposed for implementation phase. Structured Query Language (SQL) server 2008 and Microsoft Access 2007 were the tools used for data base table construction and their relationship. For data flow diagram the tool used was Microsoft Visio 2007. Result: The developed design of a patient record system for Shashemane Referral Hospital incorporates Register new /update repeat patient detailed information, Search patient detail, assign patients to different case team, mange ; patient treated at Out Patient Department (OPD) , admitted patient, bed schedule, nursing care plan , discharge summary, user account and generate report. To capture all of these data relational data base system was designed. Finally, system architecture also designed to give a high level view of the new system. Conclusion: Patient health history recording is mandatory it helps the health professionals to easily accesses health history and prevents them from prescribing drugs that has adverse effects which threatens patient’s life. The developed design of a patient record system contains patient registration, management of patient history at Out Patient Department and Inpatient Department and also report generation for stake holders. Recommendations: To achieve the aim of this project Shashemane Referral Hospital, Addis Ababa University and other stake holders should react on the implementation phase of this design document and a great effort should be made to give training of workers at hospital who participate in management of health information.



Design of a Patient Record System