excersie 4

Tables (7)

Actor (Untitled5)

  • Actor Name. (Key) — Primary key — NOT NULL
  • Movie Name (Key2) — Foreign key → Movie.Movie Name — NOT NULL
  • Actor Birth (Field)
  • Actor Age (Field2)
  • Actor Gender (Field3)
  • Actor Biography (Field4)

Customer (Untitled)

  • Customer No. ((PK)) — Primary key — NOT NULL
  • Customer Name. (Field)
  • Customer Address. (Field2)
  • Customer Phone no. (Field3)
  • Customer Gender (Field4)

DVD (Untitled3)

  • DVD Code (Key) — Primary key — NOT NULL
  • Customer No. ((PK)) — Foreign key → Customer.Customer No. — NOT NULL
  • DVD No (Field)
  • DVD IN Date (Field2)
  • DVD Rental (Field3)
  • DVD Movie ID (Field4)

DVD_Copy (Untitled4)

  • DVD_Copy ID (PK) — Primary key — NOT NULL
  • DVD Code (Key) — Foreign key → DVD.DVD Code — NOT NULL
  • Customer No. ((PK)) — Foreign key → DVD.Customer No. — NOT NULL
  • Rental Id (Key2) — Foreign key → Rental.Rental Id — NOT NULL
  • Customer No. ((PK)2) — Foreign key → Rental.Customer No. — NOT NULL
  • Customer no. (FK)
  • Rental State (Field2)

Director (Untitled7)

  • Director Name (Key) — Primary key — NOT NULL
  • Movie Name (Key2) — Foreign key → Movie.Movie Name — NOT NULL
  • Actor Name. (Key3) — Foreign key → Actor.Actor Name. — NOT NULL
  • Movie Name (Key22) — Foreign key → Actor.Movie Name — NOT NULL
  • Director Birth (Field)
  • Director Age (Field2)
  • Director Gender (Field3)
  • Director Biography (Field4)

Movie (Untitled2)

  • Movie Name (Key) — Primary key — NOT NULL
  • Movie Serial No. (Field)
  • Movie Actor (Field2)
  • Movie Director (Field3)
  • Movie BGM (Field4)
  • Movie Open date (Field5)

Rental (Untitled6)

  • Rental Id (Key) — Primary key — NOT NULL
  • Customer No. ((PK)) — Foreign key → Customer.Customer No. — NOT NULL
  • Rental Customer Name (Field)
  • Rental DVD copy (Field2)
  • Rental DVD (Field3)
  • Rental Date (Field4)
  • Return Date (Field5)