A functional dependency between ________ key attributes is also called a transitive dependency.
A)Non-primary
B)Primary
C)Composite
D)Unique

Question

Quizplus · Accepted Answer

A transitive dependency is a dependency between non-primary key attributes. This means that the attribute is dependent on another non-primary key attribute rather than the primary key itself. A composite key can also have transitive dependencies if the dependency is between non-primary key attributes within the composite key. However, a primary or unique key attribute cannot have a transitive dependency as it is already uniquely identifying the row in the table.

A Functional Dependency Between ________ Key Attributes Is Also Called