| 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. |
| 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 |
| 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 |
| 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 |