195/291
\begin{frame}
  \frametitle{Splitting Relations: Lossless Splits}

  \vspace{-.5ex}
  \begin{goal}{}
    Lossless split guarantees that the schema after splitting
    can represent all DB states that were possible before.
  \end{goal}
  \begin{itemize}
    \item we can translate states from the old into the new schema
    \item old schema can be ``simulated'' via views
  \end{itemize}
  \bigskip
  \pause
  
  \begin{goal}{}
    Lossless splits can lead to \emph{more general schemas}!
    \begin{itemize}
      \item the new schema allows states which do not correspond to the state in the old schema
    \end{itemize}
  \end{goal}  
  
  \begin{exampleblock}{}
    \recallexamplephone
    \emph{We may now store instructors and phone numbers without any affiliation to courses.}
  \end{exampleblock}

  % \begin{itemize}
  % \item If instructors without courses are possible in the real world,
  %   the decomposition removes a fault in the old schema (insertion and
  %   update anomalies).
  % 
  % \item If they are not,
  %   \begin{itemize}
  %   \item a new constraint is needed that is not necessarily easier to
  %     enforce than the FD, but 
  %   \item at least the redundancy is avoided (update anomaly).
  %   \end{itemize}
  % \end{itemize}
\end{frame}