Students

StudentIDFirstNameLastName
1JohnDoe
2JaneSmith
3MichaelBrown
4EmmaWilson
5ChrisJackson

Platforms

PlatformIDPlatformNameUniversity
1CanvasXYZ University
2BlackboardABC College
3MoodleDEF Institute
4Google ClassroomGHI School
5SchoologyJKL Academy

Departments

DepartmentIDDepartmentNameDescription
1Computer ScienceThis department offers courses in computer science.
2MathematicsThe mathematics department provides a variety of math courses.
3PhysicsOur physics department is known for its cutting-edge research facilities.
4BiologyWe offer a comprehensive curriculum in biology at all levels.
5EnglishOur English department focuses on literature and writing.

EnrolledStudents

EnrollmentIDStudentIDCourseID
(→ Students.StudentID)(→ Courses.CourseID)
111
222
333
444
555

Courses

CourseIDTitleDepartmentIDSemesterYear
(→ Departments.DepartmentID)
1Introduction to Computer Science1Fall2020
2Calculus I2Spring2020
3General Physics I3Fall2020
4Introductory Biology4Spring2020
5Composition and Rhetoric5Fall2020

Instructors

InstructorIDNameEmail
1Dr. John Doejohndoe@xyzuniversity.edu
2Professor Jane Smithjanesmith@abccollege.edu
3Assoc Prof Michael Brownmichaelbrown@definstitute.edu
4Asst Prof Emma Wilsonemmawilson@ghischool.edu
5Adjunct Chris Jacksonchrisjackson@jkllacademy.edu