| 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 |
| major_id | major_name |
|---|---|
| 1 | Business Administration |
| 2 | Computer Science |
| 3 | Mathematics |
| 4 | Physics |
| 5 | History |
| student_id | first_name | last_name | 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 |
| 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 |
| 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 |
| department_id | department_name |
|---|---|
| 1 | Computer Science |
| 2 | Mathematics |
| 3 | Physics |
| 4 | History |
| 5 | Business |
| instructor_id | first_name | last_name | |
|---|---|---|---|
| 1 | John | Doe | johndoe@example.com |
| 2 | Jane | Smith | janesmith@example.com |
| 3 | Alice | Brown | alicebrown@example.com |
| 4 | Bob | White | bobwhite@example.com |