Case Study (10 marks) TOURS ARE US Brothers, Richard and Allan Winston, operate Tours Are Us. The business specializes i

[answerhappygod]

Case Study (10 marks) TOURS ARE US Brothers, Richard and AllanWinston, operate Tours Are Us. The business specializes in unusualtours for adventurous people who want something different from thegeneral tourist destinations and activities. The business has beenoperating very successfully for the past three years. Growth in thesecond and third years was about 25%. Allan and Richard have beenidentifying current, manual, tour booking procedures. They wouldexpect the new database management system to allow users to operatein much the same way as they are now. In other words, they expectthe system to support user activities and tasks. Currently, when aclient comes in or phones to book a tour, the attendant firstchecks the card system to determine whether this client’s detailshave been recorded and whether these are still accurate. if this isa new client, then the following details must be recorded beforeany tour can be booked: Client’s name, address and contact number,and preferred payment method; ie cash, cheque or credit card. Oncethese details have been recorded, a tour booking can be made. Theclient must put a deposit on the tour (or pay in full) on the daythat the booking is made. Tour prices are given on a per personbasis and cover all travel, accommodation and meal expenses. Thusthe client must also indicate how many people are going on thistour. Payment for tours must be finalised 10 days before the tour’sdeparture date. Tours can have different prices depending on whattime of year they are being offered. Most of the tours are offeredmore than once a year. For each tour, information is also listedabout the city from which the tour departs and departure time. Itis up to the client to make their way to the departure location.When the booking is completed, the client is given a tour itinerarythat lists the various destinations on the tour. In addition, italso lists: • the name and rating (ie 1-5 star) of theaccommodation at each destination • the duration of stay in days ata particular destination • some of the main features at thedestination. The above is the basic information that needs to bestored in the new database management system. Richard and Allanwill hire someone to transfer the information currently stored ontheir card system to the database management system once it isoperational. They also need to be assured that the new system willhave sufficient flexibility to be extended in the future if theneed arises. References:  Fred R. McFadden, Jeffrey A. Hoffer& Marry B. Prescott 1999, Modern Database Management 5th edn,Addison-Wesley Educational Publisher, New York CHAPTER 5: EntityRelationship Diagram (ERD)
Exercise: Construct an ER model using the information in theTOURS R US case study below.
Tutorial / Laboratory Sheet
(25 marks)