중간고사
테이블 (3)
Untitled (BOOK INFORMATION)
- Field (ISBN) — char(30) — 기본 키
- Key (Aname) — char(50) — 외래 키 → Untitled.Key — NOT NULL
- Field (publication date) — date
- Key (book name) — char(30) — NOT NULL
- Field (author) — char(50)
- Field (press) — char(50)
- Field (category number) — char(50)
- Field (ket word) — char(500)
Untitled (AUTHOR)
- Key (Aname) — char(50) — 기본 키 — NOT NULL
- Field (id number) — char(20)
- Field (address) — char(50)
Untitled2 (PRESS)
- Key (ID) — char(10) — 기본 키 — NOT NULL
- Field (ISBN) — char(30) — 외래 키 → Untitled.Field
- Key (Aname) — 외래 키 → Untitled.Key — NOT NULL
- Field (Pname) — char(50)
- Field (address) — char(100)