17/36
\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}