ERD-04

Tables (7)

Untitled (CUSTOMER)

  • Key (customerID) — char(10) — Primary key — NOT NULL
  • Field (customerName) — char(10)
  • Field (cusromerAdd) — char(20)

Untitled (DVD_COPY)

  • Key (DVDcopyId) — int(10) — Primary key — NOT NULL
  • Field (DVDbuyDate) — date
  • Field (DVDlendDate) — date
  • Field (DVDlendCount) — int(5)
  • Key (DVDId) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (customerID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (DVDlendTime) — time

Untitled (DVD_INFO)

  • Key (DVDId) — char(8) — Primary key — NOT NULL
  • Field (DVDtitle) — char(30)
  • Field (DVDreleaseYear) — int(4)

Untitled (ACTORS)

  • Key (actorID) — char(10) — Primary key — NOT NULL
  • Field (actorDescription) — text

Untitled (DIRECTOR)

  • Key (directorID) — char(10) — Primary key — NOT NULL
  • Field (directorDescription) — text

Untitled (ACTOR_DVD)

  • Key (DVDId) — char(8) — Foreign key → Untitled.Key — NOT NULL
  • Key (actorID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (DIRECTOR_DVD)

  • Key (directorID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (DVDId) — char(8) — Foreign key → Untitled.Key — NOT NULL