Visio ERD Part 3

This video is the last of a three part tutorial that shows how to get started using Visio to create entities for an ERD. This video demonstrates how to connect entities through many-to-many relationships.

Category:

Education

Tags:

• Visio
• ERD

[ajtango]

in a ERD it is a rule to not have many to many lol i learnt that at basic level this is not how u draw a ERD in a real world situation

[pashortt]

You are correct. These videos are used as a foundation before normalization concepts are taught so students can conceptualize a M:N relationship before learning normalization.

[scottfrenz]

Thanks, but what you were clicking on to select style around 1:38 mark? The mouse went below the viewable area. Thanks!

[pashortt]

I say it in the video...right click then click Format and select Style

[dork2323]

You have to enable developer mode. Go to Tools->Options->Advanced->Run In Developer Mode

[paavenda]

Nice work.

[kr4zzym3]

excellent tutorial thanks :)

[eslamsamymeg]

nice work thnx alot for your efort it's simple & effective :)

[anthemofadam]

not working for me. I'm in developer mode, clicking apply and ok when I assign the ends. it just doesn't change.

[samarch2001]

For Visio 2010 to enable developer mode:

Go to File -> Options -> Advanced -> Under General section -> Select "Run in developer mode"...

[lunchmakerd]

does anybody know how to diagram a scenario where students are selecting 3 workshops to attend? the third selection would be an alternate class if one of the first two choices were not available. ive got a student table, a workshop table, an intersection entity(between student & workshop), school, and staff.

[abcd321839955]

For Many-to-Many relationship in your example, you had already created manually the "benifitId" attribute on the "SalariedEmployee" entity... which is, therefore, not identified as an FK by Visio... when you manually draw the many-to-many relationship.... Thus, in your final diagram, "EmpId" attribute on the "Benefits" entity is shown as an FK, but the "benifitId" attribute on the "SalariedEmployee" entity is simply a regular attribute... whereas both should be FK.