Design And Development Of Online Hotel Booking System Using Multi-tier Architecture

This project deals with the design and development of an online hotel booking system with the particular attention to institute an online reservation system at the Hilton Addis hotel, Ethiopia, using an efficient multi-tier architecture for successful functioning of Hilton Addis hotel.Multi-tier architecture is reviewed and justification for designing the project with multi-tier architecture is highlighted. Multi-tier implies adding extra logical layer in the middle of client-server architecture. Multi-tier means a system with at least three-tier logical layers. The three tiers refer to the three logical component parts of an application, other than the number of machines used by the application. By breaking up the application into three tiers, enterprise application and web application are using the same components. The overall goal of using multi-tier application is to enhance application performance, makes the system more reliable, easy to maintain, improves the network traffic and keeps data secured.The user service for the Hilton Addis hotel Web site enables a customer to enter reservation information. The user services are implemented through the user's Web browser with HTML files and Active Server Pages (ASP) files. These files contain inline scripts that executes on the client or the server.The business services for the Hilton Addis hotel Web site implement business logic when a reservation is added or verified. A typical example of this business logic is a business service that verifies room availability before adding a new reservation. Server-based COM components installed on the Web server provide the business services for the Hilton Addis hotel.The data services for the Hilton Addis hotel Web site perform the actual update of the Hilton Addis hotel database, based on commands issued by components of the business services. Microsoft SQL server provides the data services for the given system. The database is installed on the Hilton Addis hotel Web server but it can also be installed on a separate server computer.An Entity Relationship (E-R) model is designed and implemented successfully. It expresses the overall logical structure of a database graphically. It is based on a perception of a real database design that consists of basic objects called entities and of relationships among the objects. An entity may be concrete like a person, a book or an This project deals with the design and development of an online hotel booking system with the particular attention to institute an online reservation system at the Hilton Addis hotel, Ethiopia, using an efficient client-server multi-tier architecture for successful functioning of Hilton Addis hotel.Even though, Hilton Addis hotel makes advertise their services through the Internet, the potential had not been exploited. The project work covers the implementation of online reservation facilities where customers can make reservation to the given hotel via the World Wide Web sites. The anticipated outcome includes increased business returns and efficient customer service and satisfaction.The project is designed by using Microsoft Visual Basic and Visual InterDev for the desktop application and Microsoft SQL Server is used as the back-end database server, HTML with Active Server Pages and VBScript for the web application. The system enables prospective guests to book different types of rooms online, keeps the database on guests, tracks when the guests check in or check out, issue voucher at the time of checking out.Hilton Addis hotel system will automatically calculate the total room charge for each reservation and prevent double booking, i.e. the system doesn't allow more than one reservation for the same dates on the same room simultaneously and every booking done by online generates booking confirmation e-mail message, which is mostly written and automatically delivered to guests by their respective e-mail address. If you didn't receive confirmation e-mail, one of the things might have happened:1. Your e-mail address is listed in the system inc...