ex_6

Tables (6)

AUTHOR (Untitled2)

  • ss number (Key) — char(13) — Primary key — NOT NULL
  • ss namae (Field) — char(30)
  • address (Field2) — char(40)

B-A BRIDGE (Untitled3)

  • BA number (Key) — char(10) — Primary key — NOT NULL
  • isbn (Key2) — char(13) — Foreign key → BOOK.isbn — NOT NULL
  • ss number (Key3) — char(13) — Foreign key → AUTHOR.ss number — NOT NULL

BOOK (Untitled)

  • isbn (Key) — char(13) — Primary key — NOT NULL
  • title (Field) — char(30)
  • publication date (Field2) — date

CONTRACT (Untitled5)

  • number of books (Field) — char(13) — Primary key
  • printing deadline (Field2) — date
  • book title (Key) — char(40) — NOT NULL
  • publisher Id (Key2) — char(10) — Foreign key → PUBLISHER.publisher Id — NOT NULL
  • printer Id (Key3) — char(10) — Foreign key → PRINTER.printer Id — NOT NULL
  • isbn (Key22) — char(13) — Foreign key → PUBLISHER.isbn — NOT NULL

PRINTER (Untitled6)

  • printer Id (Key) — char(10) — Primary key — NOT NULL
  • printer name (Field) — char(30)
  • printer address (Field2) — char(40)

PUBLISHER (Untitled4)

  • publisher Id (Key) — char(10) — Primary key — NOT NULL
  • isbn (Key2) — char(13) — Foreign key → BOOK.isbn — NOT NULL
  • publisher name (Field) — char(30)
  • publisher address (Field2) — char(40)