ex3

Tables (4)

Book

  • Key (ISBN) — char(20) — Primary key — NOT NULL
  • Field (title) — char(50)
  • Field (chulpan) — date
  • Field
  • Key (pID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Publisher)

  • Key (pID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(50)

Untitled (Writer)

  • Key (wID) — char(15) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(50)

Untitled (Book_Writer)

  • Key (ISBN) — char(20) — Foreign key → Book.Key — NOT NULL
  • Key (wID) — char(15) — Foreign key → Untitled.Key — NOT NULL