TABLE OF CONTENTS
DECLARATION
APPROVAL
ACKNOWLEDGEMENT
TABLE OF CONTENTS iv
LIST OF FIGURES
LIST OF TABLES
ABSTRACT
CHAPTER ONE
INTRODUCTION
1.1 Background
1.2 Problem statenient 2
1.3 Objectives 3
1.3.1 General objects 3
1.3.2 Specific objectives 3
1.4 Justifications
1.5 Scope ofthe st~idy 3
CHAPTER TWO
LITERATURE REVIEW
2.0 Introduction
2.1 Tn formation systei~s 4
Related systei~s
2.2 Management Information Systems 6
2.2.1 Benefits of management information system 7
2.2.2 Barrier of management information system 7
2.3 Database
2.3.lClassificatjon of database 7
2.3.2Relational database management system 7
2.3.3 Database security 8
2.3.4 Database majntenaiice 8
2.3.5 Types of the database 9
2.3.5.1 Network Databases 9
2.3.5.2 Hierarchical Databases 9
2.3.S.3Relatjonal database 9
2.3.5.4 Warehouse database 10
2.3.5.5 End-user database 10
2.3.6Advantages of databases 10
CHAPTER THREE 11
SYSTEMS STUDY AND INVESTIGATION 11
3.0 Introductions 11
3.1 Data collection methods II
The researcher moved to the company’s head offices and generated data through
interviews, observations and use of questionnaires 11
3.1.1 Documentation 11
3.1.2 Interview 11
3.2 Research 12
3.3 Data sources 12
3.3.1 Primary source 12
3.3.2 Secondary source 12
3.4 Data processing and presentation 12
iv
3.4.lData processing .12
3.4.2 Data presentation 12
3.4.3 Research design 13
3.4.4 Sample selection 13
3.5 system requirements and analysis specification 1 3
3.5.1 User requirements 13
3.5.2 Functional requirements 14
3.5.3 Non functional requirements 14
3.5.4 System requirements 14
3.5.5 Software Requirements 15
3.5.6 Hardware Requirements 15
3.6 System design 15
3.6.1 Description of the system 15
3.7 System development life cycle (SDLC) 15
3.7.lPrototyping 16
3.7.2 Testing and verification 16
3.7.3 Specification requirements 17
3.8.lEntity and attributes 17
3.9 Entity relationship diagram 18
CHAPTER FOUR 23
IMPLEMENTATION 23
4.Olntroduction 23
4.1 System features 23
4.2. Switch board 24
4.3 Main form 24
4.4 Tables 25
4.5 Query 28
4.6. Conclusion 29
CHAPTER FIVE 30
DISCUSSION, CONCLUSIONS AND RECOMMANDATIONS 30
5.0 Introduction 30
5.1 Discussion 30
5.2Conclusion 30
Lessons learnt 30
5.3 Recommendations 3 1
REFERENCES~ 32
APPENDIX A 33
ABSTRACT This project report contains five chapters, background of the study, literature review, methodology, system study, analysis, design implementation, and conclusion and recommendations. The research was conducted in Kampala at the Serena hotel where are the main offices of the east lands agency. Most ofthe information was given by the manager. The objectives were derived form the problem statement and were used to achieve the results of the project. Literature of relevance where consulted and included in chapter two. The methods of data collection used by theresearcher were discussed and included in chapter three under the title of methodology.