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