기말고사
테이블 (4)
AUTHOR (Untitled2)
- authorID (Key) — int(10) — 기본 키 — NOT NULL
- name (Field) — char(30)
- birthdate (Field2) — int(10)
- famous work (Field3) — text
BOOK-AUTHOR (Untitled4)
- ISBN (Key2) — char(13) — 외래 키 → Book.ISBN — NOT NULL
- authorID (Key) — int(10) — 외래 키 → AUTHOR.authorID — NOT NULL
Book (Untitled)
- ISBN (Key) — char(13) — 기본 키 — NOT NULL
- title (Field) — char(50)
- kdc (Field2) — char(20)
- pubyear (Field3) — int(4)
- type (Field4) — char(10)
- pages (Field5) — int(10)
- age group (Field6) — char(10)
- location (Field7) — char(15)
- company id (Key2) — int(10) — 외래 키 → PUBLISHING COMPANY.company id — NOT NULL
PUBLISHING COMPANY (Untitled3)
- company id (Key) — int(10) — 기본 키 — NOT NULL
- company name (Field) — char(20)
- adress (Field2) — char(10)