ERD exercise4_DVD
Tables (8)
Untitled (Customer)
- Key (cusCode) — CHAR(10) — Primary key — NOT NULL
- Field (cusName) — CHAR(10)
- Field (cusAddress) — CHAR(20)
Untitled (DVD)
- Key (DVDCode) — CHAR(10) — Primary key — NOT NULL
- Field (purchaseDate) — DATE
- Field (rentedTime) — INT
- Key (DVDMovieCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (RENTAL)
- Key (rentalCode) — CHAR(10) — Primary key — NOT NULL
- Field (rentalDatetime) — DATE
- Key (rentalcusCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
- Key (rentalDVDCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (MOVIE)
- Key (movieCode) — CHAR(10) — Primary key — NOT NULL
- Field (movieTitle) — CHAR(10)
- Field (Year) — DATE
Untitled (ACTOR)
- Key (actorCode) — CHAR(10) — Primary key — NOT NULL
- Field (actorName) — CHAR(10)
- Field (actorBiography) — CHAR(30)
Untitled (DIRECTOR)
- Key (directorCode) — CHAR(10) — Primary key — NOT NULL
- Field (directorName) — CHAR(10)
- Field (directorBiography) — CHAR(30)
Untitled (STARRING)
- Key (movieCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
- Key (actorCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (PRODUCE)
- Key (movieCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
- Key (directorCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL