Halpin, Morgan: Information Modeling and Relational Databases, 2nd Edition

Solutions

These are the odd numbered solutions. The even numbered solutions are for instructors only.

• AnswersOdd   (1866KB Adobe Acrobat file)

Appendices

• 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)

NORMA

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.

VisioModeler

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.

Errata

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.