Question

Multi valued dependencies are also called as __________

(a) Equality generating dependencies

(b) Tuple generating dependencies

(c) Multi-purpose dependencies

(d) None of the mentioned

I got this question during an interview.

I would like to ask this question from Decomposition Algorithms topic in section Relational Database Design of RDBMS

Answer 1

Correct choice is (b) Tuple generating dependencies

For explanation I would say: Multi valued dependencies are also called as tuple generating dependencies because they require other tuples of a certain form to be present in the relation.