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 answer-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

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

See More Books

Question Posted: Nov 30, 2023 01:27 AM

See More Questions

Patient Number 1014 is receiving three treatments in one session. Is the following design correct for the Session table? a. Yes, this is a good way to record multiple sessions. b. Yes, but the two...
Health Care Partners (HCP) was a 40-year-old company providing health care benefits for large corporations. In order to keep health care costs down for its clients, HCP needed to get a large group of...
Suppose the Session table is set up as follows. Is this design correct? If not, in which normal form would you correct it? a. First normal form b. Second normal form c. Third normal form d. It is...
At December 31, 2018, Landy Products has cash of $24,000, receivables of $18,000, and inventory of $80,000. The companys equipment totals $182,000. Landy owes accounts payable of $22,000 and...
Does it seem likely that most purchasers evaluated their investments ahead of time? What might an investor need to do to determine the value of the investment?
XYZ Ltd. is considering replacement of its two-year old computer. Original purchase price was $4,000 with expected operating costs of $500 for the third year. A new computer costs $5,000, and will...
True or False: If $E R R>M A R R$, then MIRR $>$ MARR.
Job costing, unit cost, ending work in process. Rafael Company produces pipes for concert quality organs. Each job is unique. In April 2011, it completed all outstanding orders, and then, in May...
distributed database management system, are there any concerns or issues managing distributed database management systems, and if so, why?
What foreign key(s) does the Session table contain? Session (SessionNum, SessionDate, PatientNum, LengthOfSession, TherapistID, TherapyCode). a. PatientNum, TherapistID, TherapyCode b. PatientNum...
How do you diagram the functional dependence on TherapyCode in the Therapies table? a. TherapyCode + Description, UnitOfTime b. TherapyCode (Description, UnitOfTime) c. TherapyCode Description,...
Identify the reasons why governments looked beyond government departments and Crown agencies for delivering services to citizens.
You have been provided a list of internal (City governance and operation) and external (users) stakeholders including the requirements identified and with each group. How would you narrow the broad...
List five of the most significant lessons learned during the course. For each lesson learned explain: 1. Why is it critical to future projects? 2. How can the lesson learned be implemented into the...
The following information is available for Elwes Company for the year ended December 31, 2015: Accounts payable $ 3,800 Accumulated depreciation-equipment 4,000 Common stock 5,000 Retain earnings...
1. Taking into consideration the reading by Nussbaum " Judging Other Cultures; The Case of Genital Mutilation" discuss any piece of the text that you found particularly interesting. Explain why, and...
Find the x-values on the curve y = 2- x where the tangent line has a slope of
Assume that you have been asked to place a value on the ownership position in Briarwood Hospital. Its projected profit and loss statements and retention requirements are shown below (in millions):...
Catalytic hydrogenation of naphthalene over PdC results in rapid addition of 2 moles of H 2 . Propose a structure for this product.
Compare and contrast byte-oriented and bit-oriented protocols.
Unstuff the following frame payload: 00011111000001111101110100111011111000001111
Compare and contrast byte-stuffing and bit-stuffing.
What is the benefit of the CASS system?
what is the amount of unding from existing or previously submitted budgets for the existing operation that could be used for the new proposed operations? what is the risk of availability of funding...
If you have a gross annual salary of $75,000 and a net annual salary of $50,000, what is the maximum amount that you can spend on your mortgage payment (principal and interest), your property taxes...

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

Question:

Step by Step Answer:

The candidate keys for the Session table could be a ...View the full answer

Concepts Of Database Management

Students also viewed these Computer science questions