\begin{frame}
  \frametitle{Eliminating Tables}

  \begin{center}
    \scalebox{.92}{
    \begin{tikzpicture}[every edge/.style={link}]
      \node[entity] (customer) {branch};
      \node[attribute] (id) [above left of=customer,node distance=1.7cm,shift={(3mm,-1mm)}] {\key{name}} edge (customer);
      \node[attribute] (name) [above of=customer,node distance=1.1cm,xshift=7mm] {city} edge (customer);

      \node[entity,right of=customer, node distance=6cm] (account) {account};
      \node[attribute] (account-number) [above of=account,node distance=1.2cm] {\key{number}} edge (account);
      \node[attribute] (balance) [right of=account,node distance=2.3cm,yshift=4mm] {balance} edge (account);

      \node[relationship] (does) at ($(customer)!.5!(account)$) {account-of} edge node [above,pos=.6] {$1\sldots 1$} (customer) edge node [above,pos=.6] {$0\sldots *$} (account);
    \end{tikzpicture}}
  \end{center}\vspace{-1ex}

  \begin{exampleblock}{Basic translation}
  \pause
  \centering{\footnotesize\ttfamily
    \hspace*{-.9ex}\colorbox{rellight}{%
      \begin{tabular}[t]{|r|r|}
        \multicolumn{2}{c}{Branch}        \\ \hline
        \hd{\key{name}} & \hd{city} \\ \hline 
        branch1 & Amsterdam  \\
        branch2 & Utrecht \\
        \hline
      \end{tabular}%
    }\;\;%
    \colorbox{rellight}{%
      \begin{tabular}[t]{r|r|}
        \multicolumn{2}{c}{Account-of}        \\ \hline
        \hd{\parbox{1.6cm}{\key{number}\\[-.5ex]$\to\;$Account\smallskip}} & \hd{\parbox{1.4cm}{\key{name}\\[-.5ex]$\to\;$Branch}} \\ \hline 
        83828 & branch1  \\
        29281 & branch2 \\
        \hline
      \end{tabular}%
    }\;\;%
    \colorbox{rellight}{%
      \begin{tabular}[t]{r|r|}
        \multicolumn{2}{c}{Account}        \\ \hline
        \hd{\key{number}} & \hd{balance} \\ \hline 
        83828 & 125  \\
        29281 & 1000 \\
        \hline
      \end{tabular}%
    }}
  \end{exampleblock}
  \pause
  
  \begin{exampleblock}{Optimised translation}
  \pause
  \centering{\footnotesize\ttfamily
    \colorbox{rellight}{%
      \begin{tabular}[t]{|r|r|}
        \multicolumn{2}{c}{Branch}        \\ \hline
        \hd{\key{name}} & \hd{city} \\ \hline 
        branch1 & Amsterdam  \\
        branch2 & Utrecht \\
        \hline
      \end{tabular}%
    }\quad\quad%
    \colorbox{rellight}{%
      \begin{tabular}[t]{|r|r|r|}
        \multicolumn{3}{c}{Account}        \\ \hline
        \hd{name$\;\to\;$Branch} & \hd{\key{number}} & \hd{balance} \\ \hline 
        branch1 & 83828 & 125  \\
        branch2 & 29281 & 1000 \\
        \hline
      \end{tabular}%
    }}
  \end{exampleblock}
\end{frame}