ERD exercise 4(20200916)

Tables (6)

HIRED (Untitled4)

  • businessNo (Key) — CHAR(20) — Primary key — NOT NULL
  • projID (Key2) — CHAR(20) — Foreign key → PROJECT.projID — NOT NULL
  • scID (Key3) — CHAR(20) — Foreign key → SUBCONTRACTOR.scID — NOT NULL

LOAN (Untitled6)

  • loanID (Key) — CHAR(20) — Primary key — NOT NULL
  • amount (Field) — int(20)
  • paymentAmout (Field2) — int(20)
  • projID (Key2) — CHAR(20) — Foreign key → PROJECT.projID — NOT NULL
  • creditor (Field3) — CHAR(30)

PROJECT (Untitled)

  • projID (Key) — CHAR(20) — Primary key — NOT NULL
  • projName (Field) — CHAR(30)
  • PMssn (Key2) — CHAR(20) — Foreign key → PROJECT_MANAGER.ssn — NOT NULL
  • PMStartDate (Field2) — date

PROJECT_MANAGER (Untitled2)

  • ssn (Key) — CHAR(20) — Primary key — NOT NULL
  • PMName (Field) — CHAR(30)
  • address (Field2) — CHAR(50)
  • phone (Field3) — CHAR(20)

SPECIALTY (Untitled5)

  • speID (Field2) — CHAR(20) — Primary key
  • description (Field) — CHAR(100)
  • speName (Field3) — CHAR(30)

SUBCONTRACTOR (Untitled3)

  • scID (Key) — CHAR(20) — Primary key — NOT NULL
  • scName (Field) — CHAR(30)
  • address (Field2) — CHAR(50)
  • phone (Field3) — CHAR(20)
  • speID (Field22) — CHAR(20) — Foreign key → SPECIALTY.speID