\begin{frame}
\frametitle{Multivalued Dependencies}
\begin{block}{Multivalued Dependency}
A \emph{multivalued dependency (MVD)}
\begin{talign}
A_1, \dots, A_n \mvd B_1, \dots, B_m
\end{talign}
is satisfied in a DB state $I$ $\iff$ for all tuples $t,u \in I(R)$ with
\begin{tcenter}
$t.A_i = u.A_i, 1 \leqslant i \leqslant n$
\end{tcenter}
there are two tuples $t',u' \in I(R)$ such that
\begin{enumerate}
\item $t'$ agrees with $t$ except that $t'.B_i = u.B_i, 1 \leqslant i \leqslant m$, and
\item $u'$ agrees with $u$ except that $u'.B_i = t.B_i, 1 \leqslant i \leqslant m$.
\end{enumerate}
\end{block}
\medskip
The condition means that the values of the $B_i$ are swapped:
\begin{center}\vspace{-2ex}
\scalebox{.85}{
\begin{tikzpicture}[thick,r/.style={rectangle,draw,fill=yellow!20}]
\node [r] (t) {$a_1,\ldots,a_n,\;b_1,\ldots,b_m,\;c_1,\ldots,c_k$};
\node [r,yshift=-8mm] (u) {$a_1,\ldots,a_n,\;b'_1,\ldots,b'_m,\;c'_1,\ldots,c'_k$};
\node [lo=t] {$t$};
\node [lo=u] {$u$};
\node [r,xshift=65mm] (t) {$a_1,\ldots,a_n,\;b'_1,\ldots,b'_m,\;c_1,\ldots,c_k$};
\node [r,xshift=65mm,yshift=-8mm] (u) {$a_1,\ldots,a_n,\;b_1,\ldots,b_m,\;c'_1,\ldots,c'_k$};
\node [lo=t] {$t'$};
\node [lo=u] {$u'$};
\end{tikzpicture}
}
\end{center}
\end{frame}