The reservation page that shows the different rooms available at a certain hotel after the user click on a certain hotel. This is the last page the user finds asking him to fill in his personal details so that they can finish on the booking of the room. DATABASES Coral seas are a business that serves a wide range of tourists. Based on these facts the system is supposed to provide information on different location where tourists can tour and also collect information about these tourists. This led to a need of a database that is supposed to be accessed through the network.
This database space would be purchased from the domain provider so that it would be accessible through the internet by all clients and workers of the company. The database would require tables of client, booking, holiday types ,hotels, room and room types. The client will have the following attributes first name, last name and passport which is a primary key in the table. The client entity is a representation of the different tourists who are interested in booking of the rooms.The hotel table will contain information of the different hotels managed by the company where we shall be required to provide information about the name of the hotel its location and the id which will be used as a primary key.
The other entity is the rooms which are the different accommodations that a client can reserve when on tour. In the room entity the client is provided with the amount payable and the maximum occupants who can use the room at a certain time. The client has a one to one relationship with the booking table which carries the client-id and the room-id which are primary keys from the table client and rooms respectively. The hotels and the rooms have one to many relationships that a hotel can have many rooms but a room cannot be available in many hotels.
The relationship between the room types and the rooms is one to many because the room cannot be in two classes for example a one bedroom villa cannot be classified at the same time be two bedroom villa. The holiday type and the rooms have many to many relationships. This arises because certain room can be available in a destination that is visited as a honey moon site and also as a romantic destination. Also a holiday type can be available in different places this quantifying the many to many relationship.
The holiday type has the attributes type which is the name given to any holiday type and destination which shows where that type of holiday type can be found. The most preferred database software for use agreed upon was MySQL because of it being open source and easy to use. Database diagram for the company INTERFACE DESIGN User centered design approach The online reservation system was designed taking into consideration user centered design philosophy. This was ensured by carrying out a survey who were the main people who would be using the system and found out mostly are the tourist from all over the world and the clerks in hotels room during the confirmation of the booking of the rooms.
The knowledge of these users on efficiency of usage of computers was looked and it was found out that most of them had a basic knowledge in using computers. These users were involved in the developing of the system and gave the requirement and how the users would require the system to appear like. A prototype was developed and given to the user to use and then asked to give their feedback on the usability of the system. After the user gave their suggestions after using the prototype it was improved on including those requirements and suggestions user brought forward.
This facilitated us to draw closer to a system that would be easily acceptable by the different users. To make sure that the system met requirement and users were happy with it we used the iterative design where programmers were supposed to add components to the system as we continued developing it. Through iterative design after completion of the system something that had not been catered for in the design stage can be added.
Read More