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