정규화
테이블 (7)
Untitled (dept)
- Key (dept_no) — varchar(8) — 기본 키 — NOT NULL
- Field (dept_name) — varchar(30)
- Field (loc) — varchar(30)
Untitled (student)
- Key (no) — int(10) — 기본 키 — NOT NULL
- Field (campus) — varchar(20)
Untitled (winner)
- Key (year) — int(6) — 기본 키 — NOT NULL
- Field (nation) — varchar(20)
Untitled (teams)
- Key (nation) — varchar(20) — NOT NULL
- Field (coach)
Untitled2 (lecture)
- Field (lecture) — varchar(20)
- Field (grade) — varchar(3)
- Key (no3) — int(10) — 외래 키 → Untitled.Key — NOT NULL
회원 (employees)
- Key (emp_no) — int(10) — 기본 키 — NOT NULL
- Field (salary) — int(10)
- Field (name) — varchar(25)
- Key (dept_no) — varchar(8) — 외래 키 → Untitled.Key — NOT NULL