Topic

idnamedescription
1MathematicsThe study of numbers and numerical relationships.
2PhysicsThe natural science that involves the study of matter and energy.
3BiologyThe study of living organisms and their interactions with each other and their environments.
4ChemistryThe study of substances at an atomic and molecular level.
5Computer ScienceThe study of computation, algorithms, data structures, and computer systems.

Field_Of_Study

idnamedescription
1Applied MathematicsA branch of mathematics concerned with practical applications.
2Theoretical PhysicsA branch of physics focused on developing mathematical models to explain physical phenomena.
3Molecular BiologyThe branch of biology dealing with molecules and chemical processes within living cells.
4Organic ChemistryThe branch of chemistry dealing with carbon-containing compounds.
5Artificial IntelligenceThe simulation of human intelligence in machines programmed by humans.

Project

idtitledetailstopicIdfieldOfStudyId
(→ Topic.id)(→ Field_Of_Study.id)
1Optimization AlgorithmsDeveloping new optimization techniques.11
2Quantum Mechanics ExperimentTesting quantum mechanics predictions.22
3Gene EditingExploring CRISPR gene editing technology.33
4Reaction KineticsInvestigating reaction rates in organic chemistry.44
5Machine Learning for FinanceApplying machine learning to financial data analysis.55

Student

idfirstNamelastNameemailmajorId
(→ Field_Of_Study.id)
1JohnSmithjohnsmith@email.com1
2JaneDoejanedoe@email.com2
3AliceBrownalicebrown@email.com3
4CharlieWhitecharliewhite@email.com4
5EmmaGreenemmagreen@email.com5

Enrollment

idstudentIdprojectIdgradeenrolledDatecompletionDate
(→ Student.id)(→ Project.id)
111852021-09-012021-12-01
222902021-09-012021-12-01
33392.52021-09-012021-12-01
44487.52021-09-012021-12-01
555952021-09-012021-12-01

Instructor

idfirstNamelastNameemailfieldOfStudyId
(→ Field_Of_Study.id)
1Dr.Jonesdrjones@email.com1
2Prof.Smithprofsmith@email.com2
3Assoc. Prof.Davisassocprofdavis@email.com3
4Asst. Prof.Martinasstprofmartin@email.com4
5LecturerWilsonlecturerwilson@email.com5