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