ERD

Tables (7)

City (city)

  • CityId (city_id) — INT — Primary key — NOT NULL
  • CityName (city_name) — VARCHAR(50)

Class (class)

  • Class (class) — INT — Primary key — NOT NULL
  • CityId (city_id) — INT — Foreign key → City.CityId — NOT NULL
  • ConsultantId (consultant_id) — INT — Foreign key → Consultant.ConsultantId — NOT NULL

Coach (coach)

  • CoachId (coach_id) — INT — Primary key — NOT NULL
  • Name (name) — VARCHAR(50)
  • Class (class) — INT — Foreign key → Class.Class — NOT NULL
  • CityId (city_id) — INT — Foreign key → Class.CityId — NOT NULL

Consultant (consultant)

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

Curriculum (curriculum)

  • CurriculumId (curriculum_id) — INT — Primary key — NOT NULL
  • Course (course) — VARCHAR(50)

Semester (semester)

  • SemesterId (semester_id) — INT — Primary key — NOT NULL
  • Semester (semester) — INT

Student (student)

  • SemesterId (semester_id) — INT — Foreign key → Semester.SemesterId — NOT NULL
  • Major (major) — BOOLEAN
  • Leave (leave) — BOOLEAN