148/291
\begin{frame}
  \frametitle{Consequences of Bad DB Design}

  \begin{goal}{Update anomalies}
  \begin{itemize}
    \item
      When a single value needs to be changed (e.g., a phone number), \emph{multiple tuples} must be updated.  
      This \emph{complicates programs and updates takes longer}.
  
    \item Redundant copies potentially get \emph{out of sync} and it is
      impossible/hard to identify the correct information.
  \end{itemize}
  \end{goal}

  \begin{goal}{Insertion anomalies}
  \begin{itemize}
    \item The phone number of a new instructor cannot be inserted into
      the DB until it is known what course she/he will teach.
    \item Insertion anomalies arise when \emph{unrelated concepts} 
      are \emph{stored together in a single table}.
  \end{itemize}  
  \end{goal}
  
  \begin{goal}{Deletion anomalies}
  \begin{itemize}
  \item When the last course of an instructor is deleted, his/her
    phone number is lost.
  \end{itemize}
  \end{goal}
\end{frame}