Kindergartens

idnameaddressphoneNumberwebsite
1Sunshine Kindergarten123 Main Street555-123-4567http://www.sunshinelinks.com
2Little Learners456 Oak Avenue555-987-6543http://www.littlelearnersacademy.org

High_schools

idnameaddressprincipalNamemascot
1Central High123 Main StreetJohn DoeBears
2Eastside Academy789 Pine BoulevardJane SmithPanthers

Teachers

idfirstNamelastNamesubjectschoolID
(→ Schools.id)
1MichaelSmithMath1
2EmilyJohnsonEnglish1
3DavidWilliamsHistory2
4LauraMartinBiology2

Students

idfirstNamelastNamegradeLevelschoolID
(→ Schools.id)
1AlexanderDoe9th1
2ElizabethSmith10th1
3SamuelJohnson9th2
4OliviaWilliams10th2

Classes

idclassTitleteacherIDstartTimeendTime
(→ Teachers.id)
1Algebra I18:00 AM9:30 AM
2World History310:00 AM11:30 AM
3Physics412:00 PM1:30 PM

School_events

ideventDatedescriptionlocationtype
12023-05-20Spring Formal DanceGymnasiumDance
22023-06-10Graduation CeremonyAuditoriumCeremony