데이터베이스 중간고사
테이블 (8)
Untitled (BOOK)
- Key (ISBN) — integer — 기본 키 — NOT NULL
- Field (title) — char(20)
- Field (publisher date) — char(20)
- Field (publisher) — char(30)
- Field (price) — integer
- Key (publisherID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (AUTHORS)
- Key — integer — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(20)
- Field (phone) — char(20)
Untitled (PUBLISHER)
- Key (publisherID) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
Untitled (BOOK_PRINTER)
- Key (prinID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (ISBN) — integer — 외래 키 → Untitled.Key — NOT NULL
Untitled (PRINTER)
- Key (prinID) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (adrress) — char(20)
- Field (phone) — char(20)
Untitled (PRINTER_CONTRACT)
- Key (publisherID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (prinID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (BOOK_AUTHORS)
- Key (ISBN) — integer — 외래 키 → Untitled.Key — NOT NULL
- Key — integer — 외래 키 → Untitled.Key — NOT NULL