1

Tables (4)

DEPARTMENT (Untitled)

  • dep ID (Key) — int — Primary key — NOT NULL
  • name (Field) — char
  • locations (Field2) — char
  • number (Field3) — int

EMPLOYEE (Untitled2)

  • SSN (Key) — int — Primary key — NOT NULL
  • name (Field) — char
  • gender (Field2) — char
  • address (Field3) — char

PROJECT (Untitled3)

  • projNo (Key) — Primary key — NOT NULL
  • name (Field)
  • location (Field2)
  • Field3
  • dep ID (Key2) — int — Foreign key → DEPARTMENT.dep ID — NOT NULL

WOERKS-ON (Untitled4)

  • SSN (Key) — int — Foreign key → EMPLOYEE.SSN — NOT NULL
  • projNo (Key2) — Foreign key → PROJECT.projNo — NOT NULL