ERD Exercise 6

Tables (5)

AUTHOR (Untitled3)

  • SSN (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(15)
  • address (Field2) — char(30)
  • ISBN (Key2) — CHAR(13) — Foreign key → BOOK.ISBN — NOT NULL
  • publisherID (Key22) — char(15) — Foreign key → BOOK.publisherID — NOT NULL

BOOK (Untitled)

  • ISBN (Key) — CHAR(13) — Primary key — NOT NULL
  • publisherID (Key2) — char(15) — Foreign key → PUBLISHER.publisherID — NOT NULL
  • SSN (Key3) — char(13) — Foreign key → AUTHOR.SSN — NOT NULL
  • title (Field) — char(20)
  • publisher (Field2) — char(15)
  • publicationDate (Field3) — char(8)
  • printerID (Key4) — char(13) — Foreign key → PRINTER.printerID — NOT NULL

CONTRACT (Untitled5)

  • printerID (Key) — char(13) — Foreign key → PRINTER.printerID — NOT NULL
  • numberofbooks (Field) — char(15)
  • printingdeadline (Field2) — char(10)
  • publisherID (Key2) — char(15) — Foreign key → PUBLISHER.publisherID — NOT NULL

PRINTER (Untitled4)

  • printerID (Key) — char(13) — Primary key — NOT NULL
  • address (Field2) — char(30)
  • ISBN (Key2) — CHAR(13) — Foreign key → BOOK.ISBN — NOT NULL
  • publisherID (Key22) — char(15) — Foreign key → BOOK.publisherID — NOT NULL

PUBLISHER (Untitled2)

  • publisherID (Key) — char(15) — Primary key — NOT NULL
  • name (Field) — char(15)
  • address (Field2) — char(30)