A Web-Based System for Hotel Reservation in Kenyan Hotels Case Study: White sands Hotel- Mombasa

TABLE OF CONTENTS

DECLARATION .............................................................................................. i

APPROVAL .................................................................................................... ii

DEDICATION ............................................................................................... iii

ACKNOWLEDGEMENT .............................................................................. iv

TABLE OF CONTENTS ................................................................................ v

ABSTRACT ................................................................................................. viii

ABBREVIATI 0 NS ........................................................................................ .ix

LIST OF FIGURES ......................................................................................... x

LIST OF TABLES .......................................................................................... xi

Chapter One: INTRODUCTION .................................................................. 1

1.1 Background of the case study ................................................................ !

1.2 Statement of the problem ....................................................................... 2

1.3 Objectives of the study ....................................................................... 3

1.3.1 General objective .................................................................................................... 3

1.3.2 Specific objectives .................................................................................................. .3

1.4 Scope of the project. ............................................................................... 3

1.5 Significance of the project ..................................................................... .4

Chapter Two: LITERATURE REVIEW ....................................................... 5

Introduction .................................................................................................. 5

2.0 Web based System ..................................................................................................... 5

2.1 Worldng of Web based systems ................................................................................ 7

2.3 Types of web based System ....................................................................................... 9

2.4Application areas of Web based Hotel reservation System ................. l 0

v

2.4.1 Other areas of application ................................................................................... !!

2.6 Development methodology in web based System ................................ 13

2.6.1 System Development Life Cycle (SDLC) ............................................................ l3

2.6.2 Prototyping .......................................................................................................... IS

2.6.3 JAD (Joint Application Development) ................................................................ IS

Chapter Three: METHODOLOGY ............................................................. 16

3.0 Introduction .......................................................................................... 16

3.1 Data identification ................................................................................ 16

3.1.1 Document Analysis ........................................................................................ !?

3.1.2 Observation .................................................................................................... !?

3.1.3 Questionnaire ................................................................................................. !?

3.1.4 Interviews ....................................................................................................... 19

3.2 System Design ....................................................................................... 20

3.3 System Implementation ........................................................................ 21

Coding: ............................................................................................................................ 21

Testing: ........................................................................................................................... 21

Debugging: ...................................................................................................................... 22

3.4 System Validation ................................................................................. 22

Chapter Four: SYSTEM DESIGN ............................................................... 23

4.0 Introduction .......................................................................................... 23

4.1 System design ........................................................................................ 23

4.1.1 Logical design ........................................................................................................ 23

4.1.2 Physical Design ..................................................................................................... 28

4.3 The current system ............................................................................... 30

4.4 Proposed System ................................................................................... 30

4.5 Requirements of the proposed system ................................................. 31

Hardware requirements ................................................................................................ 31

Software requirements .................................................................................................. 32

4.6 Benefits of the Proposed System .......................................................... 32

VI

Chapter Five: SYSTEM IMPLEMENTATION .......................................... 33

5.0 Introduction ........................................................................................ 33

5.1 System testing ....................................................................................... 33

5.2 System Implementation ........................................................................ 34

5.3 User Interface ....................................................................................... 35

5.4 System Conversion ............................................................................... 39

5.5 Parallel Strategy ................................................................................... 39

Chapter Six: DISCUSSION, CONCLUSION AND

RECOMMENDATIONS ............................................................................... 40

Introduction ................................................................................................ 40

6.1 Discussion ......................................................................................... 40

6.2 Conclusion ....................................................................................... .40

6.3 Recommendation .............................................................................. 41

6.3.1Areas of further research ..................................................................................... .42

BIBLIOGRAPHY .......................................................................................... 43

APPEND IX 1 ................................................................................................. 45

Questionnaire ............................................................................................. 45

APPENDIX 2 ................................................................................................. 47

Sample Codes ............................................................................................ .47

ABSTRACT Due to congestion of customers in booking one to one at the Whitesands Hotels premises, the Web Based Hotel Reservation System for WhiteSands Hotels-Mombasa is developed to handle the Hotel booking procedure better than one to one booking, which is limited to most users from a far. The website is designed using PHP by connecting to the Hotel database using MySQL making it to be a dynamic site. Whitesands Hotel is found in Mombasa, along the Kenyan coast. This web based project provides a user interface form for online booking; it also provides information about the Hotel and the services it offers. This Hotel reservation is aimed at improving customer satisfaction, boosting sales and reduces costs by handling more transactions at a less time so that the processes being carried out by the administrators can keep pace with the economy in the World. To compete in the current business environment, management needs to cut down their distribution costs and adopt this system. However, Whitesands Hotel has been relatively slow in adapting this due to the current preference of using filebased room reservation system by the hoteliers. Based on the literature review of the Internet users, adopting online reservation, online "bookers" would look for fast, reliable and convenient system. Price, time and security are key motivators to book online. The findings are impmiant in encouraging more hoteliers to adopt and implement online hotel reservations as pmi of their main sales mechanism.