## Topic

id | name | description
--- | --- | ---
1 | Mathematics | The study of numbers and numerical relationships.
2 | Physics | The natural science that involves the study of matter and energy.
3 | Biology | The study of living organisms and their interactions with each other and their environments.
4 | Chemistry | The study of substances at an atomic and molecular level.
5 | Computer Science | The study of computation, algorithms, data structures, and computer systems.

## Field_Of_Study

id | name | description
--- | --- | ---
1 | Applied Mathematics | A branch of mathematics concerned with practical applications.
2 | Theoretical Physics | A branch of physics focused on developing mathematical models to explain physical phenomena.
3 | Molecular Biology | The branch of biology dealing with molecules and chemical processes within living cells.
4 | Organic Chemistry | The branch of chemistry dealing with carbon-containing compounds.
5 | Artificial Intelligence | The simulation of human intelligence in machines programmed by humans.

## Project

id | title | details | topicId | fieldOfStudyId
--- | --- | --- | --- | ---
|  |  | (→ Topic.id) | (→ Field_Of_Study.id)
1 | Optimization Algorithms | Developing new optimization techniques. | 1 | 1
2 | Quantum Mechanics Experiment | Testing quantum mechanics predictions. | 2 | 2
3 | Gene Editing | Exploring CRISPR gene editing technology. | 3 | 3
4 | Reaction Kinetics | Investigating reaction rates in organic chemistry. | 4 | 4
5 | Machine Learning for Finance | Applying machine learning to financial data analysis. | 5 | 5

## Student

id | firstName | lastName | email | majorId
--- | --- | --- | --- | ---
|  |  |  | (→ Field_Of_Study.id)
1 | John | Smith | johnsmith@email.com | 1
2 | Jane | Doe | janedoe@email.com | 2
3 | Alice | Brown | alicebrown@email.com | 3
4 | Charlie | White | charliewhite@email.com | 4
5 | Emma | Green | emmagreen@email.com | 5

## Enrollment

id | studentId | projectId | grade | enrolledDate | completionDate
--- | --- | --- | --- | --- | ---
| (→ Student.id) | (→ Project.id) |  |  |
1 | 1 | 1 | 85 | 2021-09-01 | 2021-12-01
2 | 2 | 2 | 90 | 2021-09-01 | 2021-12-01
3 | 3 | 3 | 92.5 | 2021-09-01 | 2021-12-01
4 | 4 | 4 | 87.5 | 2021-09-01 | 2021-12-01
5 | 5 | 5 | 95 | 2021-09-01 | 2021-12-01

## Instructor

id | firstName | lastName | email | fieldOfStudyId
--- | --- | --- | --- | ---
|  |  |  | (→ Field_Of_Study.id)
1 | Dr. | Jones | drjones@email.com | 1
2 | Prof. | Smith | profsmith@email.com | 2
3 | Assoc. Prof. | Davis | assocprofdavis@email.com | 3
4 | Asst. Prof. | Martin | asstprofmartin@email.com | 4
5 | Lecturer | Wilson | lecturerwilson@email.com | 5