46/98
\begin{frame}
  \frametitle{Total Participation}
  
  \begin{block}{}
    \emph{Total participation}
    means that every entity in the entity set participates in at least one relationship
    in the relationship set.
    \begin{itemize}
      \item e.g. every loan must be belong to at least one customer
    \end{itemize}
  \end{block}
  
  \begin{exampleblock}{}
    \begin{center}
      \scalebox{.92}{
      \begin{tikzpicture}[every edge/.style={link}]
        \node[entity] (customer) {customer};
        \node[attribute] (id) [above left of=customer,node distance=1.7cm,shift={(-2mm,-3mm)}] {\key{id}} edge (customer);
        \node[attribute] (name) [above of=customer,node distance=1.3cm] {name} edge (customer);
        \node[attribute] (street) [left of=customer,node distance=2.1cm] {street} edge (customer);
        \node[attribute] (city) [below left of=customer,node distance=1.7cm] {city} edge (customer);

        \node[entity,right of=customer, node distance=6cm] (loan) {loan};
        \node[attribute] (loan-number) [above of=loan,node distance=1.2cm] {\key{loan-number}} edge (loan);
        \node[attribute] (amount) [below right of=loan,node distance=1.7cm,xshift=-5mm] {amount} edge (loan);

        \node[relationship] (does) at ($(customer)!.5!(loan)$) {borrower} 
          edge node [above,pos=.6] {\alert{\textbf{1}}\sldots N} (customer) 
          edge node [above,pos=.6] {0\sldots M} (loan);
      \end{tikzpicture}}
    \end{center}
  \end{exampleblock}
  \pause
  
  Alternative notation:\hspace{.5cm}
  \scalebox{.8}{
  \begin{tikzpicture}[every edge/.style={link},baseline=-1ex]
    \node[entity] (customer) {customer};
    \node[entity,right of=customer, node distance=6cm] (loan) {loan};
    \node[relationship] (does) at ($(customer)!.5!(loan)$) {borrower} 
      edge (customer) 
      edge [double,double distance=1] (loan);
  \end{tikzpicture}}
  \pause
  
  \begin{block}{}
    \emph{Partial participation} means that entities may not participate
    in any relationship in the set.
  \end{block}
\end{frame}

\theme{Relationship Sets with Attributes}