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 |