ERD_Exercise_4
Tables (6)
Untitled (customer)
- Key (customerNo) — Char — Primary key — NOT NULL
- Field (name) — Char
- Field (address) — Text
Untitled (dvd)
- Key (dvdCode) — Char — Primary key — NOT NULL
- Field (dvdDate) — Date
- Field (rentNo) — Int
- Key (MoveNo) — Char — Foreign key → Untitled.Key — NOT NULL
Untitled (Rent)
- Key (customerNo) — Char — Foreign key → Untitled.Key — NOT NULL
- Key (dvdCode) — Char — Foreign key → Untitled.Key — NOT NULL
- Field (rentDate) — Date
Untitled (move)
- Key (MoveNo) — Char — Primary key — NOT NULL
- Field (Title) — Char
- Field (yearMade) — Date
- Key (actorCode) — Char — Foreign key → Untitled.Key — NOT NULL
- Key (directorCode) — Char — Foreign key → Untitled.Key — NOT NULL
Untitled (actor)
- Key (actorCode) — Char — Primary key — NOT NULL
- Field (Name) — Char
Untitled (director)
- Key (directorCode) — Char — Primary key — NOT NULL
- Field (name) — Char