267/291
\begin{frame}
  \frametitle{Examples}
  
  \begin{goal}{}
    In the ER model, the solution is the ``same'' as in the
    relational model: we have to \emph{split} the entity set.
  \end{goal}
  \medskip
  \pause
  
  \begin{exampleblock}{ER entity split}
    In this case, the instructor is an independent entity:
    \begin{tcenter}
      \scalebox{.9}{
      \begin{tikzpicture}[every edge/.style={link}]
        \node[entity] (customer) {Courses};
        \node[attribute] [above left of=customer,node distance=1.7cm,shift={(-7mm,-3mm)}] {\key{courseNr}} edge (customer);
        \node[attribute] [above of=customer,node distance=1.3cm] {title} edge (customer);

        \node[entity,xshift=70mm] (ins) {Instructors};
        \node[attribute] [above of=ins,node distance=1.1cm] {\key{instructor}} edge (ins);
        \node[attribute] [below left of=ins,node distance=1.7cm] {phone} edge (ins);

        \node[relationship] at($(customer)!.5!(ins)$) {given\_by}
          edge node [pos=.7,above] {$1..1$} (ins)
          edge node [pos=.7,above] {$0..*$} (customer);
      \end{tikzpicture}
      }  
    \end{tcenter}
  \end{exampleblock}
\end{frame}