NORMA (Natural ORM Architect for Visual Studio) is a software based conceptual modeling tool based on object-role modeling (ORM), and is a free and open source plug-in to Microsoft Visual Studio 2005, Visual Studio 2008, Visual Studio 2010, Visual Studio 2012, Visual Studio 2013 and Visual Studio 2015. It supports ORM 2 (second generation ORM), and maps ORM models to a variety of implementation targets, including major database engines, object-oriented code, and XML schema.
Contents
Dr. Terry Halpin's latest book, Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design "...uses the notation of ORM 2 (second generation ORM), as supported by the NORMA (Neumont ORM Architect) tool..." (page 10), and "(...)At the time of writing, the Neumont ORM Architect (NORMA) tool provides the most complete support for the ORM 2 notation discussed in this book." (Preface, xxv).
He also states: "A modeling method as good as ORM deserves a good CASE tool. Since the early 1990's, talented staff at ServerWare, Asymetrix Corporation, InfoModelers Incorporated, Visio Corporation, Microsoft Corporation, Neumont University have worked to develop state of the art CASE tools to support the specific ORM method discussed in this book. The following talented individuals currently working as lead software engineers on the NORMA tool deserve special mention: Matt Curland and Kevin Owen." (Preface, xxvi)
ORM2
ORM2 (second-generation ORM) is a new incarnation of object-role modeling as well as a new modeling tool to support the new notation. Dr. Terry Halpin is leading the effort spearheaded by Neumont University and later continued through The ORM Foundation, a UK-based non-profit organization dedicated to the promotion of the fact-oriented approach to information modeling
ORM 2 is both a metamodel that defines an ORM2 model and a tool (NORMA) for creating ORM2 models. The NORMA (Natural ORM Architect) tool is an open source project. ORM2 leverages the work done by the BSBR group.
The main objectives for the ORM 2 graphical notation are:
Project
As of March 2014 the NORMA project continues to deliver frequent releases and is almost ready to encompass the entire life-cycle of databases. Official CTPs are always posted to the ORM Foundation Library.