Non identifying relationship mysql
Non-Identifying Relationships have dotted lines, whereas Identifying Relationships have solid lines in MySQL Workbench. The difference is subtle but worth knowing. When you create an identifying relationship, the primary key of the child table becomes a foreign key in the parent table. Identifying relationships mean that the primary key of the parent entity is part of the natural key (supposedly composite unless the entities are ), and are not generally in fashion right now. In terms of database design, identifying vs. non-identifying is a pretty rare distinction in the real world. Identifying and Non-Identifying Relationships. An identifying relationship means that the child table cannot be uniquely identified without the parent. For example, you have this situation in the intersection table used to resolve a many-to-many relationship where the intersecting table's Primary Key is a composite of the left and right.