exercise 6 new

Tables (6)

Author

  • A ID cardNumber (IDcardnumber) — int(20) — Primary key — NOT NULL
  • A Name (name) — char(20)
  • A Address (address) — char(100)
  • Field

BOOK (Book)

  • ISBN — int(20) — Primary key — NOT NULL
  • TITLE (Title) — char(100)
  • PublicationDate (publicationDate) — int(20)
  • PublisherID (publisher) — char(100)

PrintingHouse (printinghouse)

  • Key (PrintingHouseID) — int(20) — Primary key — NOT NULL
  • Field (Name) — char(100)
  • Field (address) — char(100)
  • ISBN — int(20) — Foreign key → BOOK.ISBN — NOT NULL

Publisher

  • PublisherID — int(20) — Primary key — NOT NULL
  • P Name (name) — char(100)
  • P Address (address) — char(100)
  • ISBN — int(20) — Foreign key → BOOK.ISBN — NOT NULL

Untitled (Contract)

  • Key (contractID) — int(20) — Primary key — NOT NULL
  • ISBN — int(20) — Foreign key → BOOK.ISBN — NOT NULL
  • Key (PrintingHouseID) — int(20) — Foreign key → PrintingHouse.Key — NOT NULL
  • Field (number of copies) — int(20)
  • Field (deadline) — int(20)

Untitled (BOOK_author)

  • ISBN — int(20) — Foreign key → BOOK.ISBN — NOT NULL
  • A ID cardNumber (IDcardnumber) — int(20) — Foreign key → Author.A ID cardNumber — NOT NULL