Managing Business Information

The Case Study

_x000D_
_x000D_
_x000D_
Fly Guys is a company that operates flights to and from the cities of Aberdeen, Birmingham and Cardiff._x000D_
_x000D_
Fly Guys have only one plane. This plane has eighty seats. Each day the plane goes on one journey with two stops. On Monday, Wednesdays and Fridays they take off from Aberdeen, stop at Birmingham and finish at Cardiff. On Tuesdays, Thursdays and Saturdays they fly back from Cardiff, stop at Birmingham and finish the journey at Aberdeen._x000D_
_x000D_
Passengers can book a flight for any part of the journey (e.g. just from Aberdeen to Birmingham) or for the complete journey (from Aberdeen to Cardiff via Birmingham). They may choose to book a return flight which would involve them returning the following day when the plane comes back._x000D_
_x000D_
_x000D_
_x000D_
When a passenger books a flight they are given a booking number. This booking number is used when they check-in for their flight._x000D_
_x000D_
Fly Guys have recently introduced a rewards scheme for their loyal customers. If a passenger completed 5 full journeys (e.g. from Aberdeen all the way to Cardiff) or 10 partial journeys (e.g. Birmingham to Cardiff or Aberdeen to Birmingham) they are entitled to get their next flight at half price._x000D_
_x000D_
If a passenger books a return flight at the same time as their outbound journey the whole booking is charged at 75% of the regular price._x000D_
_x000D_
The prices of journeys are as follows:_x000D_
_x000D_
Aberdeen -> Birmingham – £50_x000D_
_x000D_
Birmingham -> Cardiff – £60_x000D_
_x000D_
Aberdeen -> Birmingham -> Cardiff (i.e. the whole journey) – £110_x000D_
_x000D_
(The same pricing is applied in the opposite direction)._x000D_
_x000D_
The CEO of Fly Guys would like you to use the applications available in Microsoft Office to design a system which will allow him to_x000D_

    _x000D_

  • Keep details of passengers

    • _x000D_

  • Keep details of all bookings made by passengers

    • _x000D_

  • Calculate the price of a passenger’s ticket based on departure point and destination_x000D_
      _x000D_

    • This should include any discount due as a result of the Frequent Flyer scheme or because a return journey has been booked

      • _x000D_

    _x000D_

    • _x000D_

  • Keep details of all passengers booked on a given flight

    • _x000D_

_x000D_
_x000D_
_x000D_
The CEO would also like to be able to produce reports detailing:_x000D_

    _x000D_

  • The number of bookings for each part of the journey

    • _x000D_

  • The amount of revenue generated for each leg of the flight schedule

    • _x000D_

  • An up-to-date list of the number of bookings for each day of the working week (Monday-Saturday)

    • _x000D_

_x000D_
_x000D_

Part 1

_x000D_
Using the case study of Fly Guys, evaluate which aspects of their operation might best be managed using a spreadsheet (Excel) and which would be more suited to a database (Access). Justify your assertions by drawing comparisons between the activities and lectures you have done in class to support your recommendations. This part should be presented as a written report. (20 marks)_x000D_

Part 2

_x000D_
Using Access and/or Excel, design solution(s) to implement your recommendations from Part 1. You will be assessed on the quality of your solution. Marks will be awarded based on whether you have used all the techniques and functions of the Access and Excel applications that have been taught. Further marks are available for going beyond the workshop activities and undertaking independent research to use further features of the applications. (40 marks)_x000D_

Part 3

_x000D_
Evaluate how successful your solution has been at fulfilling the requirements of the CEO of Fly Guys. Make reference to the basic operations of the organisation and discuss whether or not your solution is able to achieve the desired outcomes of the CEO. Conclude with a final recommendation on the business use of spreadsheets and databases. This part should be presented as a written report. (20 marks)_x000D_

Presentation

_x000D_
You will also be assessed on the structure of the written components and the quality of the writing. Your written reports should be in clear and concise English and should follow a logical structure. This includes use of appropriate headings and if necessary subheadings. Use appropriate sources to back up your points and use correct referencing techniques. (20 marks)_x000D_
_x000D_
_x000D_
_x000D_
For a custom paper on the above topic, place your order now!_x000D_
_x000D_
What We Offer:_x000D_
_x000D_
• On-time delivery guarantee_x000D_
_x000D_
• PhD-level writers_x000D_
_x000D_
• Automatic plagiarism check_x000D_
_x000D_
• 100% money-back guarantee_x000D_
_x000D_
• 100% Privacy and Confidentiality_x000D_
_x000D_
• High Quality custom-written paper_x000D_
_x000D_
_x000D_
_x000D_
_x000D_
_x000D_
_x000D_