ERD Exercise 4
Tables (10)
ACTOR (Untitled7)
- actorSSN (Key) — char(10) — Primary key — NOT NULL
- biography (Field) — char(40)
CUSTOMER (Untitled)
- customerID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(30)
CUSTOMER_DVD (Untitled9)
- customerID (Key) — char(10) — Foreign key → CUSTOMER.customerID — NOT NULL
- dvdCode (Key2) — char(10) — Foreign key → DVD.dvdCode — NOT NULL
DIRECTOR (Untitled6)
- directorSSN (Key) — char(10) — Primary key — NOT NULL
- biography (Field) — char(40)
- movieSSN (Key2) — char(10) — Foreign key → MOVIE.movieSSN — NOT NULL
DVD (Untitled2)
- dvdCode (Key) — char(10) — Primary key — NOT NULL
- buyDate (Field) — char(8)
- lendCount (Field2) — integer
- lendDate (Key2) — char(10) — Foreign key → STORE.lendDate — NOT NULL
DVD COPY (Untitled3)
- copyCode (Key) — char(10) — Primary key — NOT NULL
- dvdCode (Key2) — char(10) — Foreign key → DVD.dvdCode — NOT NULL
DVD_MOVIE (Untitled10)
- dvdCode (Key) — char(10) — Foreign key → DVD.dvdCode — NOT NULL
- movieSSN (Key2) — char(10) — Foreign key → MOVIE.movieSSN — NOT NULL
MOVIE (Untitled5)
- movieSSN (Key) — char(10) — Primary key — NOT NULL
- title (Field) — char(20)
- whenYear (Field2) — char(4)
MOVIE_ACTOR (Untitled8)
- movieSSN (Key) — char(10) — Foreign key → MOVIE.movieSSN — NOT NULL
- actorSSN (Key2) — char(10) — Foreign key → ACTOR.actorSSN — NOT NULL
STORE (Untitled4)
- lendDate (Key) — char(10) — Primary key — NOT NULL
- lendTime (Field) — char(10)