중간고사
테이블 (4)
Untitled (BOOK)
- Key (ISBN) — char(13) — 기본 키 — NOT NULL
- Field (keyword) — char(50) — 외래 키 → Untitled4.Field
- Field (bookName) — char(30)
- Field (physicalDescription) — char(50)
- Field (publishDate) — gYear
- Field (KDC) — float
- Key (authorID) — char(11) — 외래 키 → Untitled2.Key — NOT NULL
- Key (publisherID) — char(13) — 외래 키 → Untitled3.Key — NOT NULL
Untitled2 (AUTHOR)
- Key (authorID) — char(11) — 기본 키 — NOT NULL
- Field (authorName) — char(20)
- Field (address) — char(50)
- Field (phone) — char(11)
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Field (keyword) — char(50) — 외래 키 → Untitled.Field
Untitled3 (PUBLISHER)
- Key (publisherID) — char(13) — 기본 키 — NOT NULL
- Field (publisherName) — char(20)
- Field (address) — char(50)
- Field (phone) — char(11)
- Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
- Field (keyword) — char(50) — 외래 키 → Untitled.Field
- Field (memo) — char(100)
Untitled4 (SUBJECT)
- Field (keyword) — char(50) — 기본 키
- Field (relatedPerson) — char(20)
- Field (relatedEvent) — char(20)
- Field (description) — char(100)
- Field (memo) — char(100)