final

Tables (3)

Author (Untitled2)

  • name (Key) — char(15) — Primary key — NOT NULL
  • ISBN (Key2) — int(13) — Foreign key → Book.ISBN — NOT NULL
  • majorWork (Field) — char(30)

Book (Untitled)

  • ISBN (Key) — int(13) — Primary key — NOT NULL
  • id (Key2) — char(10) — Foreign key → Publisher.id — NOT NULL
  • name (Key3) — char(15) — Foreign key → Author.name — NOT NULL
  • bookTitle (Field) — char(20)
  • bookNo (Field3) — int(9)
  • publishDate (Field2) — int(8)

Publisher (Untitled3)

  • id (Key) — char(10) — Primary key — NOT NULL
  • ISBN (Key2) — int(13) — Foreign key → Book.ISBN — NOT NULL
  • address (Field) — char(10)
  • Field2