Q6
Tables (6)
StarActor
- Key (starName) — Primary key — NOT NULL
- Field (birthName) — Date
- Field (DOB)
Untitled (ClubMember)
- Key (memberShipNo) — Primary key — NOT NULL
- Field (firstName)
- Field (latName) — phone
- Field (address)
- Field (currentRentDate)
- Field (currentCredit)
Untitled (Tape)
- Key (tapeNo) — Primary key — NOT NULL
- Field (tapeFormat)
- Key (movieID) — Foreign key → Untitled.Key — NOT NULL
Untitled (Movie)
- Key (movieID) — Primary key — NOT NULL
- Field (title)
- Field (category)
Untitled
- Key (memberShipNo) — Foreign key → Untitled.Key — NOT NULL
- Key (tapeNo) — Foreign key → Untitled.Key — NOT NULL
Untitled2 (Star_In)
- Key (movieID) — Foreign key → Untitled.Key — NOT NULL
- Key (starName) — Foreign key → StarActor.Key — NOT NULL