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 |