ex6

Tables (5)

AUTHOR (Untitled3)

  • authorName (Key) — Primary key — NOT NULL
  • authorSecurityNumber (Field)
  • authorAddress (Field3)

BOOK (Untitled)

  • ISBN (Key) — Primary key — NOT NULL
  • publisherId (Key3) — Foreign key → PUBLISHER.publisherId — NOT NULL
  • bookTitle (Field)
  • bookPublicationDate (Field2) — date
  • bookInformation (Field3)
  • authorName (Key2) — Foreign key → AUTHOR.authorName — NOT NULL

CONTRACT (Untitled5)

  • contractInformation (Key6) — Primary key — NOT NULL
  • printing book number (Field)
  • printing deadline (Field2)
  • ISBN (Key) — Foreign key → BOOK.ISBN — NOT NULL
  • printerId (Key2) — Foreign key → PRINTER.printerId — NOT NULL
  • publisherId (Key3) — Foreign key → BOOK.publisherId — NOT NULL
  • printeerName (Key4) — Foreign key → PRINTER.printeerName — NOT NULL
  • printerAddress (Key5) — Foreign key → PRINTER.printerAddress — NOT NULL

PRINTER (Untitled4)

  • printerId (Key) — Primary key — NOT NULL
  • printeerName (Key4) — Primary key — NOT NULL
  • printerAddress (Key5) — Primary key — NOT NULL
  • ISBN (Key2) — Foreign key → BOOK.ISBN — NOT NULL
  • publisherId (Key3) — Foreign key → BOOK.publisherId — NOT NULL

PUBLISHER (Untitled2)

  • publisherId (Key) — Primary key — NOT NULL
  • publisherName (Field)
  • publisherAddress (Field2)