Students

idnameagemajor
1John Doe20Computer Science
2Jane Smith19Biology
3Mike Johnson21Mathematics
4Emily Davis22Chemistry
5David Brown23Physics

Universities

iduniversityNameadmissionRaterankinglocation
1University of California0.678Los Angeles
2Stanford University0.531Palo Alto
3Harvard University0.513Boston
4Massachusetts Institute of Technology0.892Cambridge
5California Institute of Technology0.116Pasadena

Departments

iddepartmentNameuniversityId
(→ Universities.id)
1Department of Computer Science1
2Department of Biology2
3Department of Mathematics3
4Department of Chemistry4
5Department of Physics5

Enrollments

studentIDcourseIDsemestergradeenrollmentDate
(→ Students.id)(→ Courses.id)
11Fall 2021A2021-08-25
22Spring 2022B+2022-01-10
33Summer 2022A-2022-05-20
44Fall 2022A2022-08-25
55Winter 2023A2023-01-10

Courses

idcourseCodecourseTitlecreditHoursdepartmentId
(→ Departments.id)
1CS101Introduction to Computer Science41
2BIOL101General Biology42
3MATH101Elementary Calculus33
4CH101General Chemistry44
5PHYS101Classical Mechanics45