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 |