ERD Exercise 6

Tables (5)

BOOK (Untitled)

  • ISBN (Key) — char(20) — Primary key — NOT NULL
  • name (Field) — char(10)
  • date (Field2) — char(8)
  • publisher (Field3) — char(10)

CONTRACT (Untitled5)

  • howMany (Key) — integer — Primary key — NOT NULL
  • ISBN (Key2) — char(20) — Foreign key → BOOK.ISBN — NOT NULL
  • limitDate (Field) — char(8)

PRINTSHOP (Untitled4)

  • Id (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(20)
  • ISBN (Key2) — char(20) — Foreign key → BOOK.ISBN — NOT NULL

PUBLISHER (Untitled2)

  • publisherID (Key) — char(10) — Primary key — NOT NULL
  • ISBN (Key2) — char(20) — Foreign key → BOOK.ISBN — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(20)

WRITER (Untitled3)

  • SSN (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(20)
  • ISBN (Key2) — char(20) — Foreign key → BOOK.ISBN — NOT NULL