The dependence of nonprimary key attributes on other nonprimary key attributes best describes a:
A) relationship dependency.
B) transitive dependency.
C) weak attribute.
D) weak entity.
E) weak relationship.

Question

Quizplus · Accepted Answer

This describes a transitive dependency, where a nonprimary key attribute depends on another nonprimary key attribute instead of the primary key. For example, if we have a table of students where each record has a student ID (primary key), but also includes the student's homeroom teacher and the teacher's phone number. In this case, the phone number is dependent on the teacher attribute, which is not the primary key, creating a transitive dependency.

The Dependence of Nonprimary Key Attributes on Other Nonprimary Key