정규화
테이블 (9)
Untitled (member)
- Key — int(10) — 기본 키 — NOT NULL
- Field (name) — varchar(30)
- Field (phone1) — varchar(10)
- Field (phone2) — varchar(10)
Untitled (profile)
- Key (id) — int(10) — 기본 키 — NOT NULL
- Field (name) — varchar(30)
Untitled (phonebook)
- Field (phone) — varchar(13)
- Key (id) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (student)
- Key (no) — int(10) — 기본 키 — NOT NULL
- Field (campus) — varchar(20)
Untitled (lecture)
- Key (no) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (lecture) — varchar(20)
- Field (grade) — varchar(3)
Untitled (worldcup)
- Key (year) — int(6) — 기본 키 — NOT NULL
- Field (winner) — varchar(20)
- Field (coach) — varchar(20)
Untitled (winner)
- Key (year) — int(6) — 기본 키 — NOT NULL
- Field (nation) — varchar(20)
Untitled (teams)
- Key (year) — int(6) — 외래 키 → Untitled.Key — NOT NULL
- Field (nation) — varchar(20)
- Field (coach) — varchar(20)
student_lecture
- Key (no) — int(10) — 기본 키 — NOT NULL
- Key (lecture) — varchar(20) — 기본 키 — NOT NULL
- Field (campus) — varchar(20)
- Field (grade) — varchar(5)