Sure Guru Holidays Case Study - Package and Bespoke - IT Computer Science Assignment Help

Assignment Task :

CASE BRIEF: THE SURE GURU HOLIDAYS 

 Introduction

Sure Guru Holidays is a new travel agent starting up in the UK with one branch already open and plans to open several more across the UK. They specialise in allowing the holidaymakers to choose their flights, hotels and tours to create a tailor-made personalised holiday. Holidaymakers can book a separate flight, hotel package and any of the tours they would like to take. Sure Guru Holidays also offer package deals with pre-defined flights and hotels and these include all the tours for that particular holiday. Sure Guru Holidays differentiate between the two in their office as Package and Bespoke. Sure Guru Holidays can offer much cheaper holidays than other providers, as they do not have to organise the details of the holiday (see below).

Sure Guru Holidays requires a system that records all the details about the Customers (Holidaymakers), the Flights available, the Hotels they use (and their capacity), and the Tours that are available.

The system needs to know the following data (and can know more):

These are the key data that Sure Guru Holidays have provided and said they need, but it does not include additional entities and/or attributes that you may discover that are required. 

With the Flights, Hotels and Tours it is not Sure Guru Holidays’ responsibility to book the actual room or actual seats – that is for the Airlines, Hotels and Tour Guides to do. Therefore all Sure Guru Holidays needs to do is ensure that the airline / hotel / tour operator knows the number of guests they are expecting from each booking. They must also ensure that no hotel or flight has more guests than they have capacity for and no tour is overbooked.

All of Sure Guru Holiday’s bookings are weekly. Holidaymakers can book more than one week but they cannot book part of a week. Obviously flights must be booked to coincide with the check in and check out times.

Once a customer has confirmed their details and paid Sure Guru Holidays the company sends out an email confirmation to the customer along with E-Tickets and vouchers for the hotel and tours. Currently Sure Guru Holidays requires a private system to link all their staff to a central database. However, the manager is keen to potentially develop the system further into a public Web-based system where customers can use a portal to search for their own holiday and book it online. However initially the focus is on creating a robust and secure private system.

• The key transactions they have said they would like to include are:
• Front Office Staff
• Holiday bookings for customers (in whatever format the customer requires)
• Checking flight details
• Booking customers onto flights
• Sending information through to hotels and tour guides

This IT Computer Science Assignment has been solved by our IT Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.