bank

Tables (6)

account (5)

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

borrower (4)

  • Id (Foreign key) — Foreign key → customer.Id — NOT NULL
  • loan_number (Foreign key2) — Foreign key → loan.loan_number

branch (1)

  • Branch_name (Key) — Primary key — NOT NULL
  • branch_city (Field)
  • asset (Field2)

customer (2)

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

depositor (6)

  • account_number (Foreign key) — Foreign key → account.account_number — NOT NULL
  • Id (Foreign key2) — Foreign key → customer.Id — NOT NULL

loan (3)

  • loan_number (key) — Primary key
  • Branch_name (Foreign key) — Foreign key → branch.Branch_name — NOT NULL
  • amount (Field3)