연습4

테이블 (5)

Untitled (DVD RENTAL SHOP)

  • Key (serial number) — int — 기본 키 — NOT NULL
  • Field (name)
  • Field2 (address) — char(30)

Untitled (DUPILCATE)

  • Key (serial number) — 기본 키 — NOT NULL
  • Field (tittle) — int
  • Field2 (date of produced)

Untitled (DVD)

  • Key (serial number) — char(50) — 기본 키 — NOT NULL
  • Field (Number of borrowings) — int

Untitled (RENTAL)

  • Key (date) — 기본 키 — NOT NULL
  • Field (time) — int
  • Field2 (amount) — char(30)

Untitled (CLASSIFICATION)

  • Key (actor) — int — 기본 키 — NOT NULL
  • Field (movie director) — char(20)