Exercise 7

Tables (5)

Untitled (PROJECT)

  • Key (assignID) — char(10) — Primary key — NOT NULL
  • Key (employeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field
  • Key (loanNumber) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (LOANS)

  • Key (loanNumber) — char(5) — Primary key — NOT NULL
  • Field (amount) — integer
  • Field (payment) — integer

Untitled (PM)

  • Key (employeeID) — char(10) — Primary key — NOT NULL
  • Key (assignID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — char(10)
  • Field (information) — text

Untitled (SUBCONTRACTOR)

  • Key (subID) — char(5) — Primary key — NOT NULL
  • Field (description) — text

Untitled (CORPORATION)

  • Key (assignID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (employeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (subID) — char(5) — Foreign key → Untitled.Key — NOT NULL