ex7

Tables (5)

ABC (Untitled)

  • PMno. (Key) — char(16) — Primary key — NOT NULL
  • PMname (Field) — char(4)
  • PMbirthday (Field2) — char(6)
  • Field3 — char(16)

Bank (Untitled5)

  • loan (Key) — char(100) — Primary key — NOT NULL
  • amount (Field) — char(100)
  • loanno. (Field2) — char(16)
  • PMno. (Key2) — char(16) — Foreign key → ABC.PMno. — NOT NULL

PM (Untitled4)

  • PMno. (Key) — char(16) — Primary key — NOT NULL
  • PMname (Field) — char(4)
  • PMbirthday (Field2) — char(6)

project (Untitled2)

  • pjno. (Key) — char(16) — Primary key — NOT NULL
  • PMno. (Field) — char(16)
  • loan (Field2) — char(100)
  • subconno. (Field3) — char(16)
  • loan (Key2) — char(100) — Foreign key → Bank.loan — NOT NULL
  • PMno. (Key3) — char(16) — Foreign key → PM.PMno. — NOT NULL
  • subconno. (Key4) — char(16) — Foreign key → subcon..subconno. — NOT NULL

subcon. (Untitled3)

  • subconno. (Key) — char(16) — Primary key — NOT NULL
  • field (Field) — char(20)
  • affinity (Field2)