Book

Tables (4)

Department (department)

  • depID — int — Primary key — NOT NULL
  • Field (depManager) — char(30)
  • Field (managerStartDate) — date
  • Field (Location) — char(20)
  • Field (depName) — char(20)
  • Key (empSSN) — char(14) — Foreign key → EMPLOYEE.EmpSSN — NOT NULL

EMPLOYEE

  • EmpSSN — Char(14) — Primary key — NOT NULL
  • EmpName — Char(30)
  • (Department) — Int
  • Field (DepID) — Int
  • Field (SuperVssn) — Char(14)
  • EmpSSN (EmpSSN2) — Char(14) — Foreign key → EMPLOYEE.EmpSSN — NOT NULL
  • depID — int — Foreign key → Department.depID — NOT NULL

PROJECT

  • ProjectID — Int(10) — Primary key — NOT NULL
  • ProjectName — Char(30)
  • StartDate — Date
  • EndDate — Date
  • Description — Text
  • depID (ManagedepID) — int — Foreign key → Department.depID — NOT NULL

Workson

  • EmpSSN — Char(14) — Foreign key → EMPLOYEE.EmpSSN — NOT NULL
  • ProjectID — Int(10) — Foreign key → PROJECT.ProjectID — NOT NULL
  • HoursPerWeek — Float