ERD Exercise4(여영규)

테이블 (6)

ACTOR (배우)

  • actorCode (Key) — char(10) — 기본 키 — NOT NULL
  • moviesID (Key2) — char(10) — 외래 키 → MOVIES.moviesID — NOT NULL
  • actorName (Field) — char(10)

CUSTOMERS (고객)

  • customerID (Key) — char(10) — 기본 키 — NOT NULL
  • customerName (Field) — char(20)
  • customerAddress (Field2) — char(50)

DIRECTOR (감독)

  • directorCode (Key) — char(10) — 기본 키 — NOT NULL
  • moviesID (Key2) — char(10) — 외래 키 → MOVIES.moviesID — NOT NULL
  • directorName (Field) — char(20)

DVD

  • dvdCode (Key) — char(10) — 기본 키 — NOT NULL
  • dvdCopycode (Field) — char(10)
  • dvdPurchaseDate (Field2) — date
  • dvdRendtimes (Field3) — char(5)
  • moviesID (Key2) — char(10) — 외래 키 → MOVIES.moviesID — NOT NULL

MOVIES (영화)

  • moviesID (Key) — char(10) — 기본 키 — NOT NULL
  • moviesTitle (Field) — char(20)
  • moviesYearmade (Field2) — date

RENTVIDEO (비디오대여)

  • rentvideoCode (Key) — char(10) — 기본 키 — NOT NULL
  • rentDate (Field) — date
  • rentTime (Field2) — char(10)
  • rendDVDCode (Field3) — char(10)
  • customerID (Key2) — char(10) — 외래 키 → CUSTOMERS.customerID — NOT NULL
  • dvdCode (Key3) — char(10) — 외래 키 → DVD.dvdCode — NOT NULL