ERD Exercise 7

Tables (4)

Untitled (project)

  • Key (projectNo) — Char — Primary key — NOT NULL
  • Key (PM(ssn)) — Char — Foreign key → Untitled.Key — NOT NULL
  • Key (subcontractorsNo) — Char — Foreign key → Untitled.Key — NOT NULL
  • Key (loanNo) — Char — Foreign key → Untitled.Key — NOT NULL

Untitled (PM)

  • Key (ssn) — Char — Primary key — NOT NULL
  • Field (name) — Char

Untitled (subcontractors)

  • Key (subcontractorsNo) — Char — Primary key — NOT NULL
  • Field (code) — Char

Untitled (loan)

  • Key (loanNo) — Char — Primary key — NOT NULL
  • Field (amount) — int
  • Field (payment) — int