72/72
\begin{frame}
  \frametitle{From Conceptual to Relational Model: Objectives}
  
  After completing this chapter, you should understand:
  \begin{itemize}
    \item \emph{How to translate a conceptual to a relational model}\\
      \begin{itemize}
        \item identifying keys
        \item internal/external keys
        \item (foreign) key constraints
        \item multi-valued attributes
        \item  weak entity sets vs. composition
        \item `is a'
        \item representing cardinalities
        \item recursive relationships
        \item optimisation: removing relationship tables %avoiding junction tables for relationship sets if possible
      \end{itemize}
  \end{itemize}
\end{frame}