Teaching_Subjects

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.

Student

IDFirstNameLastNameBirthDateDisciplineID
(→ Teaching_Subjects.DisciplineID)
1JohnDoe2005-09-011
2JaneSmith2006-04-152
3MichaelJohnson2007-02-203
4EmilyWilliams2008-01-054
5DavidBrown2009-03-105

Teacher

IDFirstNameLastNameHireDateDisciplineID
(→ Teaching_Subjects.DisciplineID)
1Mr.Smith2010-08-201
2Ms.Johnson2011-09-152
3Dr.Williams2012-11-013
4Ms.Baker2013-02-104
5Mr.Thompson2014-03-205