정규화

테이블 (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)

Untitled (worldcup)

    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