2semERD

Tables (5)

Class

  • ClassID — INT
  • Region — VARCHAR(50) — NOT NULL
  • ClassNumber — INT — NOT NULL
  • CourseID — INT
  • ConsultantID — INT

Coach

  • CoachID — INT
  • Name — VARCHAR(100) — NOT NULL
  • Duty — VARCHAR(100) — NOT NULL

Consultant

  • ConsultantID — INT
  • Name — VARCHAR(100) — NOT NULL
  • Duty — VARCHAR(100) — NOT NULL

Course

  • CourseID — INT
  • CourseType — VARCHAR(50) — NOT NULL

Student

  • StudentID — INT
  • Name — VARCHAR(100) — NOT NULL
  • Major — BOOLEAN — NOT NULL
  • Graduated — BOOLEAN — NOT NULL
  • ClassID — INT