0314

Tables (5)

DEPARTMENT

  • Key (departmentID) — char(5) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (lacation) — char(30)
  • Field (manageStartDate) — date
  • Key (employeeID) — char(15) — Foreign key → EMPLOYEE.Key — NOT NULL

EMPLOYEE

  • Key (employeeID) — char(15) — Primary key — NOT NULL
  • Field (ssn) — char(12)
  • Field (name) — char(30)
  • gender — char (1)
  • Field (address) — char(50)
  • Field (degree) — char(50)
  • Field (salary) — int(10)
  • Field (bithDate) — date
  • Field
  • Key (departmentID) — char(5) — Foreign key → DEPARTMENT.Key — NOT NULL
  • Key (employeeID2) — char(15) — Foreign key → EMPLOYEE.Key — NOT NULL

Untitled (PROJECT)

  • Key (projectID) — int — Primary key — NOT NULL
  • Field (name) — char(70)
  • Field (description) — text

Untitled (DEPENDENT)

  • Key (deSsn) — char(12) — Primary key — NOT NULL
  • Field (deName) — char(30)
  • Field (deGenger) — char(1)
  • Field

Untitled (WORKSON)