ERD exercise 3(20200916)
Tables (6)
AUTHOR (Untitled3)
- ssn (Key) — CHAR(20) — Primary key — NOT NULL
- autName (Field) — CHAR(30)
- address (Field2) — CHAR(50)
AUTHOR_BOOK (Untitled4)
- ssn (Key) — CHAR(20) — Foreign key → AUTHOR.ssn — NOT NULL
- ISBN (Key2) — CHAR(20) — Foreign key → BOOK.ISBN — NOT NULL
BOOK (Untitled)
- ISBN (Key) — CHAR(20) — Primary key — NOT NULL
- title (Field) — CHAR(30)
- publicationDate (Field2) — date
- pubID (Key2) — CHAR(20) — Foreign key → PUBLISHER.pubID — NOT NULL
PRINT (Untitled6)
- printingID (Key) — CHAR(20) — Primary key — NOT NULL
- bookQuantity (Field) — int
- printingDeadline (Field2) — date
- ISBN (Key2) — CHAR(20) — Foreign key → BOOK.ISBN — NOT NULL
- priID (Key3) — CHAR(20) — Foreign key → PRINTER.priID — NOT NULL
PRINTER (Untitled5)
- priID (Key) — CHAR(20) — Primary key — NOT NULL
- priName (Field) — CHAR(30)
- address (Field2) — CHAR(50)
PUBLISHER (Untitled2)
- pubID (Key) — CHAR(20) — Primary key — NOT NULL
- pubName (Field) — CHAR(30)
- address (Field2) — CHAR(50)