과제2

테이블 (7)

DEPARTMENT

  • depID — Char(4)
  • name — Char(15)
  • managerID — Char(10)
  • managestartDate (managerStartDate) — date
  • empID — Char(10)

EMPLOYEE

  • empID — Char(10)
  • name — Char(10)
  • gcnder (gender) — Char(1)
  • phone (adress) — Char(30)
  • Salary (phone) — Char(11)
  • dcpID (salary) — int(10)
  • supcrvEmpID (depID) — Char(4)
  • Field (supervEmpID) — Char(10)

PROJECT (DEPENDANT)

  • proID (dependID) — char(11)
  • proName (name) — chae(30)
  • startDate (birthDate) — date
  • endDate (relation) — char(10)
  • description (empID) — char(10)

Untitled (PROJECT)

  • Field (proID) — Char(10)
  • Field2 (proName) — Char(30)
  • Field3 (stratDate) — date
  • Field4 (endDate) — date
  • Field (description) — text
  • Field (managerdepID) — Char(4)

Untitled (LOCATION)

  • Field (locID) — Char(5)
  • Field2 (locName) — Char(10)
  • Field (phone) — Char(10)
  • Field (email) — email

Untitled5 (DEPARTMENT_LOCATION)

  • Field (depID) — Char(4)
  • Field (locID) — Char(5)

WORKSON

  • empID — Char(10)
  • proID — Char(10)
  • hourperWeek (hourPerWeek) — float