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

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?
Use the data in MINWAGE.RAW for this exercise, focusing on sector 232. (i) Estimate the equation gwage232t = (0 + (1 ygmwaget + (2 gcpi i+ ut, and test the errors for AR( 1) serial correlation. Does...
Capital punishment. Between 1976 and 2007, 1099 convicted criminals were put to death in the United States. Here are data on the number of executions in several states during those years, as well as...
Dungan Corporation is evaluating a proposal to purchase a new drill press to replace a less efficient machine presently in use. The cost of the new equipment at time 0, including delivery and...
Moodle X Question 4 od 1.00 Ya Cuevas Company expects to manufacture and sell 23.000 units in 2019 for $6 each. There are 2,000 units in beginning finished goods inventory with target ending...
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,...
Referring to Exercise 5.5, construct a 99% prediction interval for the kilometers traveled annually by an automobile owner in Virginia. Exercise 5.5 A random sample of 100 automobile owners in the...
How can you filter on a particular data field in Cognos Analytics? 0 / 1 point Type in the name of the field in the 'Filters' area at the top of the page. Drag the data field to the 'All tabs' area...
Project management is fundamental to project success and includes a number of critical success factors including support of top management, use of effective communication channels and rapid feedback,...
BIO 189: what are some of the ethical issues regarding his results? why were his results rejected by the scientific community? choose two components below that were either flawed or completely absent...
REQUIRED: Prepare Cost of Production per department. Problem 5 ABM Company uses two departments to produce a product. The following data were taken from the books for the month of January, 2019....
Can you describe how Toyota responds to changes in market fluctuations, and plot the supply and demand curves indicating managerial economic principles (i.e. price ceilings/floors, shortage/surplus,...
"The after-tax cost of debt is lower when the firm's tax rate is higher; therefore, the WACC falls when the tax rate rises. Thus, with a lower discount rate, the firm must be worth more if its tax...
Proposals have been made to ?sail? spacecraft to the outer solar system using the pressure of sunlight, or even to propel interstellar spacecraft with high-powered, Earth-based lasers. Sailing...
Compare and contrast byte-oriented and bit-oriented protocols.
Unstuff the following frame payload: 00011111000001111101110100111011111000001111
Compare and contrast byte-stuffing and bit-stuffing.
1,600 Balance Sheet The following is a list (in random order) of KIP International Products Company's December 31, 2019, balance sheet accounts: Additional Paid-In Capital on Preferred Stock $2,000...
Question 3 4 pts 9 x + 3 x 9 if x 0 Find a) lim f(x), b) lim, f(x), C), lim , f(x) if they exist. 3 Edit View Insert Format Tools Table : 12pt M Paragraph B IV A2 Tv
Mr. Geoffrey Guo had a variety of transactions during the 2019 year. Determine the total taxable capital gains included in Mr. Guo's division B income. The transactions included: 1. On January 1,...

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