Addresses

idstreetcitystatezipcode
1123 Main StAnytownNY10001
2456 Elm StAnytownNY10001
3789 Oak StBytownCA90001
4234 Pine StCitownFL32101
5567 Maple AveDowntownTX77001

Kindergartens

idnameaddressId
(→ Addresses.id)
1Little Learners1
2Tiny Tots Academy2
3Sunshine Preschool3
4ABC Prep School4
5Munchkin Montessori5

High_Schools

idnameaddressId
(→ Addresses.id)
1Eagle High1
2Falcon Academy2
3Wolfson College3
4Panther Prep4
5Raptor Ridge High5

Students

idfirstNamelastNameschoolIdclassroomIdsubjectId
(→ High_Schools.id)(→ Classrooms.id)(→ Subjects.id)
1JohnSmith111
2JaneDoe222
3AliceBrown133
4TomGreen244
5LucyBlack355

Teachers

idfirstNamelastNamesubjectIdclassroomId
(→ Subjects.id)(→ Classrooms.id)
1Mr.Smith11
2Ms.Doe22
3Mrs.Brown33
4Mr.Green44
5Mrs.Black55

Classrooms

idroomNumberhighSchoolId
(→ High_Schools.id)
1Room 1011
2Room 2022
3Room 3033
4Room 4044
5Room 5055

Subjects

idnameteacherId
(→ Teachers.id)
1Math1
2English2
3History3
4Science4
5Art5