COMPANY

Tables (3)

EMPLOYEE (employee)

  • Key (employNo) — integer — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (gender) — char(10)
  • Field (address) — char(30)
  • Field (email) — char(20)
  • Field (salary) — integer
  • Field (birthDate) — integer
  • Field (department) — char(20)
  • Field (supervisor) — char(20)

Untitled (department)

  • Key (depNo) — integer — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (locations) — char(20)
  • Field (manager) — char(20)
  • Field (managerStartDate) — integer
  • Field

Untitled (project)

  • Key (proNo) — integer — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (controllingDep) — char(20)
  • Field (location) — char(20)