EX6

Tables (7)

AUTHOR (Untitled4)

  • aId (Key) — char(20) — Primary key — NOT NULL
  • aName (Field) — char(10)
  • aAdress (Field2) — char(40)

BOOK (Untitled)

  • isbn (Key) — char(20) — Primary key — NOT NULL
  • pId (Key3) — char(20) — Foreign key → PUBLISHER.pId — NOT NULL
  • Name (Field) — char(30)
  • gId (Key2) — integer — Foreign key → Genre.gId — NOT NULL
  • publicationDate (Field2) — date

BOOK_AUTHOR (Untitled5)

  • aId (Key) — char(20) — Foreign key → AUTHOR.aId — NOT NULL
  • isbn (Key2) — char(20) — Foreign key → BOOK.isbn — NOT NULL
  • pId (Key3) — char(20) — Foreign key → BOOK.pId — NOT NULL

Genre (Untitled2)

  • gId (Key) — integer — Primary key — NOT NULL
  • gName (Field) — char(10)

PUBLISHER (Untitled3)

  • pId (Key) — char(20) — Primary key — NOT NULL
  • pName (Field) — char(10)
  • pAdress (Field2)

Print_Contract (Untitled7)

  • ContractId (Key3) — integer — Primary key — NOT NULL
  • isbn (Key2) — char(20) — Foreign key → BOOK.isbn — NOT NULL
  • number (Field) — integer
  • EndDate (Field2) — date
  • printId (Key) — char(20) — Foreign key → PrintingPress.printId — NOT NULL
  • pId (Key32) — char(20) — Foreign key → BOOK.pId — NOT NULL

PrintingPress (Untitled6)

  • printId (Key) — char(20) — Primary key — NOT NULL
  • printAddress (Field) — char(40)
  • printName (Field2) — char(20)