MySQL Workbench identifying vs non-identifying relationship

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

The student >----< club is a many to many relation. One student can be in many clubs and on the most important -> one club can have many students, so there should be a junction table

romanh.
Автор

Thanks a lot for this useful explanation

muneermjmuneer
Автор

why isn't the student and club relation, as in the clubs to students, many to many?

KrithikDinakaranEpicnesss
Автор

Why is the foreign key under Clubs called "Student_ID" instead of "StudentID"?

adame