연습문제3

테이블 (6)

Untitled (DEPENDENT)

  • Key (dependents ssn) — char(30) — 기본 키 — NOT NULL
  • Key (social security number) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — char(30)
  • Field (age) — int
  • Field (client ssn) — char(30)

Untitled (SERVICE)

  • Key (service ID) — char(30) — 기본 키 — NOT NULL
  • Field (description) — char(255)

Untitled (CLIENT)

  • Key (social security number) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(40)
  • Field (phone number) — char(11)

Untitled (HELP)

  • Key (help ID) — char(30) — 기본 키 — NOT NULL
  • Key (social security number) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (provided ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROVIDED SERVICE)

  • Key (provided ID) — char(30) — 기본 키 — NOT NULL
  • Key (service ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (proviser ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SERVICE PROVIDER)

  • Key (proviser ID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(30)
  • Field (phone number) — char(11)