ERD exercise6_publish

Tables (6)

Untitled (BOOK)

  • Key (isbn) — CHAR(13) — Primary key — NOT NULL
  • Field (title) — CHAR(20)
  • Field (publishDate) — DATE
  • Key (publisherCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (PUBLISHER)

  • Key (publisherCode) — CHAR(10) — Primary key — NOT NULL
  • Field (publisherName) — CHAR(10)
  • Field (publisherAddress) — CHAR(30)

Untitled (AUTHOR)

  • Key (authorSsd) — CHAR(13) — Primary key — NOT NULL
  • Field (authorName) — CHAR(20)
  • Field (authorAddress) — CHAR(30)

Untitled (PRINTING)

  • Key (printingCode) — CHAR(10) — Primary key — NOT NULL
  • Field (printingName) — CHAR(10)
  • Field (printingAddress) — CHAR(30)

Untitled (PRINTINGCONTRACT)

  • Key (isbn) — CHAR(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (printingCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (numberOfBooks) — INT — NOT NULL
  • Key (printingEndDate) — DATE — NOT NULL

Untitled (WRITE)

  • Key (isbn) — CHAR(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (authorSsd) — CHAR(13) — Foreign key → Untitled.Key — NOT NULL