| 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 |