Exercise 6

Tables (5)

Untitled (BOOK)

  • Key (isbn) — char(100) — Primary key — NOT NULL
  • Key (ssn) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — char(100)
  • Field (publication) — char(100)

Untitled (PUBLISHER)

  • Key (pubID) — char(5) — Primary key — NOT NULL
  • Field (name) — char(5)
  • Field (address) — char(5)
  • Key (isbn) — char(100) — Foreign key → Untitled.Key — NOT NULL
  • Key (ssn) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (AUTHOR)

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

Untitled (PRINTER)

  • Key (printID) — char(5) — Primary key — NOT NULL
  • Field (name) — char(5)
  • Field (address) — char(5)

Untitled (CONTRACT)

  • Key (pubID) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (printID) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (number) — integer
  • Field (deadline) — integer