ex6
Tables (5)
AUTHOR (Untitled3)
- authorSsn (Key) — char(10) — Primary key — NOT NULL
- authorName (Field) — char(10)
- authorAddress (Field2) — char(20)
- authorPhone (Field3) — char(11)
- ISBN (Key2) — char(10) — Foreign key → BOOK.ISBN — NOT NULL
- publisherID (Key3) — char(10) — Foreign key → PUBLISHER.publisherID — NOT NULL
BOOK (Untitled)
- ISBN (Key) — char(10) — Primary key — NOT NULL
- title (Field) — char(20)
- publicationDate (Field2) — date
- author (Field3)
- publisherID (Key2) — char(10) — Foreign key → PUBLISHER.publisherID — NOT NULL
CONTRACT (Untitled5)
- numberOFBooks (Key) — char(10) — Primary key — NOT NULL
- printingDeadline (Field) — date
- publisherID (Key2) — char(10) — Foreign key → PUBLISHER.publisherID — NOT NULL
- printerID (Key3) — char(10) — Foreign key → PRINTER.printerID — NOT NULL
PRINTER (Untitled4)
- printerID (Key) — char(10) — Primary key — NOT NULL
- printerName (Field) — char(10)
- address (Field2) — char(20)
- phone (Field3) — char(11)
- publisherID (Key2) — char(10) — Foreign key → PUBLISHER.publisherID — NOT NULL
PUBLISHER (Untitled2)
- publisherID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(20)
- phone (Field3) — char(11)