erd과제

테이블 (5)

class

  • class_id — VARCHAR2(50) — 기본 키 — NOT NULL
  • course_id — VARCHAR2(50) — 외래 키 → course.course_id — NOT NULL
  • location — VARCHAR2(50)
  • coach_id — VARCHAR2(50) — 외래 키 → coach.coach_id — NOT NULL

coach

  • coach_id — VARCHAR2(50) — 기본 키 — NOT NULL
  • name — VARCHAR2(50)
  • resposibility (responsibility) — VARCHAR2(50)

consultant

  • consul_id — VARCHAR2(50) — 기본 키 — NOT NULL
  • student_id — VARCHAR2(50) — 외래 키 → students.student_id — NOT NULL
  • class_id — VARCHAR2(50) — 외래 키 → class.class_id — NOT NULL
  • course_id — VARCHAR2(50) — 외래 키 → class.course_id — NOT NULL
  • name — VARCHAR2(50)
  • responsbility (responsbilty) — VARCHAR2(50)

course

  • course_id — VARCHAR2(50) — 기본 키 — NOT NULL
  • type — VARCHAR2(50)

students

  • student_id — VARCHAR2(50) — 기본 키 — NOT NULL
  • generation — VARCHAR(100)
  • major — VARCHAR2(50)
  • graduated — VARCHAR2(20)
  • class_id — VARCHAR2(50) — 외래 키 → class.class_id — NOT NULL
  • course_id — VARCHAR2(50) — 외래 키 → class.course_id — NOT NULL
  • ffd (Field)