| 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 | Description | Credits |
|---|---|---|---|
| 1 | International Baccalaureate Program | An internationally recognized pre-university program... | 30 |
| 2 | International Baccalaureate Program | This program has a slightly different curriculum structure... | 31 |
| 3 | Advanced Placement Program | The AP program offers college level courses... | 30 |
| 4 | Advanced Placement Program | These courses can earn college credit upon completion... | 29 |