## Colleges

college_id | name | location
--- | --- | ---
1 | University of California | Los Angeles
2 | Stanford University | Palo Alto
3 | New York University | New York City
4 | Harvard University | Cambridge
5 | Massachusetts Institute of Technology | Cambridge

## Majors

major_id | major_name
--- | ---
1 | Business Administration
2 | Computer Science
3 | Mathematics
4 | Physics
5 | History

## Students

student_id | first_name | last_name | email | enrollment_date
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 2021-09-01
2 | Jane | Smith | jane.smith@example.com | 2021-09-01
3 | Alice | Brown | alice.brown@example.com | 2021-09-01
4 | Bob | White | bob.white@example.com | 2021-09-01
5 | Charlie | Black | charlie.black@example.com | 2021-09-01

## Enrollments

enrollment_id | student_id | college_id | major_id
--- | --- | --- | ---
| (→ Students.student_id) | (→ Colleges.college_id) | (→ Majors.major_id)
1 | 1 | 1 | 1
2 | 2 | 1 | 1
3 | 3 | 2 | 2
4 | 4 | 2 | 3
5 | 5 | 3 | 4

## Courses

course_id | course_code | course_title | credits | department_id
--- | --- | --- | --- | ---
1 | CS101 | Introduction to Computer Science | 4 | 1
2 | MA101 | Calculus I | 4 | 2
3 | PH101 | General Physics I | 3 | 3
4 | HIST101 | World History | 3 | 4
5 | BUS101 | Introductory Business Law | 3 | 5

## Departments

department_id | department_name
--- | ---
1 | Computer Science
2 | Mathematics
3 | Physics
4 | History
5 | Business

## Instructors

instructor_id | first_name | last_name | email
--- | --- | --- | ---
1 | John | Doe | johndoe@example.com
2 | Jane | Smith | janesmith@example.com
3 | Alice | Brown | alicebrown@example.com
4 | Bob | White | bobwhite@example.com