ERD 연습문제 3

테이블 (5)

Customer

  • Key (cSsn) — char(30) — 기본 키 — NOT NULL
  • Field (cName) — char(5)
  • Field (cAddress) — char(20)
  • Field (cPhone) — char(15)

Untitled (Family)

  • Key (fSsn) — char(30) — 기본 키 — NOT NULL
  • Field (fName) — char(5)
  • Field (fAddress) — char(20)
  • Field (fPhone) — char(15)
  • Field (fAge) — integer(3)
  • Key (cSsn) — char(30) — 외래 키 → Customer.Key — NOT NULL

Untitled (Service)

  • Key (sCode) — char(20) — 기본 키 — NOT NULL
  • Field (sDescription) — text
  • Field (sName) — char(30)

Untitled (ServiceProvider)

  • Key (spNo) — char(30) — 기본 키 — NOT NULL
  • Field (spName) — char(5)
  • Field (spAddress) — char(20)
  • Field (spPhone) — char(15)
  • Key (sCode) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Customer_Service)

  • Key (cSsn) — char(30) — 외래 키 → Customer.Key — NOT NULL
  • Key (sCode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (servicedate) — date
  • Key (spNo) — char(30) — 외래 키 → Untitled.Key — NOT NULL