## Addresses

id | street | city | state | zipcode
--- | --- | --- | --- | ---
1 | 123 Main St | Anytown | NY | 10001
2 | 456 Elm St | Anytown | NY | 10001
3 | 789 Oak St | Bytown | CA | 90001
4 | 234 Pine St | Citown | FL | 32101
5 | 567 Maple Ave | Downtown | TX | 77001

## Kindergartens

id | name | addressId
--- | --- | ---
|  | (→ Addresses.id)
1 | Little Learners | 1
2 | Tiny Tots Academy | 2
3 | Sunshine Preschool | 3
4 | ABC Prep School | 4
5 | Munchkin Montessori | 5

## High_Schools

id | name | addressId
--- | --- | ---
|  | (→ Addresses.id)
1 | Eagle High | 1
2 | Falcon Academy | 2
3 | Wolfson College | 3
4 | Panther Prep | 4
5 | Raptor Ridge High | 5

## Students

id | firstName | lastName | schoolId | classroomId | subjectId
--- | --- | --- | --- | --- | ---
|  |  | (→ High_Schools.id) | (→ Classrooms.id) | (→ Subjects.id)
1 | John | Smith | 1 | 1 | 1
2 | Jane | Doe | 2 | 2 | 2
3 | Alice | Brown | 1 | 3 | 3
4 | Tom | Green | 2 | 4 | 4
5 | Lucy | Black | 3 | 5 | 5

## Teachers

id | firstName | lastName | subjectId | classroomId
--- | --- | --- | --- | ---
|  |  | (→ Subjects.id) | (→ Classrooms.id)
1 | Mr. | Smith | 1 | 1
2 | Ms. | Doe | 2 | 2
3 | Mrs. | Brown | 3 | 3
4 | Mr. | Green | 4 | 4
5 | Mrs. | Black | 5 | 5

## Classrooms

id | roomNumber | highSchoolId
--- | --- | ---
|  | (→ High_Schools.id)
1 | Room 101 | 1
2 | Room 202 | 2
3 | Room 303 | 3
4 | Room 404 | 4
5 | Room 505 | 5

## Subjects

id | name | teacherId
--- | --- | ---
|  | (→ Teachers.id)
1 | Math | 1
2 | English | 2
3 | History | 3
4 | Science | 4
5 | Art | 5