News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Conceptual data modeling in Visio

Started by ics, March 08, 2013, 11:53:45 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

ics

The built-in Database/Entity Relationship stencil (in 2010 Professional) is perfectly acceptable for logical and physical data modeling, however the problem for more abstract conceptual modeling is that the entity shape always has an attribute section (i.e. a 2nd rectangle under the rectangle containing the entity name rectangle). All I want there is a box showing the entity name, as in this picture web.mit.edu/itag/eag-0.1/EnterpriseDataModel.pdf, and not waste space with an empty attribute section. I have searched and found many similar observations, but the solutions seem to be to either create a new stencil for conceptual modeling (stencilpeterchen.codeplex.com/releases/view/29296) or to just use rectangles and crow's feet connectors. Since I want to create the conceptual model first, then refine it into the logical and physical by supplying more details (not redrawing from scratch) ... i.e., use the built-in power of foreign key relations and categories etc. ... I believe the solution instead is simply, how do I configure Visio to display the entity shape without the attrbute section?

I just learned on this board how to enter developer mode and edit the shape sheet, so I can resize a chosen entity shape (yes, I admit I'm a visio wimp) ... is this where I should go to edit the shape to have one rectangle and not two? (and hopefully to modify this at the global level for all entity shapes).

Thanks in advance!

Yacine

I can't try out the stencil you mention, but here's how I would try to the solve the problem.
You want the keep the functionality of the stencil, but add a special behaviour, which is to display entities with less information than the standard solution provides. Edit these entity shapes by making sure that you don't delete any of the important fields, but add a custom property field for your case (first design/detailed), then add the geometrical behaviour showing either the original version, or the modified one depending on that field.
HTH,Y.
Yacine

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 156 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1052KB.
Tokens: post-login.
Cache hits: 13: 0.00137s for 26,766 bytes (show)
Cache misses: 2: (show)
Queries used: 15.

[Show Queries]