Consider the following many to many relationship A student can take many classes

Question

Consider the following many to many relationship A student can take many classes Many classes can be taken by many students What would be the most appropriate way to handle the foreign keys to maintain this relationship? a) Create a new table that has a foreign key reference to both student and classes b) Create a foreign key in student that references classes c) Create a foreign key in classes that references students d) Combine the two tables into a single table that ahs properties of both student and classes e) This is not possible to model in MySQL and must be handled in the application logic

Explanation / Answer

The answer is
c) Create a foreign key in classes that reference students.

This is because relation from Classes to Student is one to many and it will suitably hold the relation between student and class.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.