hw3

Tables (4)

Class (class)

  • ClassId (class_id) — int(2) — Primary key — NOT NULL
  • ConsultantId (consultant_id) — INT(8) — Foreign key → Consultant.ConsultantId — NOT NULL
  • CoachId (coach_id) — INT(8) — Foreign key → Coach.CoachId — NOT NULL
  • StudentId (student_id) — INT(8) — Foreign key → Student.StudentId — NOT NULL
  • Region (region) — VARCHAR(255)
  • ClassNum (class_num) — INT(1)
  • Course (course) — VARCHAR(255)

Coach (coach)

  • CoachId (coach_id) — INT(8) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)

Consultant (consultant)

  • ConsultantId (consultant_id) — INT(8) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)

Student (student)

  • StudentId (student_id) — INT(8) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Generation (generation) — INT(4)
  • Major (major) — Boolean
  • Finish (finish) — Boolean