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