\frametitle{Entity Relationship Model}

  \begin{block}{Entity relationship model}
      \item entities = objects
          \item e.g. customers, accounts, bank branches
      \item relationship between entities
          \item e.g. account 101343 is held by customer Johnson
          \item \emph{relationship set descriptor} associates customers with accounts
      \begin{tikzpicture}[every edge/.style={link}]
        \node[entity] (customer) {customer};
        \node[attribute] (id) [above left of=customer,node distance=1.7cm,shift={(-2mm,-3mm)}] {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] (account) {account};
        \node[attribute] (account-number) [above of=account,node distance=1.2cm] {account-number} edge (account);
        \node[attribute] (balance) [below right of=account,node distance=1.7cm,xshift=-5mm] {balance} edge (account);

        \node[relationship] (does) at ($(customer)!.5!(account)$) {depositor} edge (customer) edge (account);
    \item widely used for database design
    \item usually converted to the relational model