## Students

id | firstName | lastName | dateOfBirth
--- | --- | --- | ---
1 | John | Doe | 2008-09-15
2 | Jane | Smith | 2007-03-20
3 | Michael | Johnson | 2006-11-12
4 | Emily | Williams | 2005-06-01
5 | David | Brown | 2004-02-15

## Classes

classID | className | teacherName
--- | --- | ---
1 | Math | Mr. Thompson
2 | English | Ms. Johnson
3 | History | Mr. White
4 | Art | Ms. Green
5 | Physical Education | Coach Black

## Enrollments

enrollmentId | studentId | classId
--- | --- | ---
| (→ Students.id) | (→ Classes.classId)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5

## MilestoneRecords

recordId | studentId | physicalMilestones | cognitiveMilestones | childAge | otherDetails
--- | --- | --- | --- | --- | ---
| (→ Students.id) |  |  |  |
1 | 1 | Walking and running | Counting to 10 | 8 | No additional details
2 | 2 | Riding a bike | Reading simple sentences | 9 | No additional details
3 | 3 | Climbing stairs | Recognizing colors | 7 | No additional details
4 | 4 | Swimming | Understanding basic concepts | 10 | No additional details
5 | 5 | Playing sports | Writing short stories | 11 | No additional details

## Attendance

attendanceId | studentId | classId | dateAttended | isPresent
--- | --- | --- | --- | ---
| (→ Students.id) | (→ Classes.classId) |  |
1 | 1 | 1 | 2022-09-01 | 1
2 | 2 | 2 | 2022-09-02 | 0
3 | 3 | 3 | 2022-09-03 | 1
4 | 4 | 4 | 2022-09-04 | 1
5 | 5 | 5 | 2022-09-05 | 0

## DisciplineLogs

logId | studentId | incidentDate | reasonForDiscipline | disciplinaryAction | resolutionDate
--- | --- | --- | --- | --- | ---
| (→ Students.id) |  |  |  |
1 | 1 | 2022-09-06 | Talking during class | Detention | 2022-09-08
2 | 2 | 2022-09-07 | Cheating on a test | Suspension | 2022-09-10
3 | 3 | 2022-09-08 | Bullying another student | Apology letter | 2022-09-10
4 | 4 | 2022-09-09 | Damaging school property | Community service | 2022-09-15
5 | 5 | 2022-09-10 | Late assignment submission | Extra credit assignment | 2022-09-15