13/72
\begin{frame}
  \frametitle{Eliminating Tables}

  \begin{goal}{}
  \emph{Many-to-one} \& \emph{one-to-many} relations can be represented by:%
  \begin{itemize}
    \item adding an extra extra attribute/column to the many-side 
      with the primary key of the one-side
  \end{itemize}
  \end{goal}
  \medskip
  \pause

  \begin{center}
    \scalebox{.92}{
    \begin{tikzpicture}[every edge/.style={link}]
      \node[entity] (customer) {customer};
      \node[attribute] (id) [above left of=customer,node distance=1.7cm,shift={(-2mm,-3mm)}] {\key{id}} edge (customer);
      \node[attribute] (name) [above of=customer,node distance=1.3cm] {name} edge (customer);
      \node[attribute] (street) [left of=customer,node distance=2.1cm] {street} edge (customer);
      \node[attribute] (city) [below left of=customer,node distance=1.7cm] {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{account-number}} edge (account);
      \node[attribute] (balance) [below right of=account,node distance=1.7cm,xshift=-5mm] {balance} edge (account);

      \node[relationship] (does) at ($(customer)!.5!(account)$) {depositor} edge node [above,pos=.6] {$1\sldots 1$} (customer) edge node [above,pos=.6] {$1\sldots *$} (account);
    \end{tikzpicture}}
  \end{center}
  
  For example, instead of creating a table for the relationship set \textit{depositor},
  add a the attribute \textit{id} of \textit{customer} to \textit{account}.

  \centering{\small\ttfamily
    \colorbox{rellight}{%
      \begin{tabular}[t]{|r|r|r|}
        \multicolumn{3}{c}{account}        \\ \hline
        \hd{id$\to$customer} & \hd{\key{account-number}} & \hd{balance} \\ \hline 
        12-0202 & 83828 & 125  \\
        01-1823 & 29281 & 1000 \\
        \hline
      \end{tabular}%
    }}
\end{frame}