ERD Exercise 6

Tables (5)

Untitled (book)

  • Key (isbn) — Char(13) — Primary key — NOT NULL
  • Field (title) — Char
  • Field (publicationDate) — Date
  • Key (author(ssn)) — Char — Foreign key → Untitled.Key — NOT NULL
  • Key (publisherID) — Char — Foreign key → Untitled.Key — NOT NULL

Untitled (publisher)

  • Key (publisherID) — Char — Primary key — NOT NULL
  • Field (name) — Char
  • Field (address) — Char

Untitled (author)

  • Key (ssn) — Char — Primary key — NOT NULL
  • Field (name) — Char
  • Field (address) — Char

Untitled (printer)

  • Key (printerID) — Char — Primary key — NOT NULL
  • Field (name) — Char
  • Field (address) — Char

Untitled (printer_contract)

  • Key (printerID) — Char — Foreign key → Untitled.Key — NOT NULL
  • Key (isbn) — Char(13) — Foreign key → Untitled.Key — NOT NULL
  • Field (quantity) — Int
  • Field (endDate) — Date