ERD EXCERCISE 6

Tables (6)

BOOK

  • Key (isbn NO) — integer(30) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field (publicatDate) — date
  • Field (price) — char(20)
  • Field (language) — char(10)
  • Key (publisherID) — integer — Foreign key → Untitled.Key — NOT NULL

Untitled (PUBLISHER)

  • Key (publisherID) — integer — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)
  • Field (phone) — char(20)
  • Field (email) — char(30)
  • Field (fax) — char(20)
  • Field (description) — text

Untitled (AUTHOR)

  • Key (authorNO) — integer — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (ssn) — integer
  • Field (address) — char(50)
  • Field (phone) — char(10)
  • Field (e-mail) — char(50)
  • Field (description) — text

Untitled (CONTRACT)

  • Key (isbn NO) — integer(30) — Foreign key → BOOK.Key — NOT NULL
  • Key (pressID) — integer — Foreign key → Untitled.Key — NOT NULL
  • Field (copyNO) — char(10)
  • Field (date) — date
  • Field (description) — text

Untitled (BOOK-AUTHOR)

  • Key (book-authorNO) — integer — Primary key — NOT NULL
  • Key (isbn NO) — integer(30) — Foreign key → BOOK.Key — NOT NULL
  • Key (authorNO2) — integer — Foreign key → Untitled.Key — NOT NULL

Untitled (PRESS)

  • Key (pressID) — integer — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(50)
  • Field (e-mail) — char(50)
  • Field (phone) — char(10)
  • Field (fax) — char(20)
  • Field (description) — text