LIS_Practice

Tables (4)

DVD COPY (Untitled3)

  • Original code (Key) — Foreign key → DVD DB.Original code — NOT NULL
  • Original code (Key2) — Foreign key → MOVIE.Original code — NOT NULL
  • Original code (Key22) — Foreign key → MOVIE.Original code — NOT NULL
  • Date (Field)
  • score (Field2)

DVD DB (Untitled)

  • Original code (Key) — Primary key — NOT NULL
  • number (Field)
  • name (Field2)
  • adress (Field3)

MOVIE (Untitled4)

  • Original code (Key) — Foreign key → DVD DB.Original code — NOT NULL
  • Original code (Key2) — Foreign key → STORE.Original code — NOT NULL
  • title (Field)
  • production year (Field2)
  • actor (Field3)
  • producer (Field4)
  • biography (Field5)

STORE (Untitled2)

  • Original code (Key) — Foreign key → DVD DB.Original code — NOT NULL
  • data (Field)
  • hours (Field2)