| 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 |