## Students

StudentID | FirstName | LastName
--- | --- | ---
1 | John | Doe
2 | Jane | Smith
3 | Michael | Brown
4 | Emma | Wilson
5 | Chris | Jackson

## Platforms

PlatformID | PlatformName | University
--- | --- | ---
1 | Canvas | XYZ University
2 | Blackboard | ABC College
3 | Moodle | DEF Institute
4 | Google Classroom | GHI School
5 | Schoology | JKL Academy

## Departments

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.

## EnrolledStudents

EnrollmentID | StudentID | CourseID
--- | --- | ---
| (→ Students.StudentID) | (→ Courses.CourseID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5

## Courses

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

## Instructors

InstructorID | Name | Email
--- | --- | ---
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