Hotelrez Online Web Booking Engine

Project Supervisor: | | Project Submission Date: | 15/06/2012 | Module Code: | | Department: | Management Information Technology | |

IT Project | HotelRez: Online Web Booking Engine |

Table of Contents Title: Online CRS (Central Reservation System) with Web Booking Engine 4 Background 4 Business Overview 4 Problem Statement/ Project Rationale 5 Aims & Goals 5 Objectives 5 Proposed System 6 Online Booking Module: 7  Sub-Module: New Reservations 7  Sub-Module: Confirmation 8 Back Office Module: 8  Sub-Module: Settings 8  Sub-Module: Inventory Management 8  Sub-Module: Reservations 8  Sub-Module: Reports 8 Technology Description 9 Technologies: 9  PHP5 (Version 5.3.5) 9  MySQL (version 5.5.8) 9  HTML 5 & CSS2 & CSS3 9  JavaScript 9  JQuery 1.6.2 with Ajax 9 Software Tools 10 Integrated development Environment (IDE) 10 Image Editing Software 10 Server Software 10 Word Processing, Analytical, and Planning Tools 10 Other Support Tools 10 Resource Audit 10 System Development Methodology 11 Waterfall Model 11 ER Diagram 12 Flowchart Login(Backoffice) 13 MySQL Tables Structure 14 Stored Procedures 15 To fetch Availability 15 To Fetch the Inventory 16 To activate room Inventory from Php 17 To modify Inventory calendar from Php 18 Triggers 19 ‘tbl_year_default on insert to insert into inventory calendar 19 ‘tbl_year_default on update to update into inventory calendar 21 ‘tbl_room_detail ’ after insert to update availability in real time 23 MySql Views 25 To be used in a stored procedure to assist the queries 25 Screen Captures 27

Title: Online CRS (Central Reservation System) with Web Booking Engine
Background
There are just over 46,000 hotels and Bed & Breakfast in the UK, and the hotel industry remains a significant sector of the economy, small size and budget hotels represents 38% of the total stock of the hotels in the