Exercise6

Tables (5)

Author (Untitled4)

  • SSN (Key) — char(30) — Primary key — NOT NULL
  • name (Field) — char(30)
  • address (Field2) — char(30)
  • Field3

Book (Untitled)

  • ISBN (Key) — char(20) — Primary key — NOT NULL
  • Title (Field) — char(30)
  • publication date (Field2) — date
  • SSN (Key2) — char(30) — Foreign key → Author.SSN — NOT NULL
  • ID (Key3) — char(30) — Foreign key → Printer.ID — NOT NULL

Contract (Untitled2)

  • print (Key) — char(30) — Primary key — NOT NULL
  • deadline (Field) — date
  • ID (Key2) — char(30) — Foreign key → Printer.ID — NOT NULL

Printer (Untitled5)

  • ID (Key) — char(30) — Primary key — NOT NULL
  • Name (Field) — char(30)
  • address (Field2) — char(30)

Publisher (Untitled3)

  • ID (Key) — charj(30) — Primary key — NOT NULL
  • name (Field) — char(30)
  • address (Field2) — char(30)
  • ISBN (Key2) — char(20) — Foreign key → Book.ISBN — NOT NULL