Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

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

Limited Time Offer

25%

Off

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Julianna
10 days ago
This question is a classic database normalization problem. I think the correct answer is B - Activity_Fee is partially dependent on the primary key. The primary key is the composite of Student_ID and Activity, so the fee depends on both of those columns.
upvoted 0 times
...
Yan
11 days ago
I'm not sure, but I think C) The table contains a transitive dependency could also be a possibility.
upvoted 0 times
...
Veta
13 days ago
I agree with Aaron, because both Activity and Student_ID are needed to determine the Activity_Fee.
upvoted 0 times
...
Aaron
17 days ago
I think the correct statement is D) Activity_Fee is a determinant of Activity and Student_ID.
upvoted 0 times
...

Save Cancel