ERD Exercise 7

Tables (5)

LINEOFWORK (Untitled4)

  • codeNUMBER (Key) — char(10) — Primary key — NOT NULL
  • project NUMBER (Key2) — char(10) — Foreign key → PROJECT.project NUMBER — NOT NULL
  • pmCODE (Key22) — char(10) — Foreign key → PROJECT.pmCODE — NOT NULL
  • subcontractorID (Key3) — char(10) — Foreign key → SUBCONTRACTOR.subcontractorID — NOT NULL

LOAN (Untitled5)

  • loneCODE (Key) — char(1o) — Primary key — NOT NULL
  • project NUMBER (Key2) — char(10) — Foreign key → PROJECT.project NUMBER — NOT NULL
  • amount (Field) — char(15)
  • paymentamount (Field2) — char(15)

MANAGER (Untitled2)

  • pmCODE (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(15)
  • address (Field2) — char(30)

PROJECT (Untitled)

  • project NUMBER (Key) — char(10) — Primary key — NOT NULL
  • pmCODE (Key2) — char(10) — Foreign key → MANAGER.pmCODE — NOT NULL
  • name (Field) — char(15)
  • description (Field2) — char(50)
  • loneCODE (Key3) — char(1o) — Foreign key → LOAN.loneCODE — NOT NULL

SUBCONTRACTOR (Untitled3)

  • subcontractorID (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(15)
  • address (Field3) — char(30)