1

Tables (6)

BOOK (Untitled2)

  • ID (PK) — CHAR(20) — Primary key — NOT NULL
  • ISBN (FK) — NUMBER — Primary key — NOT NULL
  • M_ID (FK1) — Foreign key → RENTAL.M_ID — NOT NULL
  • B_ID (FK2) — Foreign key → RENTAL.B_ID — NOT NULL
  • RENT_DATE (Key) — DATE — Foreign key → RENTAL.RENT_DATE — NOT NULL
  • ID (PK2) — CHAR(20) — Foreign key → RENTAL.ID — NOT NULL
  • M_ID (FK12) — Foreign key → RESERVE.M_ID — NOT NULL
  • B_ID (FK22) — Foreign key → RESERVE.B_ID — NOT NULL
  • AVAILABLE (Field) — NUMBER

BOOKINFO (Untitled5)

  • ISBN (PK) — NUMBER — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(20)
  • AUTHOR (Field2) — VARCHAR(10)
  • PUBLISHER (Field3) — VARCHAR(10)
  • RECEIVE_DATE (Field4) — DATE

BOOKLOCATION (Untitled6)

  • ISBN (FK) — NUMBER — Primary key — NOT NULL
  • LOCATION (Key) — VARCHAR(20) — Primary key — NOT NULL

MEMBER (Untitled)

  • ID (PK) — CHAR(20) — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(10)
  • PHONENUMBER (Field2) — NUMBER
  • BIRTH_DATE (Field3) — DATE
  • REGISTER_DATE (Field4) — DATE

RENTAL (Untitled3)

  • M_ID (FK1) — Primary key — NOT NULL
  • B_ID (FK2) — Primary key — NOT NULL
  • RENT_DATE (Key) — DATE — Primary key — NOT NULL
  • ID (PK) — CHAR(20) — Foreign key → MEMBER.ID — NOT NULL
  • RETURN_DATE (Field2) — DATE

RESERVE (Untitled4)

  • M_ID (FK1) — Primary key — NOT NULL
  • B_ID (FK2) — Primary key — NOT NULL
  • RESERVEDATE (Field) — DATE
  • ID (PK) — CHAR(20) — Foreign key → MEMBER.ID — NOT NULL