Database Answers United Nations Tour Guides, 2007 (Click for larger picture)

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Tour Guides
Back to the Data Model
Here is the Statement of User Requirements
An email from Steve Riddiough. Member #1234 defines the Requirements in the follwoing terms.
The Data Model I require needs to cover -
  • Guides and expertise
  • Agency clients and clients’ customers
  • Tour Bookings, durations and guide diary
  • Locations Detailed info - A tourist guide agency requires a database to manage its guides. A guide is a person with detailed knowledge of sites of interest and provides navigation and added value to groups of people visiting those sites. The agency has many guides that can be hired by various tourism, leisure, heritage and conservation organisations, e.g. travel agencies, hotels, museums, heritage site management companies, wildlife organisations. The guides are contracted by the agency (not employed) to provide guidance and knowledge to customers of hiring organisations at specific sites on specific dates and times. For example, a company may ask the agency to provide a guide to an art gallery during a social event organised in Athens for some prospective customers of the company who are visiting the city to inspect the company manufacturing facilities. The agency keeps records of the knowledge and levels of expertise of the guides it uses. This information is required in the database. For example- Tour guide John Smith is an expert on World War Two military operations on the island of Crete. He has a Ph.D. in modern history. He is contracted on a regular basis by the guide agency to provide guided tours to sites of military history on the island. In the past the agency has booked him to provide tours for travel companies that have package holidays to Crete, private companies providing corporate entertainment to their clients, and private individuals organising their own holidays on the island. A tour at a location can involve a number of different customers/customer groups.(customers of the organisations requesting guides) The ‘guides’ may themselves be agencies. For example, an agency called ‘Gallipo-History’ provides expert tour guides for the First World War sites in Gallipoli. The agency described in this scenario books tours from guides employed by ‘Gallipo-History’. Contact details for those guides will be the contact details of ‘Gallipo-History’. The agency uses guides from a number of these other agencies. The database should hold data on Tour guides (contact details and list of other employers-guides may have several occupations apart from working for the agency). Guides have identifiers that have the form ‘a12-003-2008’ where a12 identifies the agency (a00 indicating not from another agency i.e. operating as an individual guide), 003 identifies the guide, and 2008 the year the guide commenced providing services. The knowledge and expertise of the guides (subjects and indication of depth of expertise e.g. amateur historian, professor of history, scholar, professional biologist, etc..) . Customers of the agency i.e. the organisation or individual hiring the guide (contact details, and type of customer e.g.private individual, company, charity etc.) Locations covered by the guides (site name, nearest town/city), the duration of tours (hours and fractions of hours), and subject title e.g.’Roman versus Greek Classical Architecture’, ‘Development of Perspective in Renaissance painting’, ’Basic seashore ecology’, ‘Early Victorian railways’. A diary of activities of the guides (past, present and future), including date/time of appointment, location, title of tour or event, customer. No data on costs or payments is required. Customers of the agency are of different types e.g. private individual, company, charity etc. From these Requirements we can identify the 'Things of Interest' as :- 1. Agencies 2. Guides 3. Qualifications 4. Tourist Atractions 5. Tours

  • Barry Williams
    24th. January 2009
    Principal Consultant
    Database Answers


    Home Ask a Question Careers Contact us Data Models First Timers Search Site Map