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. |
ID | FirstName | LastName | BirthDate | DisciplineID |
---|---|---|---|---|
(→ Teaching_Subjects.DisciplineID) | ||||
1 | John | Doe | 2005-09-01 | 1 |
2 | Jane | Smith | 2006-04-15 | 2 |
3 | Michael | Johnson | 2007-02-20 | 3 |
4 | Emily | Williams | 2008-01-05 | 4 |
5 | David | Brown | 2009-03-10 | 5 |
ID | FirstName | LastName | HireDate | DisciplineID |
---|---|---|---|---|
(→ Teaching_Subjects.DisciplineID) | ||||
1 | Mr. | Smith | 2010-08-20 | 1 |
2 | Ms. | Johnson | 2011-09-15 | 2 |
3 | Dr. | Williams | 2012-11-01 | 3 |
4 | Ms. | Baker | 2013-02-10 | 4 |
5 | Mr. | Thompson | 2014-03-20 | 5 |