ex_6

Tables (5)

AUTHOR (Untitled3)

  • AuthorIdNo (Key) — char(13) — Primary key — NOT NULL
  • ISBN (Key2) — char(8) — Foreign key → BOOKS.ISBN — NOT NULL
  • AuthorName (Field) — char(4)
  • AuthorAddress (Field2) — char(10)
  • PubId (Key3) — char(8) — Foreign key → PUBLISHER.PubId — NOT NULL
  • ISBN (Key22) — char(8) — Foreign key → PUBLISHER.ISBN — NOT NULL

BOOKS (Untitled)

  • ISBN (Key) — char(8) — Primary key — NOT NULL
  • Title (Field) — char(10)
  • PublicationDate (Field2) — char(8)
  • Publisher (Field3) — char(6)

CONTRACT (Untitled5)

  • ContractId (Key) — char(8) — Primary key — NOT NULL
  • ISBN (Key2) — char(8) — Foreign key → BOOKS.ISBN — NOT NULL
  • NumberOfBooks (Field) — number
  • PrintingDeadline (Field2) — date

PRINTER (Untitled4)

  • PrinterId (Key) — char(8) — Primary key — NOT NULL
  • PrinterName (Field) — char(4)
  • PrinterAddress (Field2) — char(10)
  • ISBN (Key2) — char(8) — Foreign key → BOOKS.ISBN — NOT NULL

PUBLISHER (Untitled2)

  • PubId (Key) — char(8) — Primary key — NOT NULL
  • ISBN (Key2) — char(8) — Foreign key → BOOKS.ISBN — NOT NULL
  • PubName (Field) — char(8)
  • PubAddress (Field2) — char(10)