준사서A -2학기 중간고사
테이블 (5)
Untitled (BOOK)
- Key (ISBN) — 기본 키 — NOT NULL
- Field (Title)
- Field (ReieaseDate)
- Field (Publisher)
- Field (KDC)
Untitled2 (PUBLISHER)
- Key (ID) — 기본 키 — NOT NULL
- Field (CompanyName)
- Field (Address)
- Field (Tel.)
- Key (ISBN) — 외래 키 → Untitled.Key — NOT NULL
Untitled3 (WRITER)
- Key (Name) — 기본 키 — NOT NULL
- Field (Address)
- Field (Tel)
- Field (work)
- Key (ISBN) — 외래 키 → Untitled.Key — NOT NULL
Untitled4 (PRINTING HOUSE)
- Key (ID) — 기본 키 — NOT NULL
- Field (CompanyNameField)
- Field2 (Address)
- Field2 (Tel.)
Untitled5 (CONTRACT)
- Key (Quantity) — 기본 키 — NOT NULL
- Field (ClosingDate)
- Key (ID) — 외래 키 → Untitled4.Key — NOT NULL
- Key (ID2) — 외래 키 → Untitled2.Key — NOT NULL