My ERM database (entity relationship model) has an entity type TEACHERthat is associated with an entity type SUBJECT_MODULE(since different modules in each subject are taught by different teachers and for some modules even different chapters in each module can be taught by different teachers) by type of relationship TEACH.
This is an attitude N:M, since each teacher can teach many subject modules, and each module can be taught by several teachers.
But, in my opinion, it does not identify the connection, because the subject module does not depend on the fact that the teacher is uniquely identified; Please say this if you do not agree with this.
But from this tutorial (although it simply says: “Relationship identification is usually used for connection tables created from a multilingual interface, many relationships.”), And finding out that the ERD modeling tool for MySQL Workbench contains only one tool for modeling the M: N relationship , which is intended for " identifying N:M relationship", at least the hint prompts like this ... I wonder if the N: M relation is always or not always the defining relation. Please clarify this to me. Thank.
source
share