A SECURE INFORMATION SYSTEM FOR MANAGING CLIENT DATA IN AN HEALTH INSTITUTION CASE STUDY: MAYANJA MEMORIAL HOSPITAL MBARARA

ABSTRACT

The research focused on creating a secure Health Information Management System to enable communities to have easy access of information about their personal health records available in health centers. Lack of simple, reliable, affordable, and easy ways for accessing the personal health records is the major problem that leads to researchers conducting this project. The researchers created secure health information system application that will be used by health centers to access the health record of their patients. Researchers used technologies such as PHP, My SQL, wampserver and other tools to develop this application. The project was successful and the complete system created by researchers is functioning as intended.

TABLE OF CONTENTS

DECLARATION

DEDICATION

APPROVAL iv

ACKNOWLEDGEMENT v

ABSTRACT vi

TABLE OF CONTENTS vii

LIST OF ABBREVIATIONS xi

INTRODUCTION 1

1.0 Introduction 1

1.1 Background of the study 1

1.2 Problem statement 2

1.3 Purpose of the study 2

1.4 Objectives of the study 2

1.4.1 General objective 2

1.4.2 Specific objectives 2

1,5 Research questions 2

1.6 Significance of the study 3

1.7 Scope of the study 3

1.8 Conceptual Framework 4

1.9 Conclusion 5

CHAPTER TWO 6

LITERATURE REVIEW 6

2.0 Introduction 6

2.1 Computer Network 6

2.1. 1 Types of networks 6

2.1.1.1 Local area network (LAN) 6

2.1.1.2 Metropolitan Area Network (MAN) 7

2.1.1.3 Wide Area Network (WAN) 7

2.2 Information Systems (IS) 7

2.2. 1 Components of information systems 7

2.2.1.1 Computer Hardware 7

2.2.1.2 Computer software 8

2.3.1.3 Databases 8

vii

2.3.1.3.1 Types of Databases g

2.3.2 Types of information system 11

2.3.2.1 Executive Support Systems ii

2.3.2.2 Management Information Systems ii

2.3.2.3 Decision Support Systems ii

2.3.2.4 Office Automation Systems 11

2.4 Management Information Systems (MIS) 12

2.5 HealthCare Management Information system (HCMIS) 12

2.6 Integrated HealthCare Management Information Systems (JHCMIS) 12

2.7 Conclusions 13

CHAPTER THREE 14

RESEARCH METHODOLOGY 14

3.0 Introduction 14

3.1 Research Design (Case Study Design) 14

3.2 Study Population 14

3.3 Sample size

3.4 Sampling and sampling techniques 14

3.5 Unit of analysis 15

3.6 Research Instruments/Tools 15

3.6.1 Questionnaires 15

3.6.2 Interviews 15

3.6.3 Examining the Hospitals documentation 15

3.7 Methods of data collection 15

3.7.1 Data Flow Diagrams (DFDs) 15

3.7.2 Entity Relationship Diagrams (ERD) 16

3.7.3 Software development tools 16

3.7.3.1 Hypertext Preprocessor (Php) 16

3.7.3.2 My structured query language (MYSQL) 16

3.7.3.3 JavaScript 16

Is a client-side scripting language for web pages. JavaScript was used to validate

data before sending the content to the database 16

3.7.3.4 Wamp5 Server (1.6.6) 16

3.7.3.5 PhpMyAdmin 17

3.7.3.6 Macromedia Dream weaver 17

VIII

3.8 Limitations of the study .17

3.9 Conclusion 17

CHAPTER FOUR~

SYSTEMS ,FINDINGS,ANALYSIS AND DESIGN 18

4.0 Introduction 18

4.1 Findings 18

4.2 Analysis of the current system 18

4.2.1 The Existing system at Mayanja Memorial Hospital 18

4.2.2 The current input and storage of data 18

4.2.3 Weaknesses in the current system 19

4.3 Suggested System 19

4.3.1 Requirements 19

Table 1: System Hardware Requirements ~

Table 2: System Software Requirements

4.4 System Design 21

4.4.1 Data Flow Diagrams (DFDs): 21

4.4.2 Requirement Testing 22

4.4.3White box testing 22

System Testing

4.4.4Types of tests included in this project testing 23

Black box testing .24

In the usability testing the Black box procedure was used to test the M-Vigour

System 24

4.5 User interface and design 26

4.5.1 Login page 26

Figure 2: Login page design 26

4.5.2 Administrator page 26

Figure 3: Administrator page design.. .. ... ....... ..... . ..... .........27

4.6 Database Design 27

4.6.1 Conceptual Database Design