A Web Based System For Hotel Reservation Case Study: Hotel La Vista

TABLE OF CONTENTS DECLARATION ii APPROVAL DEDICATION iv ACKNOWLEDGEMENT v TABLE OF CONTENTS LIST OF FIGUERS LIST OF TABLES ix CHAPTER ONE 1 INTRODUCTION 1 1.1 Background ofthe Study 1.2 Problem Statement 3 1.3 Objectives ofthe Study 3 1.3.1 Geneni objective 3 1.3.2 Specific Objectives 3 1.4 Scope of the project 3 1.5 Significance ofthe Study 4 CHAPTER TWO s LITERATURE REVIEW s Introduction 5 2.1 Online hotel reservation s 2.2 Websites 6 2.2.1 Types of web site applications 7 2.3 Benefits and limitation of current systems for Hotel reservation 8 2.3.1 Manual system 8 2.3.2 A web based system 8 2.4 web site development tools 9 2.4.1 Adobe dream weaver 9 2.4.2 PHP 10 2.4.3 MYSQL 10 2.4 Conclusion 11 CHAPTER Tffl{EE 12 METHODOLOGY 12 3.1 identification of requirements for building the web based system 12 3.5 System Requirements 16 3.5.1 Functional requirements 16 vi 3.2.2 Non flinctional requirements ~ 3.3 conclusions 17 CHAPTER FOUR 18 SYSTEM ANALYSIS AND DESIGN 18 4.1 System Analysis 18 4.2.lConceptual design 21 Fig4. Database Architecture 21 4.2.2 Logical design 22 CHAPTER FIVE: SYSTEM TESTING IMPLEMENTATION AND EVALUTION 25 Introduction 25 Having finished the system design, we went on system testing, implementation and evaluation in which we did an overview ofthe entire system. It combines all concepts that lead to the development ofthe program code 25 5.4 Staffing involved in testing 26 5.5 The developed system 27 CHAPTER SIX 37 DISCUSSION, RECOMMENDATIONSAND CONCLUSION 37 6.1 Discussion 37 6.2 Conclusion 37 6.3 Recommendations 38 6.3.1 Areas of further research 38 References 39 APPENDEX I 40 Appendix II 42 vii LIST OF FIGUERS 1. Figure 1: Design ofthe web based system 15 2. Figure 2: Methodology Development life cycle 16 3. Figure 3: System analysis 20 4. Figure 4: Data Base Architecture 22 5. Figure 5: Data Flow Diagram 25 6. Figure 6: Developed system 28 7. Figure 7: Booking Form 29 8. Figure 8: Reservation Form 30 9. Figure 9: An Invoice for Reservation 31 10. Figure 10: Administration Login Form 32 11. Figure 11: Data Base Record 33 12. Figure 12: Services Offered in the hotel 34 13. Figure 13: Contacts for the hotel and location 35 14. Figure 14: Detailed in formation required 36 15. Figure 15: Record in the Database 37 viii LIST OF TABLES 1. Table 1: Administrator Login form 24 2. Table 2: Booking table 24 ix

CHAPTER ONE INTRODUCTION

1.1 Background of the Study In today’s economy, efficiency and agility of doing business is a key for an organization’s survival. The www, with it ease of use, and global acceptance even by the relatively computer illiterate makes it an ideal to make a web based system for doing the business online reservation or booking that covers the whole world. While a web based hotel reservation and booking at various convenient locations in most major cities of coverage for presence every potential customers. Hotel reservation system is sometimes referred to, in a restrictive sense, as information technology management. The study of reservation system is usually business administration discipline. It concentrates on the integration of the aims of the organization. According to Hutchinson (2000) [3], reservations are designed to offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables and forms.