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