StudentID | FirstName | LastName | Age | |
---|---|---|---|---|
1 | John | Doe | 21 | john.doe@example.com |
2 | Jane | Smith | 22 | jane.smith@example.com |
3 | Michael | Brown | 23 | michael.brown@example.com |
4 | Emily | White | 20 | emily.white@example.com |
5 | David | Green | 24 | david.green@example.com |
EnvironmentID | Value |
---|---|
1 | Classroom |
2 | Virtual Room |
EnrollmentID | StudentID | ClassroomID | StartDate | EndDate |
---|---|---|---|---|
(→ Students.StudentID) | (→ Classrooms.ClassroomID) | |||
1 | 1 | 1 | 2022-09-01 | 2022-12-31 |
2 | 2 | 2 | 2022-08-26 | 2022-12-17 |
3 | 3 | 3 | 2022-09-01 | 2022-12-31 |
4 | 4 | 4 | 2022-08-26 | 2022-12-17 |
5 | 5 | 5 | 2022-09-01 | 2022-12-31 |
ClassroomID | Name | Capacity | TypeOfEnvironment |
---|---|---|---|
(→ LearningEnvironments.EnvironmentID) | |||
1 | Room A | 30 | 1 |
2 | Room B | 25 | 1 |
3 | Virtual Room C | 30 | 2 |
4 | Virtual Room D | 20 | 2 |
5 | Physical Room E | 15 | 1 |