\begin{frame}
  \frametitle{Consequences of Bad DB Design}

  \begin{goal}{}
    Usually a severe sign of \emph{bad DB design} if a table
    contains an FD (encodes a partial function) that is 
    \emph{not implied by a key}.
  \end{goal}
  \smallskip
  
  \begin{exampleblock}{}
    Here $\sql{instructor} \to \sql{phone}$ is not implied by a key in:
    \begin{tcenter}
      \tableCourses
    \end{tcenter}
  \end{exampleblock}
  \bigskip
  \pause
  
  \begin{alertblock}{}
     This leads to
     \begin{itemize}
       \item \emph{redundant storage of certains facts}\\
         \remark{(here, phone numbers)}
       \item \emph{insert, update, deletion anomalies}
     \end{itemize}
  \end{alertblock}
\end{frame}