Students

StudentIDFirstNameLastNameMajorDissertation
1JohnDoeComputer ScienceNone
2JaneDoeMathematicsNone
3AliceSmithPhysicsQuantum Computing
4BobJohnsonChemistryOrganic Chemistry
5CharlieWilliamsBiologyMolecular Biology

Academics

StaffIDFullNameDepartment
1Dr. Jane SmithComputer Science
2Dr. John BrownMathematics
3Dr. Alice GreenPhysics
4Dr. Bob WhiteChemistry
5Dr. Charlie BlackBiology

Supervision

SupervisorIDStudentIDThesis_Proposal
(→ Academics.StaffID)(→ Students.StudentID)
11Machine Learning Techniques
23Numerical Methods in Partial Differential Equations
14None
25None

Departments

DepartmentIDName
1Computer Science
2Mathematics
3Physics
4Chemistry
5Biology

CourseEnrollments

EnrollmentIDStudentIDCourseIDGrade
(→ Students.StudentID)
11101A
22201B
33301A
44401B
55501A

Courses

CourseIDTitleInstructorIDDepartmentID
(→ Academics.StaffID)(→ Departments.DepartmentID)
1Introduction to Computer Science11
2Calculus I22
3General Physics33
4Organic Chemistry44
5Human Anatomy55