2023사서교육원 과제

테이블 (5)

Untitled (DEPARMENT)

  • Key — 기본 키 — NOT NULL
  • Field (depNo) — int
  • Field (depName)
  • Field (depManager)
  • Field (depManagerStartDate)

Untitled2 (PROJECT)

  • Key — 기본 키 — NOT NULL
  • Field (proNo) — int
  • Field (proName)
  • Field (proLocation)
  • Field
  • Key (Key2) — 외래 키 → Untitled.Key — NOT NULL
  • Key (Key3) — 외래 키 → Untitled5.Key — NOT NULL

Untitled3 (DEFENDENT)

  • Key — 기본 키 — NOT NULL
  • Field (depName) — int
  • Field (depGender)
  • Field (depBirthDate)
  • Field2 (depParent)
  • Field (depSsn)
  • Key (Key2) — 외래 키 → Untitled4.Key — NOT NULL

Untitled4 (EMPLOEE)

  • Key — 기본 키 — NOT NULL
  • Field — int
  • Field2 (name)
  • Field2 (gender)
  • Field2 (address)
  • Field2 (salary)
  • Field2 (birthDate)
  • Field2 (department)
  • Field2 (supervisor)
  • Field2 (worksOn)
  • Field2 (project)
  • Field2 (hours)
  • Key (Key2) — 외래 키 → Untitled.Key — NOT NULL

Untitled5 (WORKS-ON)

  • Key — 기본 키 — NOT NULL
  • Field (ssn) — int
  • Field (projNo)
  • Field (hours)
  • Key (Key2) — 외래 키 → Untitled4.Key — NOT NULL