I need the structure of the assignment table and the link between students and teachers. Any idea of how to do that?

CodePudding user response：

You can have separate table for assignment,students and teachers then create a new table like assigned_assignments having column student_id,teacher_id,assignment_id

CodePudding user response：

Hints:

• A student can be taught by multiple teachers.
• A teacher can teach multiple students.
• A student can submit multiple assignments.

So between student and teacher entity, relationship will be many to many. And Assignment table will have two foreign keys, one reference to student ID, other reference to teacher ID.