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