Transitive Dependency

Last updated Dec 14, 2021 Edit Source

Let’s say in your Relational Model, you have two Functional Dependenciess as such:

1
2

{A} -> {B}
{B} -> {C}

However the dependency {A}->{C} is not specified. Because of the transitive property of the functional dependency relation, this dependency can be inferred. This is called a transitive dependency.