ERD 6

Tables (4)

author (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • name (Field)
  • adress (Field2)
  • ISBN (Key2) — Foreign key → book.ISBN — NOT NULL
  • ISBN (Key3) — Foreign key → book.ISBN — NOT NULL
  • ID (Key4) — Foreign key → publisher.ID — NOT NULL

book (Untitled)

  • ISBN (Key) — Primary key — NOT NULL
  • Signature (Field)
  • date of publication (Field2)
  • publisher (Field3)
  • author (Field4)

print shop (Untitled4)

  • ID (Key) — Primary key — NOT NULL
  • name (Field)
  • adress (Field2)
  • Contract information (Field3)
  • ISBN (Key2) — Foreign key → book.ISBN — NOT NULL

publisher (Untitled2)

  • ID (Key) — Primary key — NOT NULL
  • name (Field)
  • Address (Field2)
  • author (Field3)
  • ISBN (Key2) — Foreign key → book.ISBN — NOT NULL