transitive dependency

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). See functional dependency.

Eliminate Transitive Dependencies
When designing a database, the goal is to achieve "third normal form" by eliminating transitive dependencies in each table. See normalization.

单词	transitive dependency
释义	DictionarySeenormalization transitive dependency transitive dependency 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). See functional dependency. Eliminate Transitive Dependencies When designing a database, the goal is to achieve "third normal form" by eliminating transitive dependencies in each table. See normalization.
随便看	voluntary association voluntary association for rehabilitation of afghan voluntary assumption voluntary bankruptcies voluntary bankruptcy voluntary blood donors association voluntary botnet voluntary caregiver voluntary center vojvodina voluntary challenge and registry voluntary children's chemical evaluation program voluntary cleanup and property redevelopment program voluntary cleanup program voluntary closing voluntary code of practice voluntary compensation endorsement voluntary compensation endorsements voluntary compliance voluntary compliances voluntary consent order voluntary control council for interference voluntary conveyance voluntary conveyances wakame wakanda