5/98
\begin{frame}
  \frametitle{Database Design}
  
  Due to the complexity, the design is a multi-step process\ldots
  
  \begin{block}{Three Phases of Database Design}
    \emph{Conceptual Database Design}
        \begin{itemize}
          \item what information do we store
          \item how are the information elements related to each other
          \item what are the constraints?
          \item e.g. ER model or UML model
        \end{itemize}
    \smallskip
    \emph{Logical Database Design}
        \begin{itemize}
          \item transformation of the conceptual schema into 
                the schema supported by the database
          \item e.g. relational model
        \end{itemize}
    \smallskip
    \emph{Physical Database Design}
        \begin{itemize}
          \item design indexes, table distribution, buffer sizes,\ldots
          \item to maximise performance of the final system
        \end{itemize}
  \end{block}
\end{frame}