Data Model (IDEF1X)
Allows you to draw IDEF1X compliant Data Models (starts on the second page). IDEF1X is a standard for modelling Relational databases independent of the applications that use it; it emphasises proper use of keys, and promotes quality and ease of use. This stencil is pure IDEF1X, with the exception that Relations are rendered in IEEE notation (which is more universally recognised). Notes and guidelines are included (drag the stencil to its full size and hover over the labels), and a few extensions to the standard are provided.
It is set up for an enhancement, Hierarchical Layout, that increases cognition. Every Entity has an order in Relation to any other Entity, therefore I draw my IDEF1X models showing that order vertically, parent above the child (magnets at top and bottom only); SubTypes which are the same order as the SuperType, are connected horizontally (magnets on the sides). Any other one-to-one Relation, and silly things such as optional parents (null keys), breaches the standard and is not provided.
If you are in the early stages of analysis and design, the simpler Entity Relation Diagram (first page) may be more appropriate, for which you can use the ERD stencil.
Stencil Version 2.2/12 Feb 11 (I make improvements and maintain the stencil on Graffletopia.) Please send feedback to derek.asirvadem@gmail.com more…
Added on April 28, 2010 • 7,503 downloads • 12 favorites
-
OmniGraffle
-
OmniGraffle Pro
-
OmniGraffle for iPad
Comments
DerekAsirvadem — almost 2 years ago
I am receiving questions re the coprytight notice. For those who are not sure about ownership, copyright and attribution: • IDEF1X became an NIST standard for Data Modelling in 1993, published in FIPS Publication 184; it is public domain. The symbols and notation are IDEF1X, you can draw it using any tool you like. (Software Engineering, Modelling and Normalisation are the subject of formal education.) • OmniGraffle is software, owned and licensed by the Omni Group. • The STENCIL is my work, for which I own perpetual Moral Rights. • Because I have published it in the public domain, you are free to copy the stencil, which of course makes useable in OmniGraffle, to draw your diagrams. • Because I have published it with a copyright notice, you are free to copy the stencil and use it, only as a single article, and with the copyright notice intact.
• "Copyright" does not mean "it cannot be copied", it means I am claiming ownership and asserting my rights. ("All rights reserved" means it cannot be copied.) • That means, if anyone asks you how you drew such a beautiful model, you say that you drew it with OmniGraffle using Derek's stencil. Or if they ask who created the stencil, you provide proper attribution. • You are free to change the symbols to suit your drawing preferences and style, but you must retain the copyright notice intact; you can add symbols and copyright those symbols yourself. • You are NOT allowed to copy the symbols, change them, and attribute them to yourself.
Enjoy
Login to add your comment