ERD Exercise 6
Tables (5)
AUTHOR (Untitled3)
- SSN (Key) — char(13) — Primary key — NOT NULL
- name (Field) — char(15)
- address (Field2) — char(30)
- ISBN (Key2) — CHAR(13) — Foreign key → BOOK.ISBN — NOT NULL
- publisherID (Key22) — char(15) — Foreign key → BOOK.publisherID — NOT NULL
BOOK (Untitled)
- ISBN (Key) — CHAR(13) — Primary key — NOT NULL
- publisherID (Key2) — char(15) — Foreign key → PUBLISHER.publisherID — NOT NULL
- SSN (Key3) — char(13) — Foreign key → AUTHOR.SSN — NOT NULL
- title (Field) — char(20)
- publisher (Field2) — char(15)
- publicationDate (Field3) — char(8)
- printerID (Key4) — char(13) — Foreign key → PRINTER.printerID — NOT NULL
CONTRACT (Untitled5)
- printerID (Key) — char(13) — Foreign key → PRINTER.printerID — NOT NULL
- numberofbooks (Field) — char(15)
- printingdeadline (Field2) — char(10)
- publisherID (Key2) — char(15) — Foreign key → PUBLISHER.publisherID — NOT NULL
PRINTER (Untitled4)
- printerID (Key) — char(13) — Primary key — NOT NULL
- address (Field2) — char(30)
- ISBN (Key2) — CHAR(13) — Foreign key → BOOK.ISBN — NOT NULL
- publisherID (Key22) — char(15) — Foreign key → BOOK.publisherID — NOT NULL
PUBLISHER (Untitled2)
- publisherID (Key) — char(15) — Primary key — NOT NULL
- name (Field) — char(15)
- address (Field2) — char(30)