과제

테이블 (5)

Untitled (DEPARTMENT)

  • Key — int — 기본 키 — NOT NULL
  • Field (depName) — char(20)
  • Field (depManager) — char(30)
  • Field (managerStartDate) — data
  • Field (location)

Untitled (PROJECT)

  • Key — int — 기본 키 — NOT NULL
  • Field (Name)
  • Field (Location)
  • Field (cotrollingDpartment)

Untitled (WORKS-ON)

  • Key — int — 기본 키 — NOT NULL
  • Field (ssn)
  • Field (projNo)
  • Field (hours)

Untitled (EMPLOEE)

  • Key — int — 기본 키 — NOT NULL
  • Field (ssn)
  • Field (name)
  • Field (gender)
  • Field (address)
  • Field (salary)
  • Field (birthDate)
  • Field (department)
  • Field (supervisor)
  • Field (worksOn)

Untitled (DEPENDENT)

  • Key — int — 기본 키 — NOT NULL
  • Field (dependmentName)
  • Field (gender)
  • Field (birthDate)
  • Field (relationship)
  • Field (parent)
  • Field (ssn)