Teachers

teacher_idfull_name
1John Doe
2Jane Smith
3Michael Brown
4Emily White
5David Black

Classrooms

classroom_idroom_numbercapacity
1730
21228
3625
4932
51127

Subjects

subject_idnamedescription
1MathematicsThe study of numbers, quantities, shapes, patterns and structures.
2English LiteratureThe study of written works and their social contexts.
3Physical EducationThe development of physical fitness and skills through sports and activities.
4HistoryThe study of past events and their impact on present-day society.
5ArtThe expression of creativity and imagination through various forms of visual arts.

Students

student_idfirst_namelast_namedate_of_birthenrollment_date
1AliceJohnson2003-05-152020-09-01
2BobWilliams2004-06-202020-09-01
3CarolMartinez2005-07-102020-09-01
4DanielGarcia2006-08-152020-09-01
5EvaLee2007-09-052020-09-01

Teachers_Classrooms

teachers_classrooms_idteacher_idclassroom_idstart_dateend_date
(→ Teachers.teacher_id)(→ Classrooms.classroom_id)
1112021-08-302022-05-31
2222021-08-302022-05-31
3332021-08-302022-05-31
4442021-08-302022-05-31
5552021-08-302022-05-31
6212021-08-302022-05-31
7312021-08-302022-05-31
8412021-08-302022-05-31
9512021-08-302022-05-31