Students

StudentIDFirstNameLastNameDateOfBirthEmailAddress
1JohnDoe1990-01-01john.doe@example.com
2JaneSmith2000-06-30jane.smith@example.com
3AliceJohnson1987-02-20alice.johnson@example.com
4BobWilliams1992-12-15bob.williams@example.com
5EmmaBrown1995-05-01emma.brown@example.com

Teachers

TeacherIDFirstNameLastNameDateOfBirthEmailAddress
1MichaelBlack1980-03-15michael.black@example.com
2AnnaWhite1978-09-05anna.white@example.com
3DavidGreen1991-11-20david.green@example.com
4SarahBlue1985-07-31sarah.blue@example.com
5TomRed1988-02-10tom.red@example.com

Classes

ClassIDClassNameTeacherID
(→ Teachers.TeacherID)
1Math1
2Physics2
3English3
4History4
5Chemistry5

ResourceAllocation

AllocationIDClassIDResourceTypeQuantity
(→ Classes.ClassID)
11Textbooks30
22Microscopes15
33Charts20
44Projectors10
55Flasks25

Learning_Spaces

SpaceIDNameTypeAvailableResourcesCapacity
1Physics LabScience LabComputers30
2Biology LabScience LabTables25
3Creative Art StudioArt StudioComputers20
4Painting StudioArt StudioEasels25
5Orchestra RoomMusic RoomPianos15