과제

테이블 (4)

Class (class)

  • ClassNumber (class_id) — INTEGER — 기본 키 — NOT NULL
  • ConsultantNumber (consultant_id) — INTEGER — 외래 키 → Consultant.ConsultantNumber — NOT NULL
  • Region (region) — VARCHAR(100)
  • SmallClassNumber (small_class_number) — INTEGER

Coach (coach)

  • CoachNumber (coach_id) — INTEGER — 기본 키 — NOT NULL
  • LastName (last_name) — VARCHAR(100)
  • FirstName (first_name) — VARCHAR(100)
  • ClassNumber (class_id) — INTEGER — 외래 키 → Class.ClassNumber — NOT NULL
  • ConsultantNumber (consultant_id) — INTEGER — 외래 키 → Class.ConsultantNumber — NOT NULL

Consultant (consultant)

  • ConsultantNumber (consultant_id) — INTEGER — 기본 키 — NOT NULL
  • LastName (last_name) — VARCHAR(100)
  • FirstName (first_name) — VARCHAR(100)

Student (student)

  • StudentNumber (student_id) — INTEGER — 기본 키 — NOT NULL
  • ClassNumber (class_id) — INTEGER — 외래 키 → Class.ClassNumber — NOT NULL
  • ConsultantNumber (consultant_id) — INTEGER — 외래 키 → Class.ConsultantNumber — NOT NULL
  • LastName (last_name) — VARCHAR(100)
  • FirstName (first_name) — VARCHAR(100)
  • Generation (generation) — INTEGER
  • Curriculum (curriculum) — VARCHAR(100)
  • IsMajor (is_major) — BOOLEAN
  • IsDischarge (is_discharge) — BOOLEAN