(Solved): Read the Colonial Adventure Tours Case in DMC Chap 1 (from Page 16 to Page 21) or the PDF file on my ...

Read the Colonial Adventure Tours Case in DMC Chap 1 (from Page 16 to Page 21) or the PDF
file on myCourses. There are five relations in this case (Guide, Trip, Customer, Reservation, and
TripGuides).

a. Identify the primary key of each relation.
b. Identify the foreign keys of each relation. (if any)
c. Indicate any instances in which a foreign key serves as part of the primary key of the
relation in which it is a foreign key (if any). Why does each of those relations require a
multi-attribute primary key?
d. Identify the relations (tables) that support many-to-many relationships (if any), the
primary keys of those relations (tables).

Customer \begin{tabular}{|l|} \hline CustomerNum \\ \hline LastName \\ FirstName \\ Address \\ City \\ State \\ PostalCode \\ Phone \\ \hline \end{tabular} Trip \begin{tabular}{|l|} \hline TripID \\ \hline TripName \\ StartLocation \\ State \\ Distance \\ MaxGrpSize \\ Type \\ Season \\ \hline \end{tabular} Guide \begin{tabular}{|l|} \hline GuideNum \\ \hline LastName \\ FirstName \\ Address \\ City \\ State \\ PostalCode \\ PhoneNum \\ HireDate \\ \hline \end{tabular} Reservation \begin{tabular}{|l|} \hline ReservationID \\ \hline TripID \\ TripDate \\ NumPersons \\ TripPrice \\ OtherFees \\ CustomerNum \\ \hline \end{tabular} TripGuides TripID GuideNum