연습문제3

테이블 (5)

Untitled (CLIENT)

  • Key (CLIID) — CHAR(10) — 기본 키 — NOT NULL
  • Field (Name) — CHAR(10)
  • Field (Address) — CHAR(20)
  • Field (PhoneNumber) — CHAR(20)
  • Field (Age) — CHAR(3)

Untitled (DEPENDENT)

  • Key (DEPID) — CHAR(10) — 기본 키 — NOT NULL
  • Field (Name) — CHAR(10)
  • Field (Address) — CHAR(20)
  • Field (Age) — CHAR(3)
  • Field (Gender) — CHAR(2)
  • Key (CUSID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SERVICE)

  • Key (SERID) — CHAR(10) — 기본 키 — NOT NULL
  • Field (Explain) — CHAR(40)

Untitled (CUS-SER)

  • Key (SERID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (CLIID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (ServiceDate) — DATE
  • Field (ServiceTime) — INT(20)
  • Key (PROID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROVIDER)

  • Key (PROID) — CHAR(10) — 기본 키 — NOT NULL
  • Field (Name) — CHAR(10)
  • Field (Address) — CHAR(20)
  • Field (PhoneNumber) — CHAR(20)