3

enter image description here

Many to many relationships should have a solid line, strong relationship. In the given diagram, ther right side sample is surely incorrect, the relationship line show be solid. However, what is the appropaite relationship for the left side diagram, should it be dashed (weak relationship) or solid?

user311509
  • 2,856
  • 12
  • 52
  • 69

2 Answers2

1

Many to many relationships should have a solid line, strong relationship.

What notation are you using? Looks like a variant of IE (Information Engineering).

At any rate, I guess this depends on the notation/conventions being used and in this particular case the logical model seems consistent with the physical one, except for the requirement that a Project must be connected to at least one Employee, which cannot be easily1 mapped to the physical database.

In the given diagram, ther right side sample is surely incorrect, the relationship line show be solid.

Not necessarily. There is nothing preventing you from migrating the parent PKs into an alternate key in the junction table and using a surrogate PK. This would make the relationships "non-identifying", warranting the usage of dashed lines.

1 It would require circular deferred FKs.

Community
  • 1
  • 1
Branko Dimitrijevic
  • 50,809
  • 10
  • 93
  • 167
  • I'm using Crow's Foot Noration. "There is nothing preventing you from migrating the parent PKs into an alternate key in the junction table and using a surrogate PK." Right, but i'm assuming the junction table has a fully borrowed PK without the intention of changing it to an alternate key in the future. – user311509 Sep 18 '12 at 00:08
0

https://help.drawerd.com/relationship/many-many

With DrawERD: simple web ui can do it. enter image description here

Hooopo
  • 1,380
  • 10
  • 16