9/252
\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}
    \item The relational model all table entries are already atomic.
    \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}:
    \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}
      \item 
        List represented by several columns.
        \begin{itemize}
          \item e.g. columns \sql{value1}, \sql{value2}, \sql{value3}
        \end{itemize}
    \end{itemize}
    Nevertheless, these are \emph{bad design}.
  \end{alertblock}
\end{frame}