What would be a candidate key for the Session table, besides the current key field of SessionNum?

Question:

What would be a candidate key for the Session table, besides the current key field of SessionNum? The design of the Session table is Session (SessionNum, SessionDate, PatientNum, LengthOfSession, TherapistID, TherapyCode).

a. SessionDate

b. PatientNum and TherapistID (compound key)

c. TherapyCode and PatientNum (compound key)

d. SessionNum is the only appropriate key field.

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: