2025_2 예제 3

테이블 (5)

Untitled (CLIENT_SERVICE)

  • Key (cliSSN) — 외래 키 → Untitled.Key — NOT NULL
  • Key (serCode) — 외래 키 → Untitled.Key — NOT NULL
  • Key (proID) — 외래 키 → Untitled.Key — NOT NULL
  • Field (date)

Untitled (CLIENT)

  • Key (cliSSN) — 기본 키 — NOT NULL
  • Field (name)
  • Field (address)
  • Field (phone)

Untitled (DEPENDENT)

  • Key (depSSN) — 기본 키 — NOT NULL
  • Field (name)
  • Field (age)
  • Key (cliSSN) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SERVICE)

  • Key (serCode) — 기본 키 — NOT NULL
  • Field (description)
  • Key (proID) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROVIDER)

  • Key (proID) — 기본 키 — NOT NULL
  • Field (name)
  • Field (address)
  • Field (phone)