2023_SLI_EX6

Tables (6)

BOOK

  • ISBN — char(30) — Primary key — NOT NULL
  • Key (pubID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • title — char(50)
  • Field2 (publicationDate) — date

Untitled (PUBLISHING HOUSE)

  • Key (pubID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)

Untitled (ENROLL)

  • Key (publisher ID) — char(30) — Foreign key → Untitled2.Key — NOT NULL
  • ISBN — char(30) — Foreign key → BOOK.ISBN — NOT NULL
  • Key (pubID) — char(10) — Foreign key → BOOK.Key — NOT NULL

Untitled (CONTRACT)

  • Key (contratID) — char(10) — Primary key — NOT NULL
  • Field (number of books) — int(10000)
  • Field (print Deadline) — date
  • ISBN — char(30) — Foreign key → BOOK.ISBN — NOT NULL
  • Key (pubID) — char(10) — Foreign key → BOOK.Key — NOT NULL
  • Key (bookpinterID) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (BOOK PRINTER)

  • Key (bookpinterID) — char(20) — Primary key — NOT NULL
  • Field (title) — char(20)
  • Field (address) — char(50)

Untitled2 (PUBLISHER)

  • Key (publisher ID) — char(30) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)