2021-10-11-q4

Tables (5)

Actor (tb_actor)

  • Actor Code (actor_id) — Primary key — NOT NULL
  • DVD Code (dvd_id) — Foreign key → DVD.DVD Code — NOT NULL

Customer (tb_customer)

  • Customer Number (customer_id) — Primary key — NOT NULL
  • Name (customer_name)
  • Address (customer_addr)

DVD (tb_dvd)

  • DVD Code (dvd_id) — Primary key — NOT NULL
  • Purchase Date (dvd_date)
  • Rent Counter (dvd_count)
  • Title (dvd_title)
  • Release Date (dvd_year)
  • Customer Number (customer_id) — Foreign key → Transaction.Customer Number — NOT NULL

Director (tb_director)

  • Director Code (director_id) — Primary key — NOT NULL
  • DVD Code (dvd_id) — Foreign key → DVD.DVD Code — NOT NULL

Transaction (tb_transaction)

  • Customer Number (customer_id) — Foreign key → Customer.Customer Number — NOT NULL
  • Rent Date (transaction_date)
  • Rent Time (transaction_time)