Jun 19th, 2014 at 03:58 PM

Practical project proposal for HOTEL RESERVATION SYSTEM ,Round-20, IDB-BISEW

Project Consultant WPSI, Round-20, IDB-BISEW IDB Bhaban, Sher-e-Bangla Nagar, Dhaka Proposal for the project of “Hotel Reservation System” 21-Jun-14 Dear Project Consultant, Thank you for offering me an opportunity to make a real life project based on my core subject that is WPSI (Web Presence Solution and Implementation). In this respect, I would like to inform you that I have set a wish to make a project on HOTEL RESERVATION SYSTEM. I have studied about the various aspects of this system and make a proposal accordingly which is enclosed herewith for your kind perusal. May I, therefore, pray and hope that you will consider my proposal sympathetically and allow me to make a project on my proposed topic. Yours Sincerely, Mir Samsuzzoha ID: 1163251 Batch ID: ID-WPSI/APCL-01/R20/01 #Objective: THE HOTEL RESERVATION SYSTEM will provide service to on-line customer, employee, and an administration. Online customers can make searches, reservations and cancel an existing reservation on the hotel reservation’s web site. Administrator can add/update the hotel and the room information approve/disapprove a new employee account application and generate a monthly occupant’s rate report for each hotel. #Table of Contents Background Overview of Hotel Reservation System Features of the HRS Phases for Project Development Problem Analysis Feasibility Study Project Analysis Project Design Project Coding Testing Code #Background The process of booking hostels is a frequent and important activity in any tourist area. But the process becomes very tiresome and time consuming when there is no proper and convenient system. To deal with this problem, online booking system will be very necessary. Online booking system is accessed on internet by using devices which have internet connection at any time. Online hotel reservation system is a convenient and an efficient way to deal with this problem. The residential online system will enable people access details of available hotels on online and also do the booking in online. The system will have all the necessary information about hotels on website which accessible by anyone who wants to book. As Bangladesh is a growing tourist destination, there has been a good rise in the number of hotels and resorts in our different tourist location and the tourist sector is broadening thus I like to choose this sector to do project as Online Hotel Reservation System. #Overview of Hotel Reservation System Hotel Reservation System has all the dynamic versatile features required to run hotels, motels and guest house business. Hotel Reservation System offers an operational integration between reservations, guest history, reception/ front desk, Sales Ledger, Accounting and Reporting modules. Software has facility to generate report for analyzes your booking, checking and checkout status. Hotel Reservation System is the best suit for managing you resource in very simple but effective manner with minimal efforts or time so that it increases your revenue. Hotel Reservation System helps you to manage small to medium size boutique, hotels, Inns, cottages, Bed, campgrounds and cabins and Breakfasts. Hotel management or booking system is design to help you manage your booking and use the gathered data in reports to help analyze your marketing and financial results. Hotel Booking software is a complete software suite consisting of integrated modules for various aspects of hotel management. #Main Features Save the client’s information into the database prior to Booking or Check in. Customize the type of Hotel rooms with prices. Booking for the customer for specific date with advance payment. Check in into the hotel for the duration. Checkout from the hotel after payment operation. Each time make a reservation, room status is updated and the customer details are added to your hotel database. Better option for expensive CRM. This system can be used by all of the hotels. This project is web-based and is using PHP and MySQL with other web technology. #Following sites are providing the online hotel booking system www.reservation.com.bd www.bangladeshhotelbooking.net www.bdtravelhomes.net www.bangladeshhotelbooking.net www.tourtravelworld.com www.radissonblu.com/hotel-dhaka #Phases for Project Development Problem Analysis In Bangladesh there are more than 500 hotels which are gaining their international customers but online booking system is implemented by some renowned hotels only so the hotel reservation system is one of the projects that will be required in the Bangladeshi tourist sector so I have chosen it. Google Maps are also not in use and I am implementing it which will help the customer to find out the location of hotel. Customer Relationship Management is also established and I am maintaining it which will help to find out customer repository. Feasibility Study There are many problems with the existing hotel reservation system in Bangladesh and the problems are stated in the problem analysis. It is economically feasible as I am making this for the partial fulfillment of the BCIS program and is operationally feasible as I am making this system by removing the threats and weaknesses of existing systems as well as it is technologically feasible as I am using open source coding with the use of PHP and MySQL. Project Analysis In Project Analysis we collect data from different documents, manual and sites for the collection of the data we have interviewed different online booking uses as well as the owners of the hotel. #Project Design Account Manager ⱷ Administrators – Administrator can add / edit and manage administrator accounts. Hotels Manager ⱷ Hotels – Administrator can manage hotels that will appear on the site with the hotel name, description, address, phone and fax. ⱷ Room Types – Administrator can define the type of rooms in the hotels, rooms’ prices and upload an image for each room. ⱷ Hotel Rooms – For each hotel the administrator can define the rooms available, room’s number, max occupants and remarks on the specific room. Bookings Manager ⱷ Bookings – All bookings and reservations maid on the site are displayed with all booking details: arrival date, departure date, hotel name, room type, number of passengers, price… ⱷ Available Rooms – Administrator can also search for room availability from the administrator’s panel and does not have to go on the site in order to look for hotels. ⱷ Bookings History – Administrators can view all bookings ever made on the site. Reports ⱷ Bookings Statistics – Administrator can view statistics of booking on bar charts that show the difference in bookings according to months. Options ⱷ Languages – Define the languages that will be viewed on the site with the language code. ⱷ Constants – For each language the administrator can define the wording. #General ⱷ Panel Settings – Here the administrator can define the basic site name and header. ⱷ Menu Manager – Here the site administrator can rearrange the menu bar with the sub pages of the administrator panel. ⱷ Site Settings – Here the administrator can define if to use pay pal on the site and if yes then what will be the pay-pal email address used, the administrator can also define the administrator email address where all reservation emails will be sent to. ⱷ Static Pages – Here the administrator can edit the content of the static pages on the site for each language: Area Information Page, Rooms Page… Project Coding With the use of programming languages the system design is implemented to make the HRS Project Testing The code that we will use will be tested and errors are debugged #Milestones Although it’s not possible to calculate the exact time for the development of the project, I have made an approximate time-line for the development of my project and it is as follows:

