An Online Health Insurance Management System Case Study: Mengo Hospital

TABLE OF CONTENTS

DECLARATION

APPROVAL ii

DEDICATION iii

ACKNOWLEDGMENTS iv

TABLE OF CONTENTS v

LIST OF FIGURES viii

LIST OF TABLES ix

ABBREVIATIONS x

CHAPTER ONE

1 INTRODUCTION 1

1.0 Background 1

1.1 Research Questions 1

1.2 Problems Statement 1

1.3 Main objective of the Project 2

1.4 Specific Objective 2

1.5 Justification of the Study 2

1.6 Scope 3

1.6.1 Academic scope 3

1.6.2 Time Scope 3

1.6.3 Geographical scope 3

1.6.4 Content Scope 3

CHAPTER TWO 4

LITERATURE REVIEW 4

2.0 Introduction 4

2.1 Advantages of databases 5

2.2 Qualities of a good database 5

2.3 Types of databases 6

2.3.1 Operational database 6

2.3.2 Data warehouse 6

2.3.3 Analytical database 7

2.3.4 Distributed database .7

2.3.5 End-user database 7

2.4 Online Systems 7

2.4.1 Advantages of Online Systems 7

CHAPTER THREE 9

METHODOLOGY 9

3.0 Introduction 9

3.1 Interviews 9

3.1.1 Advantages of Interview 10

3.2 Questionnaires 10

3.3 Observations 10

3.3.1 Advantages of observation 11

3.4 System Analysis and Design 11

3.5 System Implementation 11

3.6 Testing and Validation 11

3.7 Design Priorities 11

CHAPTER FOUR 12

SYSTEM ANALYSIS AND DESIGN 12

4.0 Introduction 12

4.1 System Analysis 12

4.1.1 System Study 12

4.1.2 Strength of the Current System 12

4.1.3 Problems of the previous system 13

4.1.4 Possible Solutions to the Current System 13 4.1.5 Proposed System Requirements 13 4.1.6 User Requirements 14 4.2 Functional Requirements 14 4.3 System Requirements 15 4.3.1 Hardware Requirements 15 4.3.2 System Design 16 4.4 Dataflow Diagrams 16 4.4.1 Database Design 20