CIW Exam 1D0-541 Topic 3 Question 68 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 68
Topic #: 3

[All 1D0-541 Questions]

The exhibit shows a table called Recreation Relation that relates a unique student

identification number and a sports activity with a fee for participating in that activity. The

Student_ID and Activity columns in the table are used together as a composite key. Which

statement about the relation is correct?

AActivity_Fee is a determinant of Activity.

BActivity_Fee is partially dependent on the primary key.

CThe table contains a transitive dependency.

DActivity_Fee is a determinant of Activity and Student_ID.

Show Suggested Answer

Suggested Answer: A

by Glory at Mar 28, 2023, 03:07 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

13 hours ago

I'm not sure, but I think C) The table contains a transitive dependency could also be a possibility.

upvoted 0 times

...

3 days ago

I agree with Aaron, because both Activity and Student_ID are needed to determine the Activity_Fee.

upvoted 0 times

...

7 days ago

I think the correct statement is D) Activity_Fee is a determinant of Activity and Student_ID.

upvoted 0 times

...