## Students

id | name | age | major
--- | --- | --- | ---
1 | John Doe | 20 | Computer Science
2 | Jane Smith | 19 | Biology
3 | Mike Johnson | 21 | Mathematics
4 | Emily Davis | 22 | Chemistry
5 | David Brown | 23 | Physics

## Universities

id | universityName | admissionRate | ranking | location
--- | --- | --- | --- | ---
1 | University of California | 0.67 | 8 | Los Angeles
2 | Stanford University | 0.53 | 1 | Palo Alto
3 | Harvard University | 0.51 | 3 | Boston
4 | Massachusetts Institute of Technology | 0.89 | 2 | Cambridge
5 | California Institute of Technology | 0.11 | 6 | Pasadena

## Departments

id | departmentName | universityId
--- | --- | ---
|  | (→ Universities.id)
1 | Department of Computer Science | 1
2 | Department of Biology | 2
3 | Department of Mathematics | 3
4 | Department of Chemistry | 4
5 | Department of Physics | 5

## Enrollments

studentID | courseID | semester | grade | enrollmentDate
--- | --- | --- | --- | ---
(→ Students.id) | (→ Courses.id) |  |  |
1 | 1 | Fall 2021 | A | 2021-08-25
2 | 2 | Spring 2022 | B+ | 2022-01-10
3 | 3 | Summer 2022 | A- | 2022-05-20
4 | 4 | Fall 2022 | A | 2022-08-25
5 | 5 | Winter 2023 | A | 2023-01-10

## Courses

id | courseCode | courseTitle | creditHours | departmentId
--- | --- | --- | --- | ---
|  |  |  | (→ Departments.id)
1 | CS101 | Introduction to Computer Science | 4 | 1
2 | BIOL101 | General Biology | 4 | 2
3 | MATH101 | Elementary Calculus | 3 | 3
4 | CH101 | General Chemistry | 4 | 4
5 | PHYS101 | Classical Mechanics | 4 | 5