| 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 |
| id | name | address | principalName | mascot |
|---|---|---|---|---|
| 1 | Central High | 123 Main Street | John Doe | Bears |
| 2 | Eastside Academy | 789 Pine Boulevard | Jane Smith | Panthers |
| 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 |
| 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 |
| 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 |
| id | eventDate | description | location | type |
|---|---|---|---|---|
| 1 | 2023-05-20 | Spring Formal Dance | Gymnasium | Dance |
| 2 | 2023-06-10 | Graduation Ceremony | Auditorium | Ceremony |