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 |