StudentID | FirstName | LastName | BirthDate | |
---|---|---|---|---|
1 | John | Doe | 2000-01-01 | john.doe@example.com |
2 | Jane | Smith | 1997-06-28 | jane.smith@example.com |
EducatorID | FirstName | LastName | Subject |
---|---|---|---|
1 | Alice | Brown | Mathematics |
2 | Charlie | Green | English Literature |
ClassID | ClassName | StartTime | EndTime | RoomNumber |
---|---|---|---|---|
1 | Calculus I | 08:00:00 | 09:30:00 | 101 |
2 | Literary Analysis | 09:45:00 | 11:15:00 | 102 |
EnrollmentID | StudentID | ClassID | Semester | Grade |
---|---|---|---|---|
(→ Students.StudentID) | (→ Classes.ClassID) | |||
1 | 1 | 1 | Fall 2021 | A |
2 | 2 | 2 | Winter 2022 | B+ |
ProgramID | name | Type | Description | Credits |
---|---|---|---|---|
1 | IB Standard | International Baccalaureate Program | An internationally recognized pre-university program... | 30 |
2 | IB Extended | International Baccalaureate Program | This program has a slightly different curriculum structure... | 31 |
3 | AP College Board | Advanced Placement Program | The AP program offers college level courses... | 30 |
4 | General Program | Advanced Placement Program | These courses can earn college credit upon completion... | 29 |