ex_4

Tables (4)

CUSTOMERS (Untitled)

  • CustomerId (Key) — char(8) — Primary key — NOT NULL
  • DSId (Key2) — char(6) — Foreign key → DVD_STORE.DSId — NOT NULL
  • CustomerId (Key22) — char(8) — Foreign key → DVD_STORE.CustomerId — NOT NULL
  • DSId (Key222) — char(6) — Foreign key → DVD_STORE.DSId — NOT NULL
  • CustomerNumber (Field) — char(10)
  • CustomerName (Field2) — char(10)
  • CustomerAddress (Field3) — char(12)

DVD (Untitled2)

  • DVDId (Key) — char(4) — Primary key — NOT NULL
  • DSId (Key2) — char(6) — Foreign key → DVD_STORE.DSId — NOT NULL
  • CustomerId (Key23) — char(8) — Foreign key → DVD_STORE.CustomerId — NOT NULL
  • DSId (Key222) — char(6) — Foreign key → DVD_STORE.DSId — NOT NULL
  • DVDUniqueCode (Field) — char(8)
  • DVDDateofPurchase (Field2) — chr(8)
  • DVDNumberofTimes (Field3) — char(4)
  • SeveralCopies (Field4)
  • MovieId (Key3) — char(10) — Foreign key → MOVIE.MovieId — NOT NULL
  • DSId (Key22) — char(6) — Foreign key → MOVIE.DSId — NOT NULL
  • CustomerId (Key4) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
  • DSId (Key24) — char(6) — Foreign key → CUSTOMERS.DSId — NOT NULL
  • CustomerId (Key223) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
  • DSId (Key2222) — char(6) — Foreign key → CUSTOMERS.DSId — NOT NULL

DVD_STORE (Untitled4)

  • DSId (Key) — char(6) — Primary key — NOT NULL
  • CustomerId (Key2) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
  • DSId (Key22) — char(6) — Foreign key → CUSTOMERS.DSId — NOT NULL
  • DSUniqueId (Field) — char(6)
  • DSUniqueInternalCode (Field2) — char(10)
  • DSDifferentSet (Field3) — char(10)

MOVIE (Untitled3)

  • MovieId (Key) — char(10) — Primary key — NOT NULL
  • DSId (Key2) — char(6) — Foreign key → DVD_STORE.DSId — NOT NULL
  • CustomerId (Key23) — char(8) — Foreign key → DVD_STORE.CustomerId — NOT NULL
  • DSId (Key222) — char(6) — Foreign key → DVD_STORE.DSId — NOT NULL
  • MovieTitle (Field) — char(10)
  • MovieYearMade (Field2) — char(4)
  • ActorCode (Field3) — char(6)
  • DirectorCode (Field4) — char(6)
  • DVDId (Key3) — char(4) — Foreign key → DVD.DVDId — NOT NULL
  • DSId (Key22) — char(6) — Foreign key → DVD.DSId — NOT NULL