StudentID | FirstName | LastName | Major | Dissertation |
---|---|---|---|---|
1 | John | Doe | Computer Science | None |
2 | Jane | Doe | Mathematics | None |
3 | Alice | Smith | Physics | Quantum Computing |
4 | Bob | Johnson | Chemistry | Organic Chemistry |
5 | Charlie | Williams | Biology | Molecular Biology |
StaffID | FullName | Department |
---|---|---|
1 | Dr. Jane Smith | Computer Science |
2 | Dr. John Brown | Mathematics |
3 | Dr. Alice Green | Physics |
4 | Dr. Bob White | Chemistry |
5 | Dr. Charlie Black | Biology |
SupervisorID | StudentID | Thesis_Proposal |
---|---|---|
(→ Academics.StaffID) | (→ Students.StudentID) | |
1 | 1 | Machine Learning Techniques |
2 | 3 | Numerical Methods in Partial Differential Equations |
1 | 4 | None |
2 | 5 | None |
DepartmentID | Name |
---|---|
1 | Computer Science |
2 | Mathematics |
3 | Physics |
4 | Chemistry |
5 | Biology |
EnrollmentID | StudentID | CourseID | Grade |
---|---|---|---|
(→ Students.StudentID) | |||
1 | 1 | 101 | A |
2 | 2 | 201 | B |
3 | 3 | 301 | A |
4 | 4 | 401 | B |
5 | 5 | 501 | A |
CourseID | Title | InstructorID | DepartmentID |
---|---|---|---|
(→ Academics.StaffID) | (→ Departments.DepartmentID) | ||
1 | Introduction to Computer Science | 1 | 1 |
2 | Calculus I | 2 | 2 |
3 | General Physics | 3 | 3 |
4 | Organic Chemistry | 4 | 4 |
5 | Human Anatomy | 5 | 5 |