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