## Academic_Discipline

DisciplineID | Name | Description
--- | --- | ---
1 | Mathematics | The study of numbers and their properties.
2 | Physics | The study of matter and energy and how they interact.
3 | Biology | The study of living organisms and their interactions with their environment.
4 | Chemistry | The study of substances and their interactions.
5 | History | The study of past events and their causes and effects.

## Grade_Level

LevelID | Name | MinAge | MaxAge
--- | --- | --- | ---
1 | PreKindergarten | 3 | 4
2 | Kindergarten | 4 | 5
3 | 1st Grade | 5 | 6
4 | 2nd Grade | 6 | 7
5 | 3rd Grade | 7 | 8

## Student

ID | FirstName | LastName | BirthDate | GradeLevelID | DisciplineID
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Grade_Level.LevelID) | (→ Academic_Discipline.DisciplineID)
1 | John | Doe | 2005-09-01 | 1 | 1
2 | Jane | Smith | 2006-04-15 | 2 | 2
3 | Michael | Johnson | 2007-02-20 | 3 | 3
4 | Emily | Williams | 2008-01-05 | 4 | 4
5 | David | Brown | 2009-03-10 | 5 | 5

## Teacher

ID | FirstName | LastName | HireDate | GradeLevelID | DisciplineID
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Grade_Level.LevelID) | (→ Academic_Discipline.DisciplineID)
1 | Mr. | Smith | 2010-08-20 | 1 | 1
2 | Ms. | Johnson | 2011-09-15 | 2 | 2
3 | Dr. | Williams | 2012-11-01 | 3 | 3
4 | Ms. | Baker | 2013-02-10 | 4 | 4
5 | Mr. | Thompson | 2014-03-20 | 5 | 5