A transitive ____ occurs when the value of a nonkey attribute determines, or predicts, the value of another nonkey attribute.
A) conversion
B) recursion
C) dependency
D) anomaly

Question

Quizplus · Accepted Answer

This is the definition of a transitive dependency, which occurs when the value of one nonkey attribute determines the value of another nonkey attribute. This can cause data redundancy and potential inconsistencies in the database if not handled properly. Choices A, B, and D are not directly related to this concept.

A Transitive ____ Occurs When the Value of a Nonkey