2

Tables (4)

EMPLOYEE

  • Key (SSn) — Primary key — NOT NULL
  • Key (Name) — Foreign key → Untitled.Key — NOT NULL
  • Field (Fname)
  • Minit
  • Field2 (Lname)
  • Field (Bdate)
  • Field2 (NAME)
  • Field3 (Address)
  • Field4 (Salary)
  • Field (SEX)
  • Field (SUPERVISION)
  • Field (DEPENDENTS_of)

Untitled (DEPARTMENT)

  • Key (Name) — Primary key — NOT NULL
  • Key (Number) — Primary key — NOT NULL
  • Key (SSn) — Foreign key → EMPLOYEE.Key — NOT NULL
  • Key2 (Number2) — Foreign key → Untitled.Key2 — NOT NULL
  • Field (Locations)
  • Field (WORKS_FOR)
  • Field (MANAGERS)
  • Field (Start_date)
  • Field (CONTROLS)

Untitled (PROJECT)

  • Key (Name) — Primary key — NOT NULL
  • Key2 (Number) — Primary key — NOT NULL
  • Field (Location)
  • Field (WORKS_ON)
  • Field (Hours)

Untitled (DEPENDENT)

  • Key (Name) — Primary key — NOT NULL
  • Field (Sex)
  • Field (Birth_date)
  • Field (Relationships)