‘fable of Contents
Declaration
Dedication IV
ACKNOWLEDGEMENT V
Abstract
CHAPTER ONE 1
INTRODUCTION 1
Introduction 1
I Background 1
1.2 Statement of the problem 2
1.3 OI3JECTIVE OF THE STUUDY 2
1.3.1 General objective 2
1.3.2 The specific objectives of the study are; 2
1.5 Scope of the study 3
1.5.1 Content of the study 3
1.5.2 Geographical Scope 3
1,5.3 Th~ie Scope 3
1.6 Significance of the study 3
CHAPTER TWO 6
I .ITFRAFURE REVIEW 6
2.0 Introduction 6
2.1 Understanding the Computerized database system and management system 6
2.1 .1 Database management system 6
2.1 .2 Computerized database system 6
2.1.3 Importance of computerized database management system 7
2.1 .4 Information management system 7
2. I .51 ~‘pes of Management Information Systems 7
2.1.6 Financial Management Information Systems 8
2.1.7 Human Resources Management Information Systems 8
ClIAPTER ThREE 10
RESEARCI-I METFIODOLOGY 10
3.0 Introduction 10
3.1 Rapid Prototyping 10
Vii
vm
3.2 Rcquiremerits specification (analysis) phase .10
3,2.1 System specification 11
3.2.1.1 Staffs’ 11
3.2.1.2 System administrator 11
3.3 Methods of data collection 11
3.3.1 Interviewing 11
3.3.2 Observation 11
3.3.3Quick Design 12
3.4 Developing/building computerized database management system 12
3.4.1 Graphical user interface tools 12
3.5.1 Database Development tools and programming languages 12
3.6 Software tools and Platforms 12
3.6.] StationeryTools 13
3.6.2 Hardware Tools 13
3.7 Assumption made by the Researche 13
3.8 Limitations of the study 13
Chapter FOUR 14
System Design 3fld Implementation 14
4.1 Description of the system 14
4.1.1 System overview 14
4.1.2 The system user levels 14
1. The system Administrator level 14
2. Staffs’ 15
4.1.3 Hardware Specifications 15
1. Minimum Specifications 15
2 recommended specifications 15
4.1.4 Software specifications 15
1. Minimum Specifications 15
2. Recommended Specifications 15
4.1.5 Pseudo Codes 16
4.1.5,1 Log in to System 16
4.2 System Flow 17
4.2.1 Data Flow Diagram 17
viii
Ix
4.3 Data Inputs .18
4.3.1 Physical Database design 18
4,3.2 Logical Database Design 25
4.4.1 MGHDBS Home/welcome page 26
4.4.2 validations and testing user interfaces 27
4.4.3 System security and data safety 27
4.5 Data entry forms and form outputs 29
4.5.1 Patient registration entry form 29
4.6 Deleting and Updating data 32
4.6.1 Updating data 32
4.6.2 Deleting data 33
4.6.3 Searching for data/information 33
CHAPTER FIVE 34
5.1 Introduction 34
5.2. Discussions 34
5.2.1 System Security 34
5.2.2 Searching in the system 34
5.2.3 Target group 35
5.3 limitations of the research 35
5.4 System Scalability 35
5.5 Future research areas 35
5.6 contribution to the group 35
5.7 Experience gained from the group 36
5.8 Recommendations 36
5.9 Conclusion 37
References 38
APPENDICIES 39
APPEDIX 1: GANT CHART 39
Appendix 2: Budget 40
Abstract I-lealth contributes to the wellbeing of the people in the country, many people suffer from many sicknesses making them to visit hospitals for treatment, medical centers, health units, clinics and many other health providing institutions in Uganda. In ordcr to provide best quality, efficient and effective health facilities to patients, hospitals, and other health services providers should adapt technology in carrying out the managerial activities in hospital so as to provide efficient retrieval and easy searching of information for effective management performance. Mukwaya general hospital (MGI-I) is one of the hospital in Uganda licensed by the Ministry of I-Iealth and it is involved in the provision of health services of emergency nature, hospitalization and routine outpatient Computerized Hospital Management system is a web-based computerized system that electronically stores data and relevant information in regards to hospital management. The system processes patient forms, managerial records such as finance, human resource, laboratory and hospitalization records especially in wards to allow efficient retrieval and data storage. lie system provides high security and data safety capabilities through the implementation of activate and deactivate commands used by a system administrator to grant permission to staffs on system’s resources compared to paper files which are liable to threats such as theft, data duplication, lost through fire hazards, rats and so many other threats to mentioned but a few. the objectives and goal of Computerized Hospital Management System will be achieved by using Rapid prototyping methodology, it will be used for collecting various fact finding methods like interviews and observations, different software and hardware tools, programming logic and a rigorous testing procedure. The system aims at improving the level of efficiency of data management and Hospital activities by the Doctors and nurses.