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