Academic_Discipline

DisciplineIDNameDescription
1MathematicsThe study of numbers and their properties.
2PhysicsThe study of matter and energy and how they interact.
3BiologyThe study of living organisms and their interactions with their environment.
4ChemistryThe study of substances and their interactions.
5HistoryThe study of past events and their causes and effects.

Grade_Level

LevelIDNameMinAgeMaxAge
1PreKindergarten34
2Kindergarten45
31st Grade56
42nd Grade67
53rd Grade78

Student

IDFirstNameLastNameBirthDateGradeLevelIDDisciplineID
(→ Grade_Level.LevelID)(→ Academic_Discipline.DisciplineID)
1JohnDoe2005-09-0111
2JaneSmith2006-04-1522
3MichaelJohnson2007-02-2033
4EmilyWilliams2008-01-0544
5DavidBrown2009-03-1055

Teacher

IDFirstNameLastNameHireDateGradeLevelIDDisciplineID
(→ Grade_Level.LevelID)(→ Academic_Discipline.DisciplineID)
1Mr.Smith2010-08-2011
2Ms.Johnson2011-09-1522
3Dr.Williams2012-11-0133
4Ms.Baker2013-02-1044
5Mr.Thompson2014-03-2055