Concepts of Database Management, Ninth Edition Solutions Chapter 6, page 5
©2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted
in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
ClassParticipant (ClassNum, ParticipantNum, ClassDate, ActualNum)
FK ClassNum → Class
FK ParticipantNum → Participant
Diagram: The student’s diagram should have the following boxes (rectangles):
Guide, Trip, Reservation, Customer, TripGuides, Participants, Class
The diagram should have the following connections (arrows):
Guide to TripGuides, Trip to TripGuides, Customer to Reservation, Participant to
ClassParticipant,
Class to ClassParticipant,
3. [Critical Thinking] Answers will vary. You could add the following table
Invoice (InvoiceNum, ParticipantNum, ClassNum)
Participant (ParticipantNum LastName, FirstName, Address, City, State, ZipCode)
Class (ClassNum, Description, ClassFee)
Diagram: The student’s diagram should have the following boxes (rectangles):
Invoice, Participant, Class
The diagram should have the following connections (arrows and ovals)
Invoice to InvoiceNum, Invoice to ParticipantNum, Participant to LastName, Participant to
FirstName, Participant to Address, Participant to City, Participant to State, Participant to
ZipCode, Invoice to Class, Class to ClassNum, Class to Description, Class to ClassFee
Answers to Sports Physical Therapy Case
1.A) Therapist (TherapistID, LastName, FirstName, Street, City, State, ZipCode)
Diagram: The students diagram should have the following boxes (rectangles):
Therapist
The diagram should have the following connections (ovals):
Therapist to TherapistID, Therapist to LastName, Therapist to FirstName, Therapist to Street,
Therapist to City, Therapist to State, Therapist to ZipCode
B) Patient (PatientNum, LastName, FirstName, Street, City, State, ZipCode, Balance)
Diagram: The student’s diagram should have the following boxes (rectangles):
Patient
The diagram should have the following connections (ovals):
Patient to PatientNum, Patient to LastName, Patient to FirstName, Patient to Street,
Patient to City, Patient to State, Patient to ZipCode
C) Sessions (SessionNum, Date, LengthOfSession, TherapistID, TherapyCode)
TherapistSession (SessionNum, TherapistID)