Homework 2: ER Schema Interpretation

The goal of this homework is to practice interpreting ER schema diagrams.

Instructions

You are welcome to work with a partner.

Consider the ER diagram shown below for part of a BANK database. Each bank can have multiple branches, and each branch can have multiple accounts and loans.

  1. List the strong (non-weak) entity types in the ER diagram.
  2. For the weak entity type, give its:
    • Name
    • Partial key
    • Identifying relationship
  3. Give a candidate key for the CUSTOMER entity type.
  4. Based on the ER diagram:
    • How many accounts do customers have?
      • For example: At most one? Exactly one? At least one? Any number?
    • How many customers are on an account?
    • How many bank branches are associated with an account?
  5. Write a short paragraph describing the user requirements that led to BANK, BANK_BRANCH, and BRANCHES as depicted in this ER schema design. Describe the attributes, keys, and cardinality.

Hint: You may find it helpful to refer to the notation in Figure 3.14, from Lab 2.

Figure 3.22

Submit

Submit your responses on Gradescope.