[다시]ERD 연습문제 4

테이블 (6)

Untitled (dependent)

  • Key (did) — int(5) — 기본 키 — NOT NULL
  • Field (dname) — char(20)
  • Field (dage) — int(3)
  • Field (dgender) — char(10)
  • Key (ssn2) — int(5) — 외래 키 → customer.Key — NOT NULL

Untitled (belong)

  • Key (bcode) — char(20) — 기본 키 — NOT NULL
  • Field (btype) — char(20)
  • Field (bname) — char(20)

Untitled (server)

  • Key (scode) — char(20) — 기본 키 — NOT NULL
  • Field (sname) — char(20)
  • Field (saddress) — char(20)
  • Field (sphone) — int(11)
  • Key (secode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (bcode) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (service)

  • Key (secode) — char(20) — 기본 키 — NOT NULL
  • Field (sename) — char(20)
  • Field (sedescription) — text
  • Field (seGiveDate) — date

Untitled (customer_server)

  • Key (secode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (scode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (seGiveDate) — date

customer

  • Key (cid) — int(5) — 기본 키 — NOT NULL
  • Field (cname) — char(20)
  • Field (caddress) — char(20)
  • Field (cphone) — int(15)
  • Field (cage) — int(3)
  • Field