LMS ERD (1).drawio
LMS ERD (1).drawio
LMS ERD (1).drawio
Attendance
F.Name L.Name
1 1
ds
or
O
Name c
cc
1 Re
ur
s
In
1
UserID Password Email
N
Role
rs
to
en
M
M
Recorded
Link
N M
Take
N M
user attened session Attendee
1
submits S.Type
N
STime Date SessionID
Assignment 1 N
Quiz
t
Poin
Total
M
Due Date
N
Enrolls
ex
pl
N
ai
ns
M 1
N
Belongs to
N
contains
1
Teaches
N
1 N
Contains Content
Question course
Options
English Requirement Document
This LMS uniquely identifies users through a UserID and provides each of them with details such as email, password, and
role. Users may be classified either as students, instructors, or administrators. They may themselves enroll in courses
represented by a unique CourseID with title, description, final grade, and the accompanying announcements. Each course
further includes different content items identified through a unique ContentID and classification type, such as PDF or video,
and has a title, description, and ordering information associated with them. Courses further include sessions that are
identifiable by SessionID, which logs attendance associated with each session type, such as lecture or lab, along with a list
of participants, including their attending instructor. Attendance records in sessions include dates and times for tracking
purposes. LMS also includes assignments, and each assignment catalogs each AssignmentID, its title, description, due
date for submission, feedback upon assessments, and a grade. Assignments are submitted by students for grading while
instructors assess their students' submissions and allocate points based on the grading assessment given to the
assignments. Also featured in courses is the quiz, identified through the use of QuizID consisting of total points, due date
for submission, and title. Each quiz is further made up of several questions, where each question records a QuestionID,
question text content, and allocated points, as well as correct answers, question types, and options if it takes two or more
choices. Furthermore, mentorship ties allow for the possibility of having one user mentor another. The LMS provides
structured functionality for administering users, courses, content, sessions, assignments, quizzes, and mentorship to
facilitate a seamless learning experience.