\begin{frame}
\frametitle{Relational Model}
In this course, we work with \emph{relational databases}.\\
View and logical level represent data as \emph{relations/tables}.
\smallskip
\begin{exampleblock}{Example relational database instance}
\scalebox{.8}{
\begin{tabular}{| c | c | c | c |}
\rowcolor{mblue!20}
\mc{4}{Customers}
\\ \hline \rowcolor{mblue!40}
\ul{id} & name & street & city
\\ \hline \rowcolor{mblue!20}
191 & George & 1 Main & London
\\ \hline \rowcolor{mred!30}
\anchor{relational-row} 302 & Elvis & 12 East & Amsterdam
\\ \hline \rowcolor{mblue!20}
239 & Lisa & 5 North & New York
\\ \hline
\end{tabular}
}
\hfill%
\scalebox{.8}{
\begin{tabular}{|c|c|}
\rowcolor{mblue!20}
\mc{2}{Accounts}
\\ \hline \rowcolor{mblue!40}
depositor & \ul{accountnr}
\\ \hline \rowcolor{mblue!20}
191 & 101
\\ \hline \rowcolor{mblue!20}
302 & 217
\\ \hline \rowcolor{mblue!20}
239 & 205
\\ \hline
\end{tabular}
}
\medskip
\begin{itemize}
\item \anchor{relational-from}\emph{row = tuple record}:
(302, Elvis, 12 East, Amsterdam)
%\item sequence of columns/attributes
\end{itemize}
\begin{tikzpicture}[remember picture,overlay]
\draw [very thick,->,dblue] ($(relational-from)+(-4mm,0mm)$) -- ++(-6mm,0mm) |- ($(relational-row)+(-2.7mm,1.5mm)$);
\end{tikzpicture}\vspace{-2ex}%
\end{exampleblock}
\medskip
In the \emph{pure relational model}, a table is a \emph{set} of tuples:%
\begin{itemize}
\item has no duplicate tuples (rows)
\item no order on the tuples
\end{itemize}
\end{frame}