E4

Tables (9)

Copy Of Untitled (director_biography)

  • Key (mID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (dID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (customer)

  • Key (cID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)
  • Field (phone) — char(11)

Untitled (DVD)

  • Key (dID) — char(10) — Primary key — NOT NULL
  • Field (pDate) — date
  • Field (rentedNum) — int(5)
  • Key (gno) — char(2) — Foreign key → Untitled.Key — NOT NULL
  • Key (mID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (genre)

  • Key (gno) — char(2) — Primary key — NOT NULL
  • Field (gName) — char(20)

Untitled (movie)

  • Key (mID) — char(10) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field (madeyear) — char(4)
  • Field (quantity) — int(2)

Untitled (actor)

  • Key (aID) — char(10) — Primary key — NOT NULL
  • Field (aName) — char(30)

Untitled (director)

  • Key (dID) — char(10) — Primary key — NOT NULL
  • Field (dName) — char(30)

Untitled (rent)

  • Field (rDatetime) — datetime
  • Key (cID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (dID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (actor_biography)

  • Key (mID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (aID) — char(10) — Foreign key → Untitled.Key — NOT NULL