ex6

Tables (4)

Authors (Untitled3)

  • securityNumber (Key) — Primary key — NOT NULL
  • authorsName (Field)
  • authoorsAddress (Field2)

Book (Untitled)

  • isbn (Key) — Primary key — NOT NULL
  • title (Field)
  • publicationDate (Field2)
  • securityNumber (Key2) — Foreign key → Authors.securityNumber — NOT NULL

Book'sPublisher (Untitled2)

  • book'spublisherId (Key) — Primary key — NOT NULL
  • isbn (Key2) — Foreign key → Book.isbn — NOT NULL
  • publisherName (Field)
  • publisherAddress (Field2)
  • publisherIdentifier (Field3)

Printers (Untitled4)

  • printersId (Key) — Primary key — NOT NULL
  • printerName (Field)
  • printerAddress (Field2)
  • booksNumber (Field3)
  • printingDeadLine (Field4)
  • book'spublisherId (Key2) — Foreign key → Book'sPublisher.book'spublisherId — NOT NULL
  • isbn (Key22) — Foreign key → Book'sPublisher.isbn — NOT NULL
  • securityNumber (Key3) — Foreign key → Authors.securityNumber — NOT NULL