\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}