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
:
wherever -
-
and
and
[cite:;from @elmasri_db_2015 chapter 14.6.1 formal definition of multivalued dependency]