## Students

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

## Teachers

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

## Classes

ClassID | ClassName | TeacherID
--- | --- | ---
|  | (→ Teachers.TeacherID)
1 | Math | 1
2 | Physics | 2
3 | English | 3
4 | History | 4
5 | Chemistry | 5

## ResourceAllocation

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

## Learning_Spaces

SpaceID | Type | AvailableResources | Capacity
--- | --- | --- | ---
1 | Science Lab | Computers | 30
2 | Science Lab | Tables | 25
3 | Art Studio | Computers | 20
4 | Art Studio | Easels | 25
5 | Music Room | Pianos | 15