exercise4

Tables (5)

CUSTOMER (Untitled)

  • customerNo (Key) — char(5) — Primary key — NOT NULL
  • customerName (Field) — char(30)
  • customerAddress (Field2) — text

DVDRentalList (Untitled3)

  • rentallistNo (Key) — char(5) — Primary key — NOT NULL
  • rentalStartDate (Field) — date
  • rentalStartTime (Field2) — date
  • rentalReturnDate (Field3) — date
  • rentalReturnTime (Field4) — date
  • customerNo (Key2) — char(5) — Foreign key → CUSTOMER.customerNo — NOT NULL
  • dvdCode (Key3) — char(5) — Foreign key → DVDSTOCK.dvdCode — NOT NULL

DVDSTOCK (Untitled2)

  • dvdCode (Key) — char(5) — Primary key — NOT NULL
  • dvdPurchaseDate (Field) — date
  • dvdNumberofRentals (Field2) — char(5)
  • movieId (Key2) — char(6) — Foreign key → MOVIES.movieId — NOT NULL

MOVIES (Untitled4)

  • movieId (Key) — char(6) — Primary key — NOT NULL
  • movieTitle (Field) — char(30)
  • movieYearMade (Field2) — date

MovieAssociate (Untitled5)

  • associateId (Key) — char(5) — Primary key — NOT NULL
  • associateName (Field) — char(30)
  • biograph (Field2) — text
  • movieId (Key2) — char(6) — Foreign key → MOVIES.movieId — NOT NULL