24/296
\begin{frame}
  \frametitle{First Normal Form}

  \begin{block}{}
    The \emph{First Normal Form (1NF)} requires that all \emph{table entries are atomic} 
    (\textit{not} lists, sets, records, relations).
  \end{block}  

  \begin{itemize}
  \pause
    \item The relational model all table entries are already atomic.
  \pause
    \item All further normal forms assume that tables are in 1NF.
  \end{itemize}
  \bigskip\pause
  
  \begin{alertblock}{}
    The following are \emph{not violations of 1NF}:
    \pause
    \begin{itemize}
    \item A table entry contains values with internal structure.
    \begin{itemize}
      \item e.g. a \sql{CHAR(100)} containing a comma separated list 
    \end{itemize}
    \pause
    \item List represented by several columns.
      \begin{itemize}
        \item e.g. columns \sql{value1}, \sql{value2}, \sql{value3}
      \end{itemize}
    \end{itemize}
    \pause
    Nevertheless, these are \emph{bad design}.
  \end{alertblock}
\end{frame}