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 |