exercise6

Tables (5)

aurthor (Untitled3)

  • au id (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)

book (Untitled)

  • isbn (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → publisher.id — NOT NULL
  • au id (Key3) — Foreign key → aurthor.au id — NOT NULL
  • title (Field)
  • publicationdate (Field2)

contract (Untitled5)

  • prinid (Key) — Foreign key → printer.prinid — NOT NULL
  • isbn (Key2) — Foreign key → book.isbn — NOT NULL
  • id (Key22) — Foreign key → book.id — NOT NULL
  • au id (Key3) — Foreign key → book.au id — NOT NULL
  • booknumber (Field)
  • deadline (Field2)

printer (Untitled4)

  • prinid (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)
  • booknumber (Field3)
  • deadline (Field4)

publisher (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)