## Students

id | name | age | major
--- | --- | --- | ---
1 | Alice | 20 | Computer Science
2 | Bob | 21 | Mathematics
3 | Charlie | 22 | Physics
4 | David | 23 | Biology
5 | Eva | 24 | Chemistry

## Instructors

id | name | department
--- | --- | ---
1 | Dr. Smith | Computer Science
2 | Prof. Johnson | Mathematics
3 | Dr. Brown | Physics
4 | Dr. Wilson | Biology
5 | Dr. Taylor | Chemistry

## Courses

id | courseName | instructorId
--- | --- | ---
|  | (→ Instructors.id)
1 | Introduction to Computer Science | 1
2 | Advanced Calculus | 2
3 | General Physics | 3
4 | Ecology | 4
5 | Organic Chemistry | 5

## Projects

id | title | researchMethod | topic | studentId | courseId
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Students.id) | (→ Courses.id)
1 | Understanding AI Ethics | Case Study | Artificial Intelligence | 1 | 1
2 | Exploring Patterns in Mathematical Problems | Case Study | Mathematics | 2 | 2
3 | The Impact of Light Pollution on Wildlife | Case Study | Environmental Science | 3 | 3
4 | An Interview with Dr. Smith | Interview | Computer Science | 4 | 6
5 | Examining Sustainable Practices in Ecotourism | Interview | Environmental Science | 5 | 7
6 | Impacts of Climate Change on Biodiversity | Case Study | Environmental Science | 6 | 8
7 | Investigating Learning Styles in STEM Fields | Case Study | Education | 7 | 9
8 | Perspectives on Renewable Energy | Interview | Environmental Science | 8 | 10
9 | A Survey of Public Opinion on Genetic Engineering | Interview | Biotechnology | 9 | 11