문제1

테이블 (6)

Actor (Untitled5)

  • actorID (Key) — char(30) — 기본 키 — NOT NULL
  • actorBiography (Field) — text

CUSTOMER (Untitled)

  • custID (Key) — char(30) — 기본 키 — NOT NULL
  • custName (Field) — char(30)
  • custAddress (Field2) — char(30)

CUSTOMER_RENT_DVD (Untitled6)

  • custID (Key) — char(30) — 외래 키 → CUSTOMER.custID — NOT NULL
  • DVDID (Key2) — char(30) — 외래 키 → DVD.DVDID — NOT NULL
  • rentalDate (Field) — date

DVD (Untitled2)

  • DVDID (Key) — char(30) — 기본 키 — NOT NULL
  • copyID (Field) — char(30)
  • purchaseDate (Field2) — date
  • numberOfRental (Field3) — Int(10)

Director (Untitled4)

  • directorID (Key) — char(30) — 기본 키 — NOT NULL
  • directorBiography (Field) — text

MOVIE (Untitled3)

  • movieID (Key) — char(30) — 기본 키 — NOT NULL
  • movieName (Field) — char(30)
  • productionYear (Field2) — date
  • DVDID (Key2) — char(30) — 외래 키 → DVD.DVDID — NOT NULL
  • actorID (Key3) — char(30) — 외래 키 → Actor.actorID — NOT NULL
  • directorID (Key4) — char(30) — 외래 키 → Director.directorID — NOT NULL