exe4

Tables (7)

DVD (Untitled3)

  • ID (Key) — int(10) — Primary key — NOT NULL
  • title (Field) — char(50)
  • year/m (Field2) — char(50)
  • copy no (Field5) — char(50)
  • ID (Key2) — int(10) — Foreign key → rents.ID — NOT NULL
  • movie (Field3) — char(50)

DVD COPY (Untitled6)

  • code (Key) — char(50) — Primary key — NOT NULL
  • title (Field) — char(50)
  • date/P (Field2) — char(50)
  • times/R (Field3) — char(50)
  • ID (Key2) — int(10) — Foreign key → DVD.ID — NOT NULL
  • ID (Key3) — int(10) — Foreign key → customer.ID — NOT NULL

actor (Untitled4)

  • name (Key) — char(20) — Primary key — NOT NULL
  • code (Field) — char(20)
  • biographic information (Field2) — text

customer (Untitled)

  • ID (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(50)
  • add (Field2) — char(50)
  • phone no (Field3) — intr(10)

director (Untitled5)

  • name (Key) — char(20) — Primary key — NOT NULL
  • code (Field) — char(20)
  • biographic information (Field2) — text

movie (Untitled7)

  • code (Key) — int(50) — Primary key — NOT NULL
  • title (Field) — char(50)
  • copies (Field2) — char(50)
  • actor (Field3) — char(50)
  • director (Field4) — char(50)
  • ID (Key2) — int(10) — Foreign key → DVD.ID — NOT NULL
  • name (Key3) — Foreign key → director.name — NOT NULL
  • name (Key4) — Foreign key → actor.name — NOT NULL

rents (Untitled2)

  • ID (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(50)
  • date/P (Field2) — char(50)
  • times/R (Field3) — char(50)
  • ID (Key2) — int(10) — Foreign key → customer.ID — NOT NULL