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