ERD 연습문제 4

테이블 (8)

Untitled (movie)

  • Key (mcode) — char(30) — 기본 키 — NOT NULL
  • Field (myear) — int(4)
  • Field (mname) — char(20)

Untitled (customer)

  • Key (ccode) — char(30) — 기본 키 — NOT NULL
  • Field (cname) — char(30)
  • Field (cphone) — int(15)
  • Field (caddress) — char(30)

Untitled (lentrecord)

  • Key (rcode) — char(30) — 기본 키 — NOT NULL
  • Field (rdate) — date
  • Field (rtime) — char(30)
  • Key (dcode) — char(30) — 외래 키 → dvd.Key — NOT NULL
  • Key (ccode) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (actor)

  • Key (acode) — char(30) — 기본 키 — NOT NULL
  • Field (aname) — char(30)
  • Field (agender) — char(10)

Untitled (actorlist)

  • Key (mcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (acode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (lnum) — int(100)

Untitled (director)

  • Key (dcode) — char(30) — 기본 키 — NOT NULL
  • Field (dname) — char(30)
  • Field (dgender) — char(2)

Untitled (directorlist)

  • Key (mcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (dcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL

dvd

  • Key (dcode) — char(30) — 기본 키 — NOT NULL
  • Field (dbuydate) — date
  • Field (dlentnum) — int(5)
  • Key (mcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL