A Computerized System For Hotel Management Case Study: Imagi Hill Hotel In Dodoma Tanzania

ABSTRACT This project aimed at computerizing a hotel system; a system to aid in the management and operation of the reception office. Automated systems which are not carefully designed basing on good security practices may lead to data loss, misplacement, inconsistencies and redundancies. Methods that were used to gather information about the current system include; interviews and observation. It gives a detailed review of the selected methods, instruments of data analysis and presentations that were used when analyzing and evaluating the current system of the hotel. The methods applied attempted to establish and analyze the status of the problem, appraising it effectiveness where problems existed, to try and find solutions. The study was carried out at linagi Hill hotel as a case study. The system is designed with user friendly interface that will ensure ease of use and avoid errors and other shortfalls that arise with the classic file system. This system will only run on Microsoft Visual basic program. The literature review elaborates and gives a detailed perspective of computerized management systems and databases as viewed by different authors and researchers.

TABLE OF CONTENTS

DECLARATION i

APPROVAL ii

DEDICATION iii

ACKNOWLEDGEMENT iv

TABLE OF CONTENTS v

SYNONYMS viii

LIST OF FIGURES ix

LIST OF TABLES x

ABSTRACT xi

CHAPTER ONE 1

1.1 GENERAL INTRODUCTION 1

1.2 BACKGROUND OF THE STUDY 1

1.3 STATEMENT OF THE PROBLEM 2

1.4 OBJECTIVE OF THE STUDY 2

1.4.1 Main objective 2

1.4.2 Specific objectives 2

1.5 SCOPE OFTHE STUDY 3

1.6 SIGNIFICANCE OF THE STUDY 3

CHAPTER TWO 4

LITERATURE REVIEW 4

2.1 INTRODUCTION 4

2.2 SCOPE OF LITERATURE REVIEW 4

2.3 PROBLEM AREA 5

2.4 APPLICATION AREA 5

2.5 DATA COLLECTION TECHNIQUES 6

2.5.1 Interview 6

2.5.2 Observation 7

2.6 DEVELOPMENT TECHNOLOGIES 8

2.7 DATABASE MANAGEMENT SYSTEM 9

2.8 THE EFFECTS OF DATABASES AND DBMS 10

2.9 DBMS FEATURES AND CAPABILITIES 10

2.10 ADVANTAGES OF USING DATABASE AND DBMS 12 2.11 DISADVANTAGES OF USING DATABASE AND DBMS 13 2.12 DATABASE MAINTENANCE 14 CHAPTER THREE 15 METHODOLOGY 15 3.1 INTRODUCTION 15 3.2 STUDY DESIGN 15 3.3 ORGANIZATIONAL UNIT STUDIED 16 3.4 STUDY POPULATION 16 3.5 SAMPLE SIZE 16 3.6 RESEARCH INSTRUMENTS 17 3.6.1 Interview 17 3.6.2 Observation 17 3.7 DESIGN TECHNIQUES AND TOOLS 18 3.8 METHODOLOGY FOR DEVELOPMENT OF SYSTEM 18 3.9 DEVELOPMENT TOOLS FOR THE SYSTEM 21 3.9.1 Operating System 21 3.9.2 Programming Language(s) and Tools 22 3.9.3 Database Management Systems 23 CHAPTER FOUR 24 SYSTEM DESIGN AND IMPLEMENTATION 24 4.1 INTRODUCTION 24 4.2 DATA AND DOCUMENTS FLOW 24 4.2.1 Data Flow Diagram (DFD) 24 4.3 REQUIREMENT ANALYSIS AND DEFINITION 26 4.3.1 Hardware and Software Requirements 26 4.3.2 Functions and Constraints of Computer based 27 4.3.3 User and Security Requirements 28 4.4 SYSTEM AND SOFTWARE DESIGN 28 vi 4.4.1 Logical design .29 4.5 IMPLEMENTATION 41 4.5.1 System Testing and Validation 41 4.5.2 Operation and maintenance 42 4.6 EXECUTION SEQUENCE 43 4.7 PRESENTATION OF THE SYSTEM 44 4.8 REPORTS 56 4.8.1 CustomerReport 56 4.8.2 Employee Report 57 4.9 INFORMATION SYSTEMS PLAN 58 4.9.1 System Request 58 4.9.2 Risk assessment 59 4.10 LIMITATIONS TO THE STUDY 60 CHAPTER FIVE 61 DISCUSSION, RECOMENDATIONS and CONCLUSION 61 5.1 INTRODUCTION 61 5.2 DISCUSSION 61 5.3 RECOMMENDATIONS 62 5.4 CONCLUSION 62 REFERENCES 63 APPENDICES 64 Appendix 1—Sample Interview guiding questions 64 Appendix 2 - System Codes 65 Appendix 2- Budget 72 USER MANUAL 73