2023.3.29.ERD Exercise6

Tables (5)

AUTHOR_AUTHORS (Untitled3)

  • Ssn (Key) — char(13) — Primary key — NOT NULL
  • Name (Field) — char(30)
  • Address (Field2) — char(50)
  • Description (Field3) — text

BOOK (Untitled)

  • bookISBN (Key) — char(13) — Primary key — NOT NULL
  • priID (Key4) — char(13) — Foreign key → PRINTER.priID — NOT NULL
  • Ssn (Key3) — char(13) — Foreign key → AUTHOR_AUTHORS.Ssn — NOT NULL
  • publisherId (Key2) — char(13) — Foreign key → BOOK'S PUBLISHER.publisherId — NOT NULL
  • Title (Field) — text
  • publication Date (Field2) — date
  • Description (Field3) — text

BOOK'S PUBLISHER (Untitled2)

  • publisherId (Key) — char(13) — Primary key — NOT NULL
  • Name (Field) — char(20)
  • Address (Field2) — char(50)
  • Description (Field3) — text
  • priID (Key2) — char(13) — Foreign key → PRINTER.priID — NOT NULL

CONTRACTINFOM (Untitled7)

    PRINTER (Untitled6)

    • priID (Key) — char(13) — Primary key — NOT NULL
    • Name (Field) — char(20)
    • Address (Field3) — char(50)
    • Description (Field2) — text
    • publisherId (Key2) — char(13) — Foreign key → BOOK'S PUBLISHER.publisherId — NOT NULL