## Students

id | first_name | last_name | email | phone_number | college | university
--- | --- | --- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 555-123-4567 | Computer Science | University of California
2 | Jane | Smith | jane.smith@example.com | 555-987-6543 | Mathematics | Stanford University

## Colleges

id | name | location
--- | --- | ---
1 | Computer Science | San Francisco
2 | Mathematics | Palo Alto

## Universities

id | name | city | state | country
--- | --- | --- | --- | ---
1 | University of California | Los Angeles | CA | USA
2 | Stanford University | Stanford | CA | USA

## CourseEnrollments

student_id | course_id | semester | year | grade
--- | --- | --- | --- | ---
(→ Students.id) | (→ Courses.id) |  |  |
1 | 1 | Spring | 2021 | A
2 | 2 | Fall | 2021 | B+

## Courses

id | title | description | credits
--- | --- | --- | ---
1 | Introduction to Computer Science | An overview of computer science concepts and programming languages. | 4
2 | Calculus I | Basic principles of calculus including limits, derivatives, and integrals. | 4

## Professors

id | first_name | last_name | department | office_location
--- | --- | --- | --- | ---
1 | Dr. | Johnson | Computer Science | Room 123
2 | Professor | Williams | Mathematics | Room 456