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 |