EXERCISE 5
Tables (8)
ACTOR (Untitled8)
- actorId (Key) — CHAR(30) — Primary key — NOT NULL
- fname (Field) — CHAR(30)
- mname (Field5) — CHAR(30)
- lname (Field2) — CHAR(30)
- actorSsn (Field3) — CHAR(30)
- biography (Field4) — CHAR(30)
BORROW (Untitled2)
- rentCode (Key3) — CHAR(10) — Primary key — NOT NULL
- customerId (Key) — CHAR(30) — Foreign key → CUSTOMER.customerId — NOT NULL
- dvdId (Key2) — CHAR(30) — Foreign key → DVD.dvdId — NOT NULL
- date (Field2) — date
- time (Field) — time
- returned (Field3) — int(1)
CUSTOMER (Untitled)
- customerId (Key) — CHAR(30) — Primary key — NOT NULL
- ssn (Field) — CHAR(30)
- fname (Field2) — CHAR(20)
- lname (Field5) — CHAR(20)
- gender (Field3) — CHAR(10)
- address (Field4) — CHAR(30)
- phone (Field6) — CHAR(20)
- bday (Field7) — date
- age (Field8) — CHAR(10)
DIRECTOR (Untitled9)
- directorId (Key) — CHAR(30) — Primary key — NOT NULL
- fname (Field) — CHAR(30)
- mname (Field5) — CHAR(10)
- lname (Field2) — CHAR(30)
- directorSsn (Field3) — CHAR(30)
- biography (Field4) — CHAR(40)
DVD (Untitled3)
- dvdId (Key) — CHAR(30) — Primary key — NOT NULL
- purchaseDate (Field) — date
- borrowedNum (Field2) — int(4)
- movieId (Key2) — CHAR(30) — Foreign key → MOVIE.movieId — NOT NULL
MOVIE (Untitled5)
- movieId (Key) — CHAR(30) — Primary key — NOT NULL
- title (Field) — CHAR(30)
- releaseDate (Field3) — date
- genre (Field4) — CHAR(30)
- award (Field2) — CHAR(30)
MOVIE_ACTOR (Untitled7)
- movieId (Key) — CHAR(30) — Foreign key → MOVIE.movieId — NOT NULL
- actorId (Key2) — CHAR(30) — Foreign key → ACTOR.actorId — NOT NULL
MOVIE_DIRECTOR (Untitled6)
- movieId (Key) — CHAR(30) — Foreign key → MOVIE.movieId — NOT NULL
- directorId (Key2) — CHAR(30) — Foreign key → DIRECTOR.directorId — NOT NULL
- role (Field) — CHAR(30)