mid term

Tables (5)

FIRM (Untitled2)

  • FNAME (Field) — Primary key
  • ADDRESS (Field2) — Primary key

HIRES (Untitled4)

  • PROJECT (Field) — Primary key
  • FEE (Field2) — Primary key
  • SSNO (Field3) — Foreign key → INVENTOR.SSNO
  • LAST (Field22) — Foreign key → INVENTOR.LAST
  • FIRST (Field32) — Foreign key → INVENTOR.FIRST

INVENTOR (Untitled)

  • SSNO (Field) — Primary key
  • LAST (Field2) — Primary key
  • FIRST (Field3) — Primary key

PATENT ATTORNEY (Untitled5)

  • FNAME (Field3) — Foreign key → WORKS FOR.FNAME
  • ADDRESS (Field22) — Foreign key → WORKS FOR.ADDRESS
  • PROJECT (Field4) — Foreign key → HIRES.PROJECT
  • FEE (Field23) — Foreign key → HIRES.FEE
  • SSNO (Field32) — Foreign key → HIRES.SSNO
  • LAST (Field222) — Foreign key → HIRES.LAST
  • FIRST (Field322) — Foreign key → HIRES.FIRST
  • BILLNO (Field)
  • NAME (Field2)

WORKS FOR (Untitled3)

  • FNAME (Field) — Foreign key → FIRM.FNAME
  • ADDRESS (Field2) — Foreign key → FIRM.ADDRESS