Consider the ER diagram shown in Figure 1 for part of a BANK database.
Each bank can have multiple branches, and each branch can have multiple accounts and loans.
- List the (non-weak) entity types in the ER diagram.
- Is there a weak entity type? If so, give its name, partial key, and identifying relationship.
- List the names of all relationship types, and specify the (min, max) constraint on each participation of an entity type in a relationship type.