254/291
\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}