ERD exercise 3(20200916)

Tables (6)

AUTHOR (Untitled3)

  • ssn (Key) — CHAR(20) — Primary key — NOT NULL
  • autName (Field) — CHAR(30)
  • address (Field2) — CHAR(50)

AUTHOR_BOOK (Untitled4)

  • ssn (Key) — CHAR(20) — Foreign key → AUTHOR.ssn — NOT NULL
  • ISBN (Key2) — CHAR(20) — Foreign key → BOOK.ISBN — NOT NULL

BOOK (Untitled)

  • ISBN (Key) — CHAR(20) — Primary key — NOT NULL
  • title (Field) — CHAR(30)
  • publicationDate (Field2) — date
  • pubID (Key2) — CHAR(20) — Foreign key → PUBLISHER.pubID — NOT NULL

PRINT (Untitled6)

  • printingID (Key) — CHAR(20) — Primary key — NOT NULL
  • bookQuantity (Field) — int
  • printingDeadline (Field2) — date
  • ISBN (Key2) — CHAR(20) — Foreign key → BOOK.ISBN — NOT NULL
  • priID (Key3) — CHAR(20) — Foreign key → PRINTER.priID — NOT NULL

PRINTER (Untitled5)

  • priID (Key) — CHAR(20) — Primary key — NOT NULL
  • priName (Field) — CHAR(30)
  • address (Field2) — CHAR(50)

PUBLISHER (Untitled2)

  • pubID (Key) — CHAR(20) — Primary key — NOT NULL
  • pubName (Field) — CHAR(30)
  • address (Field2) — CHAR(50)