67/75
\begin{frame}
  \frametitle{Primary Keys}
  
  \begin{center}
  {\small\ttfamily
    \colorbox{rellight}{%
      \begin{tabular}[t]{|r|r|r|r|r|}
        \multicolumn{5}{c}{Customer}        \\ \hline
        \hd{first-name} & \hd{last-name} & \hd{phone} & \hd{street} & \hd{city} \\ \hline 
        Tom & James & 06-73917384 & Main & London \\
        Joe & Jones & 06-18384405 & Slater & Paris  \\
        \hline
      \end{tabular}%
    }}
  \end{center}
  
  \begin{alertblock}{}
  What would be a good primary key?
  \end{alertblock}
  \medskip
  \pause
    
  Is \ $\{\;\textit{first-name},\;\textit{last-name},\;\textit{phone}\;\}$ a good key?
  \pause
  \begin{itemize}
    \item the phone number can change
    \item is it really unique?
  \end{itemize}
  \medskip
  \pause
  
  \begin{goal}{}
  It is often good to introduce an artificial \emph{internal key}:
  \begin{itemize}
    \item e.g. \textit{customer-id}
    \item \emph{advantage: unique, does not change}
    \item minor disadvantage: no descriptive meaning
  \end{itemize}    
  \end{goal}
  \bigskip\bigskip
  
\end{frame}