database

Tables (6)

Account (Untitled2)

  • PK (account_number) — Primary key — NOT NULL
  • FK (Branch) — Primary key — NOT NULL
  • Field (balance)
  • PK (branch_name)
  • PK (branch_name2) — Foreign key → branch.PK — NOT NULL

Borrower (Untitled3)

  • PK ((ID,loan_number) — Primary key — NOT NULL
  • FK (ID > Customer(ID),loan_number>Loan(loan_number)) — Primary key — NOT NULL
  • PK:\ (loan_number3) — Foreign key → Loan.PK:\ — NOT NULL
  • FK (Branch2) — Foreign key → Loan.FK — NOT NULL

Customer (Untitled6)

  • PK (ID) — Primary key — NOT NULL
  • PK ((ID,loan_number) — Foreign key → Borrower.PK — NOT NULL
  • FK (ID > Customer(ID),loan_number>Loan(loan_number)) — Foreign key → Borrower.FK — NOT NULL

Depositor (Untitled5)

  • PK (ID, account_number) — Primary key — NOT NULL
  • FK (Key2) — Primary key — NOT NULL
  • PK (account_number2) — Foreign key → Account.PK — NOT NULL
  • FK (Branch) — Foreign key → Account.FK — NOT NULL
  • PK (ID2) — Foreign key → Customer.PK — NOT NULL

Loan (Untitled4)

  • PK:\ (loan_number) — Primary key — NOT NULL
  • FK (Branch) — Primary key — NOT NULL
  • Field (amount)
  • PK (branch_name) — Foreign key → branch.PK — NOT NULL

branch (Untitled)

  • PK (branch_name) — Primary key — NOT NULL
  • Field (branch_city,assets)
  • PK (loan_number)
  • FK (Branch)