online LMS

Tables (7)

Assignment (assignment)

  • AssignmentID (assignment_id) — varchar(50) — Primary key — NOT NULL
  • Deadline (deadline) — date
  • MaxMarks (max_marks) — int
  • CourseID (course_id) — varchar(50) — Foreign key → Course.CourseID — NOT NULL
  • SubmissionID (submission_id) — varchar(50) — Foreign key → Submission.SubmissionID — NOT NULL
  • StudentID (student_id) — varchar(50) — Foreign key → Student.StudentID — NOT NULL

Certificate (certificate)

  • CertificateID (certificate_id) — varchar(50) — Primary key — NOT NULL
  • IssueDate (issue_date) — date
  • StudentID (student_id) — varchar(50) — Foreign key → Student.StudentID — NOT NULL

Course (course)

  • CourseID (course_id) — varchar(50) — Primary key — NOT NULL
  • Title (title) — varchar(50)
  • Duration (duration) — int
  • Level (level) — int
  • StudentID (student_id) — varchar(50) — Foreign key → Student.StudentID — NOT NULL
  • InstructorID (instructor_id) — varchar(50) — Foreign key → Instructor.InstructorID — NOT NULL
  • InstructorID (instructor_id2) — varchar(50) — Foreign key → Instructor.InstructorID — NOT NULL

Enrollment (enrollment)

  • EnrollID (enroll_id) — varchar(50) — Primary key — NOT NULL
  • EnrollDate (enroll_date) — date
  • Status (status) — varchar(50)
  • StudentID (student_id) — varchar(50) — Foreign key → Student.StudentID — NOT NULL

Instructor (instructor)

  • InstructorID (instructor_id) — varchar(50) — Primary key — NOT NULL
  • FirstName (first_name) — varchar(50)
  • LastName (last_name) — varchar(50)
  • Expertise (expertise) — int

Student (student)

  • StudentID (student_id) — varchar(50) — Primary key — NOT NULL
  • FirstName (first_name) — varchar(50)
  • LastName (last_name) — varchar(50)
  • Email (email) — varchar(50)
  • Program (program) — varchar(50)
  • CourseID (course_id) — varchar(50) — Foreign key → Course.CourseID — NOT NULL

Submission (submission)

  • SubmissionID (submission_id) — varchar(50) — Primary key — NOT NULL
  • Date (date) — date
  • Marks (marks) — int
  • StudentID (student_id) — varchar(50) — Foreign key → Student.StudentID — NOT NULL