BOOK

Tables (5)

Author (Untitled5)

  • SSN (Key) — Char(10) — Primary key — NOT NULL
  • aName (Field) — Char(10)
  • aAdr (Field2) — Char(30)
  • ISBN (Key2) — Char(10) — Foreign key → Book.ISBN — NOT NULL

Book (Untitled)

  • ISBN (Key) — Char(10) — Primary key — NOT NULL
  • bname (Field) — Char(25)
  • bpubdate (Field2) — date
  • pubID (Key2) — Char(10) — Foreign key → Publisher.ID — NOT NULL

Contract (Untitled4)

  • ISBN (Key) — Char(10) — Foreign key → Book.ISBN — NOT NULL
  • ID (Key2) — Char(10) — Foreign key → Printer.ID — NOT NULL
  • numPrBook (Field) — int(6)
  • dueDate (Field2) — date

Printer (Untitled3)

  • ID (Key) — Char(10) — Primary key — NOT NULL
  • prName (Field) — Char(10)
  • prAdr (Field2) — Char(30)
  • prLimit (Field3) — int(6)

Publisher (Untitled2)

  • ID (Key) — Char(10) — Primary key — NOT NULL
  • pubName (Field) — Char(10)
  • pubAdr (Field2) — Char(30)