ERD Exercise 6
Tables (5)
BOOK (Untitled)
- ISBN (Key) — char(20) — Primary key — NOT NULL
- name (Field) — char(10)
- date (Field2) — char(8)
- publisher (Field3) — char(10)
CONTRACT (Untitled5)
- howMany (Key) — integer — Primary key — NOT NULL
- ISBN (Key2) — char(20) — Foreign key → BOOK.ISBN — NOT NULL
- limitDate (Field) — char(8)
PRINTSHOP (Untitled4)
- Id (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(20)
- ISBN (Key2) — char(20) — Foreign key → BOOK.ISBN — NOT NULL
PUBLISHER (Untitled2)
- publisherID (Key) — char(10) — Primary key — NOT NULL
- ISBN (Key2) — char(20) — Foreign key → BOOK.ISBN — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(20)
WRITER (Untitled3)
- SSN (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(20)
- ISBN (Key2) — char(20) — Foreign key → BOOK.ISBN — NOT NULL