exam

Tables (4)

BOOK INFORMATION

  • Key (ISBN) — char(30) — Primary key — NOT NULL
  • Field (bname) — char(30)
  • Field (publication date) — date
  • Field (author) — char(40)
  • Field (category number) — char(30)

Untitled (PUBLISHING COMPANY)

  • Key (pID) — char(30) — Primary key — NOT NULL
  • Key (ISBN) — char(30) — Foreign key → BOOK INFORMATION.Key — NOT NULL
  • Field (pname) — char(30)
  • Field (paddress) — char(30)

Untitled (AUTHOR)

  • Key (IDnumber) — char(40) — Primary key — NOT NULL
  • Field (aname) — char(40)
  • Field (aaddress) — char(40)
  • Key (ISBN) — char(30) — Foreign key → BOOK INFORMATION.Key — NOT NULL

Untitled (TOPIC)

  • Key (KDCnumber) — char(30) — Primary key — NOT NULL
  • Key (ISBN) — char(30) — Foreign key → BOOK INFORMATION.Key — NOT NULL
  • Field (keyword) — char(30)
  • Field (relevant people) — char(30)
  • Field (relevant event) — char(30)