StudentID | FirstName | LastName | DateOfBirth | EmailAddress |
---|---|---|---|---|
1 | John | Doe | 2000-01-01 | john.doe@example.com |
2 | Jane | Smith | 2002-02-02 | jane.smith@example.com |
ClubID | Name | Description | Participants |
---|---|---|---|
1 | Chess Club | A club dedicated to playing chess. | 30 |
2 | Coding Club | A club focused on coding and programming. | 20 |
ProgramID | Name | Description | Participants |
---|---|---|---|
1 | Youth Leadership Academy | A program that helps young people develop leadership skills. | 30 |
2 | Community Service Initiative | A program where students engage in community service projects. | 25 |
TeacherID | FirstName | LastName | SubjectTaught |
---|---|---|---|
1 | Michael | White | Mathematics |
2 | Emily | Green | English |
ClassID | ClassroomNumber | StartTime | EndTime | TeacherId |
---|---|---|---|---|
(→ Teachers.TeacherID) | ||||
1 | 101 | 08:00:00 | 09:00:00 | 1 |
2 | 201 | 10:00:00 | 11:00:00 | 2 |
EnrollmentID | StudentID | ClassId | Grade |
---|---|---|---|
(→ Students.StudentID) | (→ Classes.ClassID) | ||
1 | 1 | 1 | A |
2 | 1 | 2 | B |