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
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
The agency keeps records of the knowledge and levels of expertise of the guides it uses.
This information is required in the database.
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
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
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 :-
4. Tourist Atractions
24th. January 2009