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?
A) Activity_Fee is a determinant of Activity.
B) Activity_Fee is partially dependent on the key.
C) The table contains a transitive dependency.
D) Activity_Fee is a determinant of Activity and Student_ID.

Question

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? 
A) Activity_Fee is a determinant of Activity. 
B) Activity_Fee is partially dependent on the key. 
C) The table contains a transitive dependency. 
D) Activity_Fee is a determinant of Activity and Student_ID.

Quizplus · Accepted Answer

The Answer of 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? 
A) Activity_Fee is a determinant of Activity. 
B) Activity_Fee is partially dependent on the key. 
C) The table contains a transitive dependency. 
D) Activity_Fee is a determinant of Activity and Student_ID.

The Exhibit Shows a Table Called Recreation Relation That Relates