## Kindergartens

id | name | address | phoneNumber | website
--- | --- | --- | --- | ---
1 | Sunshine Kindergarten | 123 Main Street | 555-123-4567 | http://www.sunshinelinks.com
2 | Little Learners | 456 Oak Avenue | 555-987-6543 | http://www.littlelearnersacademy.org

## High_schools

id | name | address | principalName | mascot
--- | --- | --- | --- | ---
1 | Central High | 123 Main Street | John Doe | Bears
2 | Eastside Academy | 789 Pine Boulevard | Jane Smith | Panthers

## Teachers

id | firstName | lastName | subject | schoolID
--- | --- | --- | --- | ---
|  |  |  | (→ Schools.id)
1 | Michael | Smith | Math | 1
2 | Emily | Johnson | English | 1
3 | David | Williams | History | 2
4 | Laura | Martin | Biology | 2

## Students

id | firstName | lastName | gradeLevel | schoolID
--- | --- | --- | --- | ---
|  |  |  | (→ Schools.id)
1 | Alexander | Doe | 9th | 1
2 | Elizabeth | Smith | 10th | 1
3 | Samuel | Johnson | 9th | 2
4 | Olivia | Williams | 10th | 2

## Classes

id | classTitle | teacherID | startTime | endTime
--- | --- | --- | --- | ---
|  | (→ Teachers.id) |  |
1 | Algebra I | 1 | 8:00 AM | 9:30 AM
2 | World History | 3 | 10:00 AM | 11:30 AM
3 | Physics | 4 | 12:00 PM | 1:30 PM

## School_events

id | eventDate | description | location | type
--- | --- | --- | --- | ---
1 | 2023-05-20 | Spring Formal Dance | Gymnasium | Dance
2 | 2023-06-10 | Graduation Ceremony | Auditorium | Ceremony