multivalued dependency

a multivalued dependency specified on relation schema , where and are both subsets of , specifies the following constraint on any relation state of : if two tuples and exist in such that , then two tuples and should also exist in with the following properties, where we use to denote :
  • and and
wherever holds, we say that mmultidetermines . because of the symmetry in the definition, whenever holds in , so does . hence, implies and therefore is sometimes written as .
[cite:;from @elmasri_db_2015 chapter 14.6.1 formal definition of multivalued dependency]