1. For each relationship, identify the participation constraints (total or partial participation) and describe the information it conveys considering both sides of relationship.

2. Indicate if the relationship is an identifying relationship (i.e., a relationship of a weak entity).

3. Indicate attribute(s) of a relationship, if any.

Figure 3.21 An ER diagram for a BANK database schema. BANK BRANCHES BANK_BRANCH ode Name Addr Addr Branch no ACCTS LOANS Acct no Balance Loanno Amount ACCOUNT Type LOAN ype A C L C Ssn Name Phone CUSTOMER Addr