Entity-relationship model diagrams in Visio

Question

I would love to create some database diagrams like this one with Visio but I can't find any templates at all for that kind of notation. The example I linked to was apparently made in Photoshop, which sounds like a terrible way to make ERDs. Are there any good Visio templates for this sort of thing?

(I have Visio 2010 Pro, by the way.)

Won't have the fancy-smancy colors, but have you looked at Dia? — Edward Strange, Feb 23 '11 at 17:26
Removed my answer, wasn't helpful. I did not click your picture. That picture doesn't look like any official diagram type I know. My guess is that the creator just used basic shapes and gave them his own colours. — KeesDijk, Feb 23 '11 at 19:06
@KeesDijk - It's called [Chen's notation](http://www.essentialstrategies.com/publications/modeling/chen.htm). — Andrew, Feb 23 '11 at 20:38
check http://www.smartdraw.com/resources/tutorials/cardinality-notations/ — amr osama, May 04 '11 at 08:22

score 6 · Accepted Answer · answered Feb 23 '11 at 19:20

6

If you want to create a diagram like the one you linked to, then you need to find a Chen ERD shape pack. You can check the following site: http://www.visiocafe.com/various.htm . Specifically try http://www.visiocafe.ca/downloads/various/DanielHarris/Chen_ER.zip

edit: I don't know if that specific pack will work with Visio 2010. I've never used it.

answered Feb 23 '11 at 19:20

Curtis Batt

4,794
1
14
13

Is anyone know about Extended Entity Relationship? Because my lecturer ask me to draw it using Visio but seems it doesn't have one like generalize/specialize notation that is like a fork between entity – Benyamin Limanto Oct 28 '20 at 15:14

score 0 · Answer 2 · answered Feb 23 '11 at 19:40

0

Visio should have a DB reverse-engineering feature (unless that's now only available in the top-end version). I've used it before and it does an adequate job, my advice is to break your ERD down into logical sections and don't diagram more than ten tables at a time (unless you have access to an E-size plotter). And be prepared to do a lot of tweaking to get things laid out; I don't think I've ever reverse-engineered an ERD that was comprehensible at first, even with big-name tools like ErWIN and ER/Studio.

answered Feb 23 '11 at 19:40

TMN

11,313
1
21
31

It is: [Create-a-Database-Model-also-known-as-Entity-Relationship-diagram](https://support.office.com/en-us/article/Create-a-Database-Model-also-known-as-Entity-Relationship-diagram-7042e719-384a-4b41-b29c-d1b35719fc93) – sra Dec 30 '14 at 19:59
Yes, it is not available on Visio Standard Edition! – Marcus D Mar 31 '20 at 15:47

Entity-relationship model diagrams in Visio

2 Answers2