Mini tools
▼ Top rated
Erd generator
Free mode
100% free
Freemium
Free Trial
Other tools
-
Transform photos into edgy fashion sketches.Open - Sponsor
Rocket - Think it. Type it. Launch it. -
Transform photos into striking grunge-style portraits.Open -
Open -
Create hilariously bad 3D art from ideas.Open -
Transform subjects into dazzling, jewel-adorned portraits.Open - Didn't find the AI you were looking for?
-
AI-powered comic book creation at your fingertipsOpen
Ask the community(1)
Hashan Tharuka
Nov 28, 2024
1. Tables and Relationships
User Table
Stores details of users, including students, instructors, and administrators.
Key Fields: UserID (Primary Key), Name, Role, Email, ContactNumber, EmploymentDate.
Relationships:
UserID is referenced as the instructor in the Course table.
UserID is referenced as the student in the Enrollment and Submission tables.
Course Table
Stores details of courses, such as title, credit hours, and associated instructors.
Key Fields: CourseID (Primary Key), Title, CreditHours, InstructorID.
Relationships:
InstructorID references the UserID in the User table.
CourseID is referenced in the Enrollment and Assignment tables.
Enrollment Table
Tracks student enrollments in courses, including enrollment dates and status.
Key Fields: EnrollmentID (Primary Key), StudentID, CourseID, EnrollmentDate, Status.
Relationships:
StudentID references the UserID in the User table.
CourseID references the CourseID in the Course table.
Assignment Table
Stores assignment details, including title, due date, maximum score, and associated courses.
Key Fields: AssignmentID (Primary Key), Title, DueDate, MaxScore, CourseID, InstructorID.
Relationships:
CourseID references the CourseID in the Course table.
InstructorID references the UserID in the User table.
Submission Table
Tracks student submissions for assignments, including scores and feedback.
Key Fields: SubmissionID (Primary Key), SubmissionDate, Score, Feedback, AssignmentID, StudentID.
Relationships:
AssignmentID references the AssignmentID in the Assignment table.
StudentID references the UserID in the User table.
Relationships Overview
A User can be a Student, Instructor, or Administrator.
A Course is managed by an Instructor and is taken by multiple Students.
An Enrollment connects a Student to a Course.
An Assignment is linked to a Course and created by an Instructor.
A Submission connects a Student to an Assignment
Post
