A new table needs to be added to the Sports Physical Therapy database to track which sports

Question:

A new table needs to be added to the Sports Physical Therapy database to track which sports the patients are playing. This data will be used to analyze the results of the therapies. Assuming that many patients play multiple sports, how would you design the table?

a. SportsPlayed (PatientNum, SportName)

b. SportsPlayed (PatientNum, SportName)

c. SportsPlayed (SportsPlayedID, PatientNum, SportName)

d. SportsPlayed (PatientNum, SportName1, SportName2, SportName3)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: