Students

idfirst_namelast_nameemailphone_numbercollegeuniversity
1JohnDoejohn.doe@example.com555-123-4567Computer ScienceUniversity of California
2JaneSmithjane.smith@example.com555-987-6543MathematicsStanford University

Colleges

idnamelocation
1Computer ScienceSan Francisco
2MathematicsPalo Alto

Universities

idnamecitystatecountry
1University of CaliforniaLos AngelesCAUSA
2Stanford UniversityStanfordCAUSA

CourseEnrollments

student_idcourse_idsemesteryeargrade
(→ Students.id)(→ Courses.id)
11Spring2021A
22Fall2021B+

Courses

idtitledescriptioncredits
1Introduction to Computer ScienceAn overview of computer science concepts and programming languages.4
2Calculus IBasic principles of calculus including limits, derivatives, and integrals.4

Professors

idfirst_namelast_namedepartmentoffice_location
1Dr.JohnsonComputer ScienceRoom 123
2ProfessorWilliamsMathematicsRoom 456