| StudentID | FirstName | LastName |
|---|---|---|
| 1 | John | Doe |
| 2 | Jane | Smith |
| 3 | Michael | Brown |
| 4 | Emma | Wilson |
| 5 | Chris | Jackson |
| PlatformID | PlatformName | University |
|---|---|---|
| 1 | Canvas | XYZ University |
| 2 | Blackboard | ABC College |
| 3 | Moodle | DEF Institute |
| 4 | Google Classroom | GHI School |
| 5 | Schoology | JKL Academy |
| DepartmentID | DepartmentName | Description |
|---|---|---|
| 1 | Computer Science | This department offers courses in computer science. |
| 2 | Mathematics | The mathematics department provides a variety of math courses. |
| 3 | Physics | Our physics department is known for its cutting-edge research facilities. |
| 4 | Biology | We offer a comprehensive curriculum in biology at all levels. |
| 5 | English | Our English department focuses on literature and writing. |
| EnrollmentID | StudentID | CourseID |
|---|---|---|
| (→ Students.StudentID) | (→ Courses.CourseID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 3 |
| 4 | 4 | 4 |
| 5 | 5 | 5 |
| CourseID | Title | DepartmentID | Semester | Year |
|---|---|---|---|---|
| (→ Departments.DepartmentID) | ||||
| 1 | Introduction to Computer Science | 1 | Fall | 2020 |
| 2 | Calculus I | 2 | Spring | 2020 |
| 3 | General Physics I | 3 | Fall | 2020 |
| 4 | Introductory Biology | 4 | Spring | 2020 |
| 5 | Composition and Rhetoric | 5 | Fall | 2020 |
| InstructorID | Name | |
|---|---|---|
| 1 | Dr. John Doe | johndoe@xyzuniversity.edu |
| 2 | Professor Jane Smith | janesmith@abccollege.edu |
| 3 | Assoc Prof Michael Brown | michaelbrown@definstitute.edu |
| 4 | Asst Prof Emma Wilson | emmawilson@ghischool.edu |
| 5 | Adjunct Chris Jackson | chrisjackson@jkllacademy.edu |