TCA 8731
Posted 3 months ago

Define and discuss the concept of transitive dependency.

Last updated at 1 month ago.

1 Answers

This question have the following answers.

Posted 2 months ago

An indirect relationship between data elements in a database. The rule is essentially that A is a transitive dependency of C (A->C) if A is functionally dependent on B (A->B), and B is functionally dependent on C (B->C) but not on A (B not->A).

For Example

Social security number is a transitive dependency of date-of-birth (SSN->DOB), because social security number is dependent on employee name (SSN->EMP), and employee name is dependent on date-of-birth (EMP->DOB) but not on social security number (there may be more than one John Smith or Maria Gomez).


Login / Signup to Answer this Question.

Login Signup