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