Schools

SchoolIDNameAddressPhoneText
1ABC High School123 Street View+987654321
2XYZ Elementary School456 Boulevard Place+765432198
3LMN Middle School789 Avenue Drive+543219876

Classes

ClassIDSchoolIDTeacherNameSubject
(→ Schools.SchoolID)
11Mr. SmithMath
21Mrs. JohnsonEnglish
32Ms. BrownHistory
42Mr. WhiteScience
53Mrs. BlackArt

Students

StudentIDFirstNameLastNameAgeEnrollmentDate
1JohnDoe152021-09-01
2JaneSmith142021-09-01
3AliceBrown162021-09-01
4BobWhite172021-09-01
5CharlieBlack132021-09-01

Enrollments

EnrollmentIDStudentIDClassIDEducational_ActivityNumber_of_students
(→ Students.StudentID)(→ Classes.ClassID)
111Field Trip50
212Field Trip30
323Study Hall50
424Study Hall40
535Project Day25
641Lecture Series20
752Workshop22