ex

Tables (3)

BOOK (Untitled)

  • ISBN (Key) — char(13) — Primary key — NOT NULL
  • title (Field) — char(50)

MEMBER (Untitled2)

  • memberID (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(100)

RENT (Untitled3)

  • rentID (Key3) — int — Primary key — NOT NULL
  • ISBN (Key) — char(13) — Foreign key → BOOK.ISBN — NOT NULL
  • memberID (Key2) — char(13) — Foreign key → MEMBER.memberID — NOT NULL
  • returnDate (Field) — date