| student_id | name | major | | ---------- | ------- | ---------------- | | 1 | Alice | Computer Science | | 2 | Bob | Computer Science | | 3 | Charlie | Mathematics | | 4 | David | Mathematics |

| course_id | name | credits | major | mandatory | | --------- | ----------------- | ------- | ---------------- | --------- | | 101 | Algorithms | 3 | Computer Science | Yes | | 102 | Data Structures | 3 | Computer Science | Yes | | 103 | Calculus | 4 | Mathematics | Yes | | 104 | Linear Algebra | 4 | Mathematics | Yes | | 105 | Machine Learning | 3 | Computer Science | No | | 106 | Probability | 3 | Mathematics | No | | 107 | Operating Systems | 3 | Computer Science | No | | 108 | Statistics | 3 | Mathematics | No |

| student_id | course_id | semester | grade | GPA | | ---------- | --------- | ----------- | ----- | --- | | 1 | 101 | Fall 2023 | A | 4 | | 1 | 102 | Spring 2023 | A | 4 | | 1 | 105 | Spring 2023 | A | 4 | | 1 | 107 | Fall 2023 | B | 3.5 | | 2 | 101 | Fall 2023 | A | 4 | | 2 | 102 | Spring 2023 | B | 3 | | 3 | 103 | Fall 2023 | A | 4 | | 3 | 104 | Spring 2023 | A | 4 | | 3 | 106 | Spring 2023 | A | 4 | | 3 | 108 | Fall 2023 | B | 3.5 | | 4 | 103 | Fall 2023 | B | 3 | | 4 | 104 | Spring 2023 | B | 3 |