## ResearchMethod

id | name
--- | ---
1 | Case Study
2 | Interview
3 | Survey
4 | Experiment
5 | Observation

## Topic

id | topicName
--- | ---
1 | Environmental Science
2 | Educational Technology
3 | Mathematics Education
4 | Physical Education
5 | Chemistry Education

## Professor

id | firstName | lastName | email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com
3 | Michael | Brown | michael.brown@example.com
4 | Emma | White | emma.white@example.com
5 | David | Black | david.black@example.com

## ResearchProjects

projectId | professorID | methodId | topicId
--- | --- | --- | ---
| (→ Professor.id) | (→ ResearchMethod.id) | (→ Topic.id)
1 | 1 | 1 | 1
2 | 2 | 1 | 2
3 | 3 | 2 | 1
4 | 4 | 2 | 3
5 | 1 | 3 | 1
6 | 2 | 4 | 1
7 | 3 | 5 | 1