A Profiling Repository for Efficient Sharing of Patients’ Information Between Doctors and Nurses at Hospice Africa Uganda

ABSTRACT

This study focused at designing and implementing a profiling repository for efficient sharing of patients’ information between doctors and nurses at hospice Africa Uganda Makindye office which will handle effectively and efficiently the management of patients’ information.

The system was able to address the following problems; all medical records holders were recorded on paper cards and kept in big files pilled in the records store, most of the patients’ information was kept on papers more so by inexperienced personnel and there is not much sensitization about the usage of computer based systems to the health workers

The researchers used the following techniques and approaches in order to achieve the objectives of the study. It covers the requirements elicitation process, system analysis and design, implementation, testing and validation.

The system design used two-tier client server architecture whereby the database was implemented using MySQL whereas the interface was implemented using VB 6.0

The significance of the study is to make the Patients Records Management, Process and Storage much simpler. And also improve on the speed with which the Medicare process is done while profiling the patients

TABLE OF CONTENTS

DECLARATION

APPROVAL ii

DEDICATION iii

ACKNOWLEDGEMENT iv

ABSTRACT Viii

ABBREVIATIONS ix

CHAPTER ONE 1

INTRODUCTION 1

1.1 Background 1

1.2 Problem Statement 2

1.3 Objectives 2

1.3.1 General Objective 2

1.3.2 Specific Objectives 2

1,4 Scope of the Study 3

1.5 Significance 3

CHAPTER TWO 5

LITERATURE REVIEW 5

2.1 Introduction 5

2.2 Information systems 5

2.2.1 An Information system 5

2.2.2ASystem 5

2.2.3 Information 6

2.3 Components of an Information System 9

Information systems life cycle 10

2.3.1 Categories of Information Systems 10

2.5 Management Information System (MIS) 11

2.5.1 Patients Records management Information System 11

2.5.2 Information Systems used Hospice Africa Uganda 11

2.5.3 The relevance of the patients records management system 12

2.6 Database Management Systems (DBMS) 12

2.7 Database 12

2.8 Database Models 13

2.9 Relational Database Management System (RDBMS) 13

2.10 Summary 14

CHAPTER THREE 15

METHODOLOGY 15

3.1 Introduction 15

3.2 System Study and Investigation 15

3.2.1 The Organizational Structure of Hospice Africa Uganda 16

3.3 Literature Review 16

3.4 Questionnaires 16

3.5 Interviews 17

3.6 Observation 17

3.7 System Analysis and Design 17

V

3.8 SystemImplementation.17

3.9 System Testing and Validation 18

3.10 Consultations 18

CHAPTER FOUR 19

SYSTEM ANALYSIS AND DESIGN 19

4.1 Introduction 19

4.2 Requirements Elicitation and Analysis 19

4.3 Requirements specification 19

4.3.1 User requirements 19

4.3.2 System Requirements 20

4.4 System design 21

4.4.1 Context models 21

4.4.2 Weaknesses of the existing system 22

4.4.3 Proposed System Modeling 23

4.4.4 Processes and sub-processes involved in the System 23

4.4.5 Entities involved in the system 24

4,4.6 Data stores 24

4.4.7 Level -0 Data Flow Diagram for the System 25

4.5 Database Design 26

4.5.1 Conceptual Design 26

4.5.2 Entities and their attributes 27

4.5.3 Relationships 29

4.7 Physical Design 31

4.7.1 Description of relations (Data dictionary) 31

4.8 Interface Design 34

Patients details form 34

Patient admission form 35

CHAPTER FIVE 36

SYSTEM IMPLEMENTATION 36

5.1 Introduction 36

5.2Forms 36

5.2.1 Login Form 36

5.2.2 The Menu Form 37

5.2.3 Patients details form 38

5.2.4 Patient Admission Form 39

5.2.5 Patient Search Form 40

5.3 Database tables 41

5.3.1 Patients details database table 42

5.3.2 Patient admission database table 42

5.4 Reports 43

5.4.1 Patient’s details report 43

5.4.2 Medical Treatment report 43

CHAPTER SIX 45

DISCUSSIONS, CONCLUSIONS AND RECOMMENDATIONS 45

6.1 Introduction 45

6.2 Discussions 45

vi

6.3 Conclusions.45

6.4 Recommendations.45

6.5 Limitations 46

6.6 Future Research 46

REFERENCES 47

APPENDICES 48

APPENDIX A: PLAN AND EXECUTION OF ACTIVITIES 48

APPENDIX B: TIME SCHEDULE 49

APPENDIX C: PROJECT BUDGET 50

APPENDIX D: INTERVIEW GUIDE FOR STAFF AND PATIENTS AT HOSPICE

AFRICA UGANDA STAFF 51

APPENDIX F: QUESTIONNAIRE 52