StudentID | FirstName | LastName | DateOfBirth | EmailAddress |
---|---|---|---|---|
1 | John | Doe | 1990-01-01 | john.doe@example.com |
2 | Jane | Smith | 2000-06-30 | jane.smith@example.com |
3 | Alice | Johnson | 1987-02-20 | alice.johnson@example.com |
4 | Bob | Williams | 1992-12-15 | bob.williams@example.com |
5 | Emma | Brown | 1995-05-01 | emma.brown@example.com |
TeacherID | FirstName | LastName | DateOfBirth | EmailAddress |
---|---|---|---|---|
1 | Michael | Black | 1980-03-15 | michael.black@example.com |
2 | Anna | White | 1978-09-05 | anna.white@example.com |
3 | David | Green | 1991-11-20 | david.green@example.com |
4 | Sarah | Blue | 1985-07-31 | sarah.blue@example.com |
5 | Tom | Red | 1988-02-10 | tom.red@example.com |
ClassID | ClassName | TeacherID |
---|---|---|
(→ Teachers.TeacherID) | ||
1 | Math | 1 |
2 | Physics | 2 |
3 | English | 3 |
4 | History | 4 |
5 | Chemistry | 5 |
AllocationID | ClassID | ResourceType | Quantity |
---|---|---|---|
(→ Classes.ClassID) | |||
1 | 1 | Textbooks | 30 |
2 | 2 | Microscopes | 15 |
3 | 3 | Charts | 20 |
4 | 4 | Projectors | 10 |
5 | 5 | Flasks | 25 |
SpaceID | Name | Type | AvailableResources | Capacity |
---|---|---|---|---|
1 | Physics Lab | Science Lab | Computers | 30 |
2 | Biology Lab | Science Lab | Tables | 25 |
3 | Creative Art Studio | Art Studio | Computers | 20 |
4 | Painting Studio | Art Studio | Easels | 25 |
5 | Orchestra Room | Music Room | Pianos | 15 |