A(n)________ occur when the value of one non-key field is functionally dependent on the value of another non-key field.
A)transitive dependencies
B)composite keys
C)non-key fields
D)functional dependencies

Question

Quizplus · Accepted Answer

Transitive dependencies occur in a database when a non-key field's value depends on another non-key field, which in turn depends on the value of a key field. This can lead to redundancy and anomalies in database operations.

A(n)________ Occur When the Value of One Non-Key Field Is