Database Normalisation Questions Medium
A functional dependency is a relationship between two sets of attributes in a database table. It occurs when the value of one set of attributes determines the value of another set of attributes. In other words, if we know the value of a certain attribute or set of attributes, we can determine the value of another attribute or set of attributes.
On the other hand, a transitive dependency is a type of functional dependency that occurs when the value of one attribute determines the value of another attribute indirectly through a third attribute. In this case, the value of the first attribute determines the value of the second attribute, and the value of the second attribute determines the value of the third attribute.
To summarize, the main difference between a functional dependency and a transitive dependency is that a functional dependency is a direct relationship between two sets of attributes, while a transitive dependency is an indirect relationship between three sets of attributes.