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