ERD 4

Tables (4)

ENROLL (Untitled4)

  • identification code (Key) — integer — Primary key — NOT NULL
  • rental time (Field) — int(11)
  • rental date (Field2) — int(11)
  • customer numbe (Key2) — char(13) — Foreign key → customer.customer numbe — NOT NULL
  • identification code (Key3) — integer — Foreign key → videocassette.identification code — NOT NULL

customer (Untitled)

  • customer numbe (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(100)
  • phone (Field3) — int(11)
  • email (Field4) — char(100)
  • video store ID (Key2) — int(11) — Foreign key → video store.video store ID — NOT NULL

video store (Untitled3)

  • video store ID (Key) — int(11) — Primary key — NOT NULL
  • name (Field) — char(10)
  • videocassette (Field2) — char(10)

videocassette (Untitled2)

  • identification code (Key) — integer — Primary key — NOT NULL
  • date of purchase (Field) — int(11)
  • number of times the video was rented (Field2) — int(11)
  • title (Field3) — char(10)
  • the year made (Field4) — int(11)
  • actors (Field5) — char(10)
  • directors (Field6) — char(10)
  • video store ID (Key2) — int(11) — Foreign key → video store.video store ID — NOT NULL