ERD 과제

테이블 (5)

Class (class)

  • Class Id (class_id) — INT(11) — 기본 키 — NOT NULL
  • Education Id (education_id) — CHAR(10) — 외래 키 → 교육 과정.Education Id — NOT NULL
  • Area (area) — Char(10)
  • Class Number (class_number) — Char(10)

Coach (coach)

  • Coach Id (coach_id) — INT(11) — 기본 키 — NOT NULL
  • 업무 — Char(200)
  • Class Id (class_id) — INT(11) — 외래 키 → Class.Class Id — NOT NULL
  • Education Id (education_id) — CHAR(10) — 외래 키 → Class.Education Id — NOT NULL

Consultent (consultent)

  • Consultent Id (consultent_id) — INT(11) — 기본 키 — NOT NULL
  • Class Id (class_id) — INT(11) — 외래 키 → Class.Class Id — NOT NULL
  • Education Id (education_id) — CHAR(10) — 외래 키 → Class.Education Id — NOT NULL
  • 업무 — Char(200)

Students (students)

  • Student Id (student_id) — INT(11) — 기본 키 — NOT NULL
  • Class Id (class_id) — INT(11) — 외래 키 → Class.Class Id — NOT NULL
  • Education Id (education_id) — CHAR(10) — 외래 키 → Class.Education Id — NOT NULL
  • 기수 — Char(10)
  • 전공 — Char(1)
  • 퇴소 — Char(1)

교육 과정

  • Education Id (education_id) — CHAR(10) — 기본 키 — NOT NULL
  • Education Name (education_name) — CHAR(10)