VeriIA
Mini tools
▼ State of the art
Erd generator
Free mode
100% free
Freemium
Free Trial
Other tools
-
Specializes in modern, candid portrait-style age transformations.Open - Spotlight: VeriIA (AI content detection)
-
Expert on Urawa Red Diamonds, offering detailed club history and player info.Open -
Driving efficient back-end processes through innovative solutions.Open - Didn't find the AI you were looking for?
-
Your front-end web dev assistant with code examples and advice.Open -
Designs and builds user-friendly website interfaces.Open -
Acting as a front-end interviewer from a major tech company.Open -
Solve front-end development problems with AI.Open -
Your go-to guide for After The End: The Harvest.Open -
Guiding players through the Dream of the Red Chamber RPGOpen
-
Synthesize life and catalyze change.Open -
Open -
Grades op-eds with reasoning, engagement, and open-mindedness.Open -
Open -
Expert on 'Dream of the Red Chamber' charactersOpen -
Open -
Pro yet engaging guide in low-code 1ERP implementation & customizationOpen -
Sharing the art and hobby of puppetry enthusiastically.Open
-
Effortless and cheerful content creation and e-commerce optimization consultant.Open -
Making business jargon fun with humor and analogies.Open -
Eradicate Cervical Cancer with Trustworthy HPV InformationOpen
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
