Ex3

Tables (4)

Untitled (DVD)

  • Key (dvdCode) — char(10) — Primary key — NOT NULL
  • Field (dvdCopyCode) — char(10)
  • Field (dvdTitle) — char(20)
  • Field (dvdRentDate) — date
  • Field (dvdRentTime) — int
  • Field

Untitled (Customer)

  • Key (CusID) — char(10) — Primary key — NOT NULL
  • Field (CusName) — char(20)
  • Field (cusAddress) — char(30)
  • Field (cusPhone) — char(12)

Untitled (Rent)

  • Key (dvdCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (CusID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Movie)

  • Key (MovCode) — char(20) — Primary key — NOT NULL
  • Field (movTitle) — char(20)
  • Field