Centralized Information Management and Data Base System Case Study: Bukoto Market Vendors Savings and Cooperative Society

TABLE OF CONTENTS PAGE

CHAPTER ONE

Declaration i

Approval ii

Dedication iii

Acknowledgement iv

Table of contents v

Abstract ix

1.0 Introduction 1

1.1 Background of the study 1

1.2 Problem statement 3

1.3 Purpose of the study 4

1.4 Objectives of the study 4

1.5 The Scope of the Study 4

1.6 Significances of the study 4

CHAPTER TWO: LITERATURE REVIEW

2.0 Introduction 6

2.1 Information systems 6

2.1.2 Management Information Systems 7

2.1.3 Benefits of Management Information Systems 9

2.1.4 Challenges/Barriers Associated with Management information systems 10

2.2 Database 11

2.2.1 Classification of Database 13

v

2.2.2 Relational data base management system 13

2.2.1 Database security 13

2.2.2 Database Maintenance 15

2.3 Types of database 15

2.3.1 Data warehouse databases 16

2.3.2 Relational database 16

2.3.3 Hierarchical database 16

2.3.4 Network database 17

2.3.5 End- user database 17

2.4 Advantages of a database 17

2.5 Database Management System 19

CHAPTER THREE: SYSTEM STUDY AND INVESTIGATION

3.1 Introduction 21

3.2 Data collection techniques 21

3.2.1 Observation 21

3.2.2 Document review 21

3.3 Data sources 22

3.3.1 Primary data 22

3.3.2 Secondary data 22

3.4 Data Processing and Presentation 22

3.4.1 Data processing 22

3.4.2 Data presentation 23

3.4.3 Research Design 23

vi

3.4.5 Sample selection .23

3.5 Systems Requirements and Analysis of Specification 23

3.4.1 User requirements 24

3.4.2 Functional Requirement 24

3.4.3 Non-functional requirements~ 25

3.4.4 Systems requirements 25

3.4.5 Sofiware requirements 25

3.4.6 Hardware requirement 26

3.5 System Design 26

3.5.1 Description of the system 26

3.6 System development life cycle (SDLC) 26

3.6.1 Prototyping 26

3.8.2 Choice of entities and attributes 28

3.9 Entity relation diagram 30

CHAPTER FOUR: PROJECT IMPLEMENTATION

4.0 Introduction 31

4.1 System features 31

4.2 The switch board 32

4.3 Main form 33

4.4 Membership entry form 34

4.5 Employee form 35

4.3.1 Tables 35

4.3.1.1 Membership table 35

vii

4.3.1.2 Employee table .36

4.3.1.3 Transactions table 36

4.3.1.4 Loan processing table 36

4.5 Queries 36

4.74.6 System testing 36

4.10 Conclusion 38

CHAPTER FIVE:

DISCUSSION, CONCLUSIONS RECOMMENDATION

5.0 Introduction 39

5.1 Discussion 39

5.2 Conclusion 40

5.3 Recommendations 40

5.4 Limitations of the study 41

REFERENCES 42