ERD Exercise 6

Tables (6)

Book (BOOK)

  • Key (ISBN) — int(13) — Primary key — NOT NULL
  • Field (Title) — char(50)
  • Field (publication) — date
  • Field (price) — int(10)
  • Key (publisherID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (PUBLICHER)

  • Key (publisherID) — int(10) — Primary key — NOT NULL
  • Field (name) — char(15)
  • Field (address) — char(50)
  • Field (phone) — int(13)

Untitled (AUTHOR)

  • Key (ssn) — int(13) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (address) — char(50)
  • Field (phone) — int(13)

Untitled (PRINTER)

  • Key (printerID) — int(13) — Primary key — NOT NULL
  • Field (printerName) — char(20)
  • Field (address) — char(50)
  • Field (phone) — int(13)

Untitled (CONTRACT)

  • Key (contractID) — int(13) — Primary key — NOT NULL
  • Field (amount) — int(6)
  • Field (deadline) — date
  • Key (printerID) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Field (remitid) — int(10)
  • Key (ISBN) — int(13) — Foreign key → Book.Key — NOT NULL

Untitled (BOOK_ITEM)

  • Key (ISBN) — int(13) — Foreign key → Book.Key — NOT NULL
  • Key (ssn) — int(13) — Foreign key → Untitled.Key — NOT NULL