Welcome to the website for Halpin, Morgan: Information Modeling and Relational Databases, 2nd Edition.
Information Modeling and Relational Databases
About This Companion SiteThis site includes Solutions, Appendices, NORMA, VisioModeler and Errata
These are the odd numbered solutions. The even numbered solutions are for instructors only.
- AnswersOdd (1866KB Adobe Acrobat file)
- Appendix A Computer Generations (413KB Adobe Acrobat file)
- Appendix B Subtype Matrices (452KB Adobe Acrobat file)
- Appendix C Set-Comparison Queries in SQL (656KB Adobe Acrobat file)
- Appendix D Extrema and Ranking Queries in SQL (501KB Adobe Acrobat file)
- Appendix E Implementing Derivation Rules (465KB Adobe Acrobat file)
Information on how to get the free download of NORMA:
The Neumont ORM Architect (NORMA) tool for ORM 2 is available as a free, open source plug-in to Microsoft Visual Studio (2005 or later version). Currently you need at least the Standard version of Visual Studio (which may be purchased from Microsoft Corporation or resellers) in order to run the NORMA plug-in. NORMA may be downloaded either from the ORM Foundation at http://www.ormfoundation.org/files/ or from SourceForge at http://sourceforge.net/projects/orm
Visio ORM2 Drawing Stencil:
A Visio stencil and template for drawing ORM 2 schemas, as well as a sample schema, are accessible in the following zipped folder. This stencil requires Visio standard edition (or higher), and is for drawing only, not code generation. It is completely separate from the NORMA tool.
Information on how to get the free download of VisioModeler:
The former ORM tool known as VisioModeler is freely available as an unsupported product from Microsoft Corporation (as a 25 MB download). Note: This uses the old ORM 1 notation rather than the ORM 2 notation used in the second edition. Although VisioModeler works with versions of Microsoft Windows up to Windows XP, it does not work with Windows Vista.
To obtain the free VisioModeler download, go to http://download.microsoft.com which should take you to the following page http://www.microsoft.com/downloads/search/asp? where you can search by selecting Keyword Search, entering the keyword "VisioModeler" and selecting your operating system (e.g. Windows XP or Windows 2000). This should bring up a download page that includes the title "VisioModeler (Unsupported Product Edition)". Clicking on this will take you to the link for the download file MSVM31.exe. Click on this to do the download.
An errata file is being maintained at http://www.orm.net/Errata2.htm to note typos or other errors detected in the second edition of Information Modeling and Relational Databases.Click for current errata.
Information provided in this document is provided "as is" without warranty of any kind, either express or implied. Every effort has been made to ensure accuracy and conformance to standards accepted at the time of publication. The reader is advised to research other sources of information on these topics.
The user assumes the entire risk as to the accuracy and the use of this document. This document may be copied and distributed subject to the following conditions:
All text must be copied without modification and all pages must be included;
All copies must contain the appropriate copyright notice and any other notices provided therein; and
This document may not be distributed for profit.