\begin{frame}
  \frametitle{Relational Normal Forms: Objectives}
  
 After completing this chapter, you should be able to
    \begin{itemize}
    \item work with \emph{functional dependencies} (FDs), 
      \begin{itemize}
        \item define what they are
        \item detect them in database schemas
        \item decide implication, determine keys
      \end{itemize}
    \item explain insert, update, and delete \emph{anomalies,}
    \item understand, explain and use \emph{BCNF}
      \begin{itemize}
        \item test a given relation for BCNF, and
        \item transform a relation into BCNF
      \end{itemize}       
    \item understand, explain and use \emph{3NF}
      \begin{itemize}
        \item test a given relation for 3NF, and
        \item transform a relation into 3NF
      \end{itemize}       
    \item understand, explain \emph{MVDs} and \emph{4NF}
%     \item detect and correct violations of \emph{4NF,}\pause%
    \item detect \emph{normal form violations} on the level of ER,
    \item explain when and how to \emph{denormalize} a DB schema
    \end{itemize}
\end{frame}
}

\theme{Other Constraints}