Stages of development	Starting Date	Ending Date	Duration in days
Initial Study	21-06-2014	10-07-2014	20 days
Feasibility Study	11-07-2014	25-07-2014	15 days
Requirement Analysis	26-07-2014	09-08-2014	15 days
Requirement Specification	10-08-2014	19-08-2014	10 days
Interface Design	20-08-2014	29-08-2014	10 days
Coding	30-08-2014	08-09-2014	10 days
Testing and Debugging	09-09-2014	13-09-2014	5 days
Implementation	14-09-2014	18-09-2014	5 days
Total	90 days

#Tools and Technology *PREPROCESS HYPERTEXT (PHP) is main language in this project. Others are as needed PHP Database (MySQL) Jquery JavaScript CSS HTML Photoshop Flash UML System Specification *Minimum Hardware Specification Minimum HDD space needs at least 80GB for the project. Additional Space for temporary files during installation and running RAM DDR 1GB. DVD RW Optical Drive. Pen drive. Any other needed devise. Display device *Software Specification Windows 2000 Server Operating System(Windows XP) or Higher XAMPP server or WAMP server Dreamweaver , Adobe Flash #Methodology Guidance Hotel reservation system of other sites Knowledge about the other reservation system and tourism sector. Basic knowledge about Search Engine Optimization and other marketing strategies. How PayPal Transactions works or the implementation of sandbox. Knowledge about the HTML, CSS, PHP, MySQL, JavaScript, Ajax, Jquery and Flash. Knowledge about Object Oriented Programming specified as UML Embedded code generation. #Limitations Periodically Changing the Hotel E-business Strategies Hardware and Software errors may occur. Hacking and cracking may occurs. Credit card scams may occur. #About

Student/Project Developer	Project Coordinator Project Supervisor
Mir Samsuzzoha Student ID: 1163251 Batch ID: ID-WPSI/APCL-01/R20/01	Md. Towhidul Islam Asia Pacific Communication ltd. Keari Plaza (4th Floor),H#83,R#8/A(Old-15), Satmasjid Road, Dhanmondi, Dhaka-1209 Bangladesh.