| 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. |
| 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. |
| 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 |
| id | firstName | lastName | 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 |
| 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 |
| id | firstName | lastName | 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 |