Day 15 - Data model

Here is the data model about the data used in the LMS Learning Analytics. I will go over them in the details sections.

• Student Course Enrollment

• Instructor Enrollment

• Course Assignments and submissions

• Web Access

Student Course Enrollment

Here are the rules Canvas data model

• The Student and Course Section has many to many relationships.

  • Each student can enroll in multiple course sections.

  • A course section can have multiple students.

• A course can have zero or multiple course sections but each course section must belong to one and only one course.

• An account can have zero or multiple courses but each course must belong to only one account.

• An enrollment term can have zero or multiple course sections but each course section must belong to only one term.

Instructor Enrollment

• Instructor and Course Section has many to many relationships

  • Each instructor can enroll in multiple course sections.

  • A course section can have multiple instructors.

• A course can have zero or multiple course sections but each course section must belong to only one course.

• An account can have zero or multiple courses but each course must belong to only one account.

• An enrollment term can have zero or multiple course sections but each course section must belong to only one term.

Course Assignments and submissions

• A course has zero or multiple assignments but each assignment must belong to only one course.

• A student has zero or multiple submissions but each submission must belong to only one student.

• An assignment has zero or multiple submissions but each submission must belong to only one assignment.

Wiki Pages and Access

• A wiki has zero or multiple wiki pages but each wiki page must belong to only one wiki.

• A student has zero or multiple accesses but each access must belong to only one student.

• Access has zero or multiple wiki pages but each wiki page must belong to only one access.