id | first_name | last_name | 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 |
id | name | location |
---|---|---|
1 | Computer Science | San Francisco |
2 | Mathematics | Palo Alto |
id | name | city | state | country |
---|---|---|---|---|
1 | University of California | Los Angeles | CA | USA |
2 | Stanford University | Stanford | CA | USA |
student_id | course_id | semester | year | grade |
---|---|---|---|---|
(→ Students.id) | (→ Courses.id) | |||
1 | 1 | Spring | 2021 | A |
2 | 2 | Fall | 2021 | B+ |
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 |
id | first_name | last_name | department | office_location |
---|---|---|---|---|
1 | Dr. | Johnson | Computer Science | Room 123 |
2 | Professor | Williams | Mathematics | Room 456 |