## Students

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

## Academics

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

## Supervision

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

## Departments

DepartmentID | Name
--- | ---
1 | Computer Science
2 | Mathematics
3 | Physics
4 | Chemistry
5 | Biology

## CourseEnrollments

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

## Courses

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