ERD Exercise_6

Tables (13)

Untitled (Book)

  • Key (ISBN) — integer(20) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (Publishing_date) — interger(8)
  • Field (Publisher_name) — char(30)
  • Field (Author_name) — char(30)
  • Key (Publisher_ID) — integer(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (KDC) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Publisher)

  • Key (Publisher_ID) — integer(20) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)

Untitled (Author)

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

Untitled (Print)

  • Key (print_ID) — integer(20) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)

Untitled (Contract)

  • Key (contractNO) — char(100) — Primary key — NOT NULL
  • Field (printing_number) — int(20)
  • Field (print_date) — int(20)
  • Key (ISBN) — integer(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (print_ID) — integer(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (Book_Author)

  • Key (ISBN) — integer(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (ssn) — integer(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (role) — char(30)

Untitled (KDC)

  • Key (Code) — int(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (dexcription) — text

Untitled (Subject)

  • Key (subID) — char(30) — Primary key — NOT NULL
  • Field (subjectHeading) — char(30)
  • Field (description) — text

Untitled (Book_Subject)

  • Key (ISBN) — integer(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (subID) — char(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (Event)

  • Key (eventID) — char(30) — Primary key — NOT NULL
  • Field (eventname) — char(30)
  • Field (description) — text

Untitled (Book_Event)

  • Key (ISBN) — integer(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (eventID) — char(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (Person)

  • Key (PersonID) — char(30) — Primary key — NOT NULL
  • Field (Personname) — char(30)
  • Field (description) — text

Untitled (Book_Person)

  • Key (ISBN) — integer(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (PersonID) — char(30) — Foreign key → Untitled.Key — NOT NULL