ERD exercise 4
Tables (8)
Untitled (CUSTOMER)
- Key (cusID) — char(15) — Primary key — NOT NULL
- Field (cusName) — char(20)
- Field (address) — char(70)
Untitled (VIDEO)
- Key (videoID) — char(15) — Primary key — NOT NULL
- Field (copyID) — char(15)
- Field (purchaseDate) — date
- Field (timesRanted) — char(20)
- Key (movieID) — char(15) — Foreign key → Untitled.Key — NOT NULL
Untitled (MOVIE)
- Key (movieID) — char(15) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (yearMade) — int(4)
Untitled (ACTOR)
- Key (actorID) — char(15) — Primary key — NOT NULL
- Field (actorName) — char(20)
- Field (actorBiography) — text
Untitled (DIRECTOR)
- Key (dirID) — char(15) — Primary key — NOT NULL
- Field (dirName) — char(20)
- Field (dirBiography) — text
Untitled (RENTAL)
- Key (rentalID) — char(15) — Primary key — NOT NULL
- Field (rentalDate) — date
- Field (rentalTime)
- Key (cusID) — char(15) — Foreign key → Untitled.Key — NOT NULL
- Key (videoID) — char(15) — Foreign key → Untitled.Key — NOT NULL
Untitled (ACTOR_MOVIE)
- Key (actorID) — char(15) — Foreign key → Untitled.Key — NOT NULL
- Key (movieID) — char(15) — Foreign key → Untitled.Key — NOT NULL
Untitled (DIRECTOR_MOVIE)
- Key (dirID) — char(15) — Foreign key → Untitled.Key — NOT NULL
- Key (movieID) — char(15) — Foreign key → Untitled.Key — NOT NULL