Question

Functional dependencies are sometimes referred to as ________

(a) Equality generating dependencies

(b) Tuple generating dependencies

(c) Multi-purpose dependencies

(d) None of the mentioned

This question was posed to me in a job interview.

My question comes from Decomposition Algorithms in section Relational Database Design of RDBMS

Answer 1

Correct option is (a) Equality generating dependencies

For explanation I would say: Functional dependencies are sometimes referred to as equality generating dependencies because they require other tuples of a certain form to be present in the relation.