CSE2DBF/CSE4DBF : Getaway Holidays Reservation Database System : Case Study - IT Assignment

Internal Code : MAS288

IT Assignment

Case Study : Getaway Holidays Reservation Database System Getaway Holiday Destination is a family owned holiday resort specially designed for group visits or couples retreat. The business was established in 1990’s by an Australian adventurist and travel enthusiast Mr. Edward Green. The Green family has been taking care of the business ever since. They have a dedication and passion towards what they have to offer to their guests and in order to do that, each and every member of the family work towards the maintenance and continuing improvement of the establishment. The business is mainly aimed at the concept of providing the guests with actual adventures along with a great experience of a family getaway. The resort is situated in the middle of a huge land with natural diversities. It has a great country-side river and some gorgeous hills, not very far from the city of Melbourne. The guests of the resort register with the business in order to put their reservation ahead of time as the demand is always high during the holiday seasons. As the registration and reservation process is maintained in paper-based format till date, the customers have to physically come down to the location and fill up a Client Registration Form provided in Appendix-A. As it can be seen from the registration form, the basic information about a client is kept on record so that they do not have to register again for any future trip they wish to book with the resort. As the resort provides different indoor and outdoor activities for the duration of the stay, they are also concerned about the physical fitness of their clients. Any condition that a client may have can restrict the client from booking a trip with some of the activities. For example, a person with Acrophobia (the fear of height) should not be allowed to book a trip that contains mountaineering outdoor activity. The registered clients are targeted and sent different package offers and brochures highlighting the activities that the resort facilitates. A sample brochure is provided in Appendix-C for outdoor activities and a similar brochure for indoor activities is provided in Appendix-D. After being registered, a client can book a package trip with his/her friends and family by completing the Client Reservation Form (Appendix-B). All the information in the form helps the resort to plan and execute a perfect holiday trip for their individual clients. The preferences of the clients are the first priority to them. Some of the questions that need to be answered in this form include what kind of accommodation they are looking for, how many guests they will be bringing along, what are the indoor and outdoor activities they will be looking forward to. This information will help the resort officials to make a decision and plan an entire trip. Information about the activities are kept in the records as well. These include the name of the activity, their description, risk level and cost per day. Also, there are some information which are specific for indoor activities which are mentioned in the brochure. It is to be mentioned that the activities in the brochure in appendix C and D are sample set of activities only. The resort offers a much bigger range of activities to the clients. The business is growing day by day and the family is facing difficulty keeping record of all this information in physical files. So, Mr. Green has decided to migrate all the kept information into a Database management system so that online form submission facilities can be provided to the clients. Question : You are required to develop an EER model for the above problem description. The EER should contain all necessary information such as entities, attributes, primary keys, relationships (including specialization/generalization if any), cardinalities, and participation (including (min, max)). All specialization/generalization and union type must be represented accordingly, instead being treated as simple association relationships. Any assumptions should also be stated clearly. If assumptions are made, it is important to make sure that the assumptions reflect possible real practice for a tourism industry and do not contradict with the problem description above.