Database Management - Sure Guru Holidays Case Study - IT Assignment Help

Assignment Task:

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.

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

Finance Staff

Recording payments made by customers

Checking & confirming prices

Daily, weekly and monthly sales figures

Management

Turnover

Holidaymaker preferences

Marketing

However, as this is a new system the management, who have given the initial requirements, are willing to be guided by the analyst / designer of this new system. They are also aware that they have not provided a full requirements list (particularly the non-functional requirements) and expect to provide more details.

In this scenario you will have to make assumptions about these requirements (you may want to discuss these with your tutor) and these should be detailed in your report.

The management have specifically stated that they do not need the system to record any information about their staff. The system should record that customers have made payment for their holidays but it does NOT hold payment information such as credit card numbers.

This IT Assignment has been solved by our IT 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.