ERD 연습문제 6
테이블 (6)
Untitled (Author)
- Key (ssn) — char(20) — 기본 키 — NOT NULL
- Field (aName) — char(10)
- Field (aAddress) — char(20)
Untitled (book_author)
- Key (isbn) — char(20) — 외래 키 → book.Key — NOT NULL
- Key (ssn) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (publishCompany)
- Key (puId) — char(20) — 기본 키 — NOT NULL
- Field (pcName) — char(10)
- Field (pcAddress) — char(30)
Untitled (printCompany_book)
- Key (isbn) — char(20) — 외래 키 → book.Key — NOT NULL
- Key (prID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (prQty) — int(5)
- Field (prFinDate) — date
Untitled (printCompany)
- Key (prID) — char(20) — 기본 키 — NOT NULL
- Field (prName) — char(10)
- Field (prAddress) — char(30)
book
- Key (isbn) — char(20) — 기본 키 — NOT NULL
- Field (bName) — char(30)
- Field (publishDate) — date
- Field
- Key (pcId) — char(20) — 외래 키 → Untitled.Key — NOT NULL