Exercise6

Tables (7)

ADDRESSLIST (Untitled4)

  • addressNo (Key) — char(5) — Primary key — NOT NULL
  • address2 (Field2)
  • zipcode (Key2) — char(5) — Foreign key → ZIPCODE.zipcode — NOT NULL

AUTHOR (Untitled)

  • IDCardNumber (Key) — char(13) — Primary key — NOT NULL
  • authorName (Field) — char(30)
  • isbn (Key2) — char(18) — Foreign key → BOOKS.isbn — NOT NULL
  • addressNo (Key3) — char(5) — Foreign key → ADDRESSLIST.addressNo — NOT NULL

BOOKS (Untitled2)

  • isbn (Key) — char(18) — Primary key — NOT NULL
  • title (Field) — char(30)
  • publicationDate (Field2) — date
  • IDCardNumber (Key2) — char(13) — Foreign key → AUTHOR.IDCardNumber — NOT NULL

CONTRACT (Untitled6)

  • numberofBooks (Key) — integer — Primary key — NOT NULL
  • printingDeadline (Field) — date
  • publisherId (Key2) — char(5) — Foreign key → PUBLISHER.publisherId — NOT NULL
  • printerId (Key3) — char(5) — Foreign key → PRINTER.printerId — NOT NULL

PRINTER (Untitled7)

  • printerId (Key) — char(5) — Primary key — NOT NULL
  • name (Field) — char(30)
  • numberofBooks (Key2) — integer — Foreign key → CONTRACT.numberofBooks — NOT NULL
  • addressNo (Key3) — char(5) — Foreign key → ADDRESSLIST.addressNo — NOT NULL

PUBLISHER (Untitled3)

  • publisherId (Key) — char(5) — Primary key — NOT NULL
  • publisherName (Field) — char(30)
  • isbn (Key2) — char(18) — Foreign key → BOOKS.isbn — NOT NULL
  • addressNo (Key3) — char(5) — Foreign key → ADDRESSLIST.addressNo — NOT NULL

ZIPCODE (Untitled5)

  • zipcode (Key) — char(5) — Primary key — NOT NULL
  • address1 (Field) — text