Search code examples
databaserelationfunctional-dependencies

Can a set of functional dependencies contain an attribute not in the relation?


Example: Consider the relation R = (A,B,C) and the set of FDs, F = (AB -> C, C -> D).

Notice D is not in the relation R, is this possible?


Solution

  • No, functional dependencies are defined on sets of the relation attributes.