ERD초안

테이블 (5)

DERAPTMENT (DEPARTMENT)

  • Key (deptNo) — Char(10) — 기본 키 — NOT NULL
  • Field (name) — Char(20)
  • Field (managerStartDate) — date
  • Field (locations) — Char(14)
  • Key (managerSsn) — Char(14) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROJECT)

  • Key (projNo) — Char(10) — 기본 키 — NOT NULL
  • Field (name) — Char(30)
  • Field (location) — Char(30)
  • Key (controllingDepartment) — Char(10) — 외래 키 → DERAPTMENT.Key — NOT NULL

Untitled (WORK-ON)

  • Key (ssn) — Char(14) — 외래 키 → Untitled.Key — NOT NULL
  • Key (projNo) — Char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (hours) — Char

Untitled (EMPLOYEE)

  • Key (ssn) — Char(14) — 기본 키 — NOT NULL
  • Field (name) — Char(20)
  • Field (rrn) — Char(14)
  • Field (address) — Char(30)
  • Field (salary) — Char(20)
  • Field (gender) — integer(1)
  • Field (birthDate) — Char(10)
  • Field (supervisor) — Char(10)
  • Key (deptNo) — Char(10) — 외래 키 → DERAPTMENT.Key — NOT NULL

Untitled (DEPENDENT)

  • Field (dependentName) — Char(20)
  • Field (gender) — integer(1)
  • Field (birthDate) — date
  • Field (relationship) — Char(20)
  • Field (parent) — Char(20)
  • Key (ssn(involved)) — Char(14) — 외래 키 → Untitled.Key — NOT NULL