bank

Tables (4)

bankBranch (branch_t)

  • branchname (manyname) — varchar2(30) — Primary key — NOT NULL
  • city (build) — varchar2(30) — NOT NULL
  • money (mon) — varchar2(30) — NOT NULL
  • english branch (en) — varchar2(30) — NOT NULL
  • setup branch (set) — varchar2(30) — NOT NULL
  • phone (ph) — varchar2(30) — NOT NULL

customer (cus_t)

  • cusnumber (Key) — number(30) — Primary key — NOT NULL
  • cusname (name) — varchar2(30) — NOT NULL
  • cusadd (add) — varchar2(30) — NOT NULL
  • cusbirth (birth) — varchar2(30) — NOT NULL

saving (saving_t)

  • saving number (Key) — number(30) — Primary key — NOT NULL
  • count nb (numb) — number(30) — Foreign key → savingAccout.count nb — NOT NULL
  • cusnumber (Key2) — number(30) — Foreign key → customer.cusnumber — NOT NULL

savingAccout (save_t)

  • count nb (numb) — number(30) — Primary key — NOT NULL
  • in money (input) — varchar2(30) — NOT NULL
  • out money (output) — varchar2(30) — NOT NULL
  • branchname (manyname) — varchar2(30) — Foreign key → bankBranch.branchname — NOT NULL