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