Colleges

college_idnamelocation
1University of CaliforniaLos Angeles
2Stanford UniversityPalo Alto
3New York UniversityNew York City
4Harvard UniversityCambridge
5Massachusetts Institute of TechnologyCambridge

Majors

major_idmajor_name
1Business Administration
2Computer Science
3Mathematics
4Physics
5History

Students

student_idfirst_namelast_nameemailenrollment_date
1JohnDoejohn.doe@example.com2021-09-01
2JaneSmithjane.smith@example.com2021-09-01
3AliceBrownalice.brown@example.com2021-09-01
4BobWhitebob.white@example.com2021-09-01
5CharlieBlackcharlie.black@example.com2021-09-01

Enrollments

enrollment_idstudent_idcollege_idmajor_id
(→ Students.student_id)(→ Colleges.college_id)(→ Majors.major_id)
1111
2211
3322
4423
5534

Courses

course_idcourse_codecourse_titlecreditsdepartment_id
1CS101Introduction to Computer Science41
2MA101Calculus I42
3PH101General Physics I33
4HIST101World History34
5BUS101Introductory Business Law35

Departments

department_iddepartment_name
1Computer Science
2Mathematics
3Physics
4History
5Business

Instructors

instructor_idfirst_namelast_nameemail
1JohnDoejohndoe@example.com
2JaneSmithjanesmith@example.com
3AliceBrownalicebrown@example.com
4BobWhitebobwhite@example.com