ERD EXCERCISE 4
Tables (9)
Untitled (CUSTOMER)
- Key (custNO) — integer — Primary key — NOT NULL
- Field
Untitled (dvd)
- Key (dvdid) — integer — Primary key — NOT NULL
- Field
- Key (id2) — in — Foreign key → Untitled.Key — NOT NULL
Untitled (dvd-copy)
- Key (id) — int — Primary key — NOT NULL
- Field
- Key (dvdid) — integer — Foreign key → Untitled.Key — NOT NULL
Untitled (movie title)
- Key (id) — in — Primary key — NOT NULL
- Field
Untitled (actor)
- Key (id) — int — Primary key — NOT NULL
- Field
Untitled (diecter)
- Key (id) — int — Primary key — NOT NULL
- Field
Untitled (customer rental)
- Key (custNO) — integer — Foreign key → Untitled.Key — NOT NULL
- Key (id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (title-actor)
- Key (id) — in — Foreign key → Untitled.Key — NOT NULL
- Key (id2) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (title-director)
- Key (id) — in — Foreign key → Untitled.Key — NOT NULL
- Key (id2) — int — Foreign key → Untitled.Key — NOT NULL