bank

Tables (6)

account

  • account_number (Key) — Primary key — NOT NULL
  • branch_name (Key2) — Foreign key → branch.branch_name — NOT NULL
  • balance (Field2)

borrower

  • loan-number (Key2) — Foreign key → loan.loan-number — NOT NULL
  • branch_name (Key3) — Foreign key → loan.branch_name — NOT NULL
  • customer_name (Key4) — Foreign key → customer.customer_name — NOT NULL

branch

  • branch_name (Key) — Primary key — NOT NULL
  • branch_city (Field)
  • assets (Field2)

customer

  • customer_name (Key) — Primary key — NOT NULL
  • customer_street (Field)
  • customer_city (Field2)

depositor

  • customer_name (Key2) — Foreign key → customer.customer_name — NOT NULL
  • account_number (Key) — Foreign key → account.account_number — NOT NULL
  • branch_name (Key22) — Foreign key → account.branch_name — NOT NULL
  • balance (Field2)

loan

  • loan-number (Key) — Primary key — NOT NULL
  • branch_name (Key3) — Foreign key → branch.branch_name — NOT NULL
  • amount (Field2)