What the Heck is an Entity Instance Diagram?
I was recently contacted by a friend who is taking a database design course for some help in understanding an assignment. His first task was to create a conceptual data model and then prepare entity instance diagrams for that data model. He was wondering what an entity instance diagram was. So was I, as I had not heard that term before. So I fired off a search and came up with only one hit:
I’m pretty sure that’s the first time I’ve every unintentionally found only one returned result for a search term before. Unfortunately that one webpage has broken images, so I couldn’t see what one looked like. So I told my friend:
I was thinking of examples such as the ones in Simsion & Witt’s Data Modeling Essentials [aff link]:
I did some more looking around and using Bing, found one more result which pointed to a PowerPoint slide deck by Ellis Cohen from his course on Theory, Practice & Methodology of Relational Database Design and Programming. In this deck I found an example of what he calls an entity instance diagram, which pretty much is what I thought it was. I’ve been creating an using these sorts of things to explain how a data model should be used but I never had a name for them. I called them sample data, data prototypes, data validation , worked examples, or just examples. Now we have a name and a TLA!
In Cohen’s slide, he’s using an Entity Instance Diagram (EID) to to demonstrate weak entities:
I usually use Excel to prepare these, as I can reuse the data for each one. I even have an ER/Studio macro to generate the tabs in a spreadsheet (one for each entity/table selected in a submodel). This makes preparing the sample data go much faster.
So it looks like we have an answer now for what the heck is an entity instance diagram….and I have a name for a technique that I use all the time. If you have other examples of this term, I’d love to see them.

Subscribe via E-mail
Recent Comments
Categories
Downloads
- 476275616.jpg
- favicon
- Refactoring Computer Engineer Barbie
- 10 Things I Hate About Interviewing with You
- EDW 2013 Karen Lopez Get Blogging
- Karen Lopez presentation DAMA PS 2012
- Data Modeling Contentious Issues - DAMA Nebraska
- Karen Lopez - 10 Physical Blunders - DAMA
- Career Success In Data Profession - DAMA
- The Straw Poll
- You've Just Inherited a Data Model CheckList
- KarenLopez - 5 Physical Blunders - 24HOP-2011
- Handouts for OEMUG / CA Global Modeling User Group Why Be Normal Webcast
- Handouts Database Design Contentious Issues - New York 2010
- Handouts Database Design Contentious Issues - DC 2010
Archive
Recent Posts
Archives
- November 2018
- May 2018
- April 2018
- December 2017
- August 2017
- September 2016
- August 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- January 2016
- December 2015
- November 2015
- September 2015
- July 2015
- June 2015
- May 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- September 2010
- August 2010
- July 2010
- February 2009