What are the composite keys for the below. I have identified "head guide," "visits" between tours and locations, and "tour name" between tourists and outings.

.. DC Tour s offers many different tours.. For each tour,, the tour name,, approximate length,, and fee rate is needed.. There are four types of fee rates , namely:: adult,, senior,, child (aage 2 - 11)),, child - free (uunder age 2))

b.. Every tour must be designed to visit at least tw o locations.. For each location,, a name,, type,, and official description are kept.. Some locations (ssuch as the White House)) are visited by more than one tour,, while others (ssuch as Arlington Cemetery)) are visited by a single tour.. All locations are visite d by at least one tour.. The order in which the tour visits each location should be tracked as well..

c.. When a tour is actually given,, that is referred to as an oouting.. A tour can have many scheduled outings,, although newly designed tours may not have any outings scheduled.. Each outing is for a single tour and is scheduled for a particular date and time.. All outings must be associated with a tour.. All tours at DC Tours are guided tours,, so a guide must be assigned to each outing.. Each outing has one an d only one guide..

d.. Guides are identified by an employee ID,, but the system should also record a guides name,, home address,, and date of hire , and contact number . Few experienced guides are identified as head guides.. A head guide may manage several guides,, and each guide is managed by one he ad guide..

e.. Tour ists pay to join a scheduled outing.. For each tourist , the name and telephone number are recorded.. Tourists may sign up to join many different outings,, and each outing ca n have many tourists . Information is kept only on tourists who have signed up for at least one outing,, although newly scheduled outings may not have any tourists signed up yet..