StudentID | FirstName | LastName | Personal_Computing_Devices | Operating_System | EmailAddress |
---|---|---|---|---|---|
1 | John | Doe | Tablet | Windows 10 | john.doe@example.com |
2 | Jane | Smith | Phone | iOS | jane.smith@example.com |
3 | Mike | Brown | Laptop | Windows 10 | mike.brown@example.com |
4 | Emily | White | Desktop | macOS | emily.white@example.com |
5 | David | Green | Tablet | Android | david.green@example.com |
6 | Amy | Black | Laptop | Linux | amy.black@example.com |
InstructorID | FirstName | LastName | Department |
---|---|---|---|
1 | Professor | Adams | Mathematics |
2 | Dr. | Johnson | Physics |
3 | Assistant | Williams | Biology |
4 | Associate | Taylor | English Literature |
5 | Professor | Thompson | History |
6 | Dr. | Martin | Geography |
CourseID | Title | Description | InstructorID |
---|---|---|---|
(→ Instructors.InstructorID) | |||
1 | Calculus I | Introduction to Calculus | 1 |
2 | General Physics | Introduction to Classical Mechanics | 2 |
3 | Introductory Biology | Cellular and Molecular Biology | 3 |
4 | Modern English Literature | Survey of British Literature since 1900 | 4 |
5 | World History | Global Civilizations Since 1500 CE | 5 |
6 | Human Geography | Regional Geographies of the World | 6 |
EnrollmentID | StudentID | CourseID | Grade |
---|---|---|---|
(→ Students.StudentID) | (→ Courses.CourseID) | ||
1 | 1 | 1 | A |
2 | 1 | 2 | B+ |
3 | 2 | 2 | A- |
4 | 3 | 3 | B |
5 | 4 | 4 | A |
6 | 5 | 5 | A |
7 | 6 | 6 | B |