Computerized Database Management System in Mukwaya General Hospital, Kampala

‘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