ex6

Tables (5)

AUTHOR (Untitled3)

  • authorSsn (Key) — char(10) — Primary key — NOT NULL
  • authorName (Field) — char(10)
  • authorAddress (Field2) — char(20)
  • authorPhone (Field3) — char(11)
  • ISBN (Key2) — char(10) — Foreign key → BOOK.ISBN — NOT NULL
  • publisherID (Key3) — char(10) — Foreign key → PUBLISHER.publisherID — NOT NULL

BOOK (Untitled)

  • ISBN (Key) — char(10) — Primary key — NOT NULL
  • title (Field) — char(20)
  • publicationDate (Field2) — date
  • author (Field3)
  • publisherID (Key2) — char(10) — Foreign key → PUBLISHER.publisherID — NOT NULL

CONTRACT (Untitled5)

  • numberOFBooks (Key) — char(10) — Primary key — NOT NULL
  • printingDeadline (Field) — date
  • publisherID (Key2) — char(10) — Foreign key → PUBLISHER.publisherID — NOT NULL
  • printerID (Key3) — char(10) — Foreign key → PRINTER.printerID — NOT NULL

PRINTER (Untitled4)

  • printerID (Key) — char(10) — Primary key — NOT NULL
  • printerName (Field) — char(10)
  • address (Field2) — char(20)
  • phone (Field3) — char(11)
  • publisherID (Key2) — char(10) — Foreign key → PUBLISHER.publisherID — NOT NULL

PUBLISHER (Untitled2)

  • publisherID (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(20)
  • phone (Field3) — char(11)