TAAFT
Free mode
100% free
Freemium
Free Trial
Deals
All 67 GPT 49 Mini Tools 6 Agents 2 Android 1 iOS 0 Chrome 0 APIs 0 Telegram 0
▼ Price

Erd generator

Other tools

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
Reply Share Report
Post
0 AIs selected
Clear selection
#
Name
Task