ERD 연습문제 4

테이블 (8)

Untitled (customer_dvd)

  • Key (cCode) — char(10) — 외래 키 → customer.Key — NOT NULL
  • Key (dCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (lentDate) — date
  • Field (lentTime) — char(10)

Untitled (movie)

  • Key (mCode) — char(10) — 기본 키 — NOT NULL
  • Field (mName) — char(20)
  • Field (mMadeDate) — date
  • Field (mScore) — int(2)
  • Key (alCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (dCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (dvd)

  • Key (dCode) — char(10) — 기본 키 — NOT NULL
  • Field (dBuyDate) — date
  • Field (dNum) — int(5)
  • Field (dLentNum) — int(5)
  • Field
  • Key (mCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (actor)

  • Key (aCode) — char(10) — 기본 키 — NOT NULL
  • Field (aName) — char(10)
  • Field (aBirth) — date
  • Field (aBiograpy) — text
  • Key (alCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (actorList)

  • Key (alCode) — char(10) — 기본 키 — NOT NULL

Untitled (director)

  • Key (dCode) — char(10) — 기본 키 — NOT NULL
  • Field (dName) — char(10)
  • Field (dBiography) — text

Untitled (actorList_actor)

    customer

    • Key (cCode) — char(10) — 기본 키 — NOT NULL
    • Field (cName) — char(5)
    • Field (cAddress) — char(20)
    • Field (cCell) — int(15)