ERD Exercise 4

Tables (6)

ACTOR (Untitled5)

  • actorId (Key) — char(10) — Primary key — NOT NULL
  • actorBiography (Key2) — char(100) — NOT NULL

CUSTOMER (Untitled)

  • customerId (Key) — char(10) — Primary key — NOT NULL
  • customerName (Field) — char(20)
  • address (Field2) — char(50)

CUSTOMERDVD (Untitled6)

  • customerId (Key) — char(10) — Foreign key → CUSTOMER.customerId — NOT NULL
  • dvdName (Key2) — char(30) — Foreign key → DVDTitle.dvdName — NOT NULL
  • dvdId (Key22) — char(10) — Foreign key → DVDTitle.dvdId — NOT NULL
  • RentalDateTime (Field) — datetime

DIRECTOR (Untitled4)

  • directorId (Key) — char(10) — Primary key — NOT NULL
  • directorBiography (Field) — char(100)

DVDLIST (Untitled2)

  • dvdId (Key) — char(10) — Primary key — NOT NULL
  • purchase (Field)

DVDTitle (Untitled3)

  • dvdName (Key) — char(30) — Primary key — NOT NULL
  • dvdId (Key2) — char(10) — Foreign key → DVDLIST.dvdId — NOT NULL
  • YearOfManufacture (Field) — date
  • Field2
  • directorId (Key3) — char(10) — Foreign key → DIRECTOR.directorId — NOT NULL
  • actorId (Key4) — char(10) — Foreign key → ACTOR.actorId — NOT NULL