Object-Role Modeling Workbook: Data Modeling Exercises using ORM and NORMA by Terry HalpinObject-Role Modeling Workbook: Data Modeling Exercises using ORM and NORMA by Terry Halpin

Object-Role Modeling Workbook: Data Modeling Exercises using ORM and NORMA

byTerry Halpin

Paperback | January 29, 2016

Pricing and Purchase Info


Earn 250 plum® points

Prices and offers may vary in store


In stock online

Ships free on orders over $25

Not available in stores


Object-Role Modeling (ORM) is a fact-based approach to data modeling that expresses the information requirements of any business domain simply in terms of objects that play roles in relationships. All facts of interest are treated as instances of attribute-free structures known as fact types, where the relationship may be unary (e.g. Person smokes), binary (e.g. Person was born on Date), ternary (e.g. Customer bought Product on Date), or longer. Fact types facilitate natural expression, are easy to populate with examples for validation purposes, and have greater semantic stability than attribute-based structures such as those used in Entity Relationship Modeling (ER) or the Unified Modeling Language (UML).

All relevant facts, constraints and derivation rules are expressed in controlled natural language sentences that are intelligible to users in the business domain being modelled. This allows ORM data models to be validated by business domain experts who are unfamiliar with ORM’s graphical notation. For the data modeler, ORM’s graphical notation covers a much wider range of constraints than can be expressed in industrial ER or UML class diagrams, and thus allows rich visualization of the underlying semantics.

Written as a sequel to the author’s previous book Object-Role Modeling Fundamentals, this book briefly reviews the fundamentals of ORM, and then discusses additional topics such as model reports generation, vocabulary glossaries, relational mapping options, annotated relational schemas, schema optimization, and data modeling patterns. Written in easy-to-understand language, it illustrates each topic with simple examples, and explains how to use the freeware NORMA tool to implement the ideas discussed. The book also includes many practical exercises to promote expertise in the techniques covered, with answers provided to all the exercise questions.

Title:Object-Role Modeling Workbook: Data Modeling Exercises using ORM and NORMAFormat:PaperbackProduct dimensions:202 pages, 9.25 × 7.5 × 0.43 inShipping dimensions:9.25 × 7.5 × 0.43 inPublished:January 29, 2016Publisher:Technics Publications, IncorporatedLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:1634621042

ISBN - 13:9781634621045


Table of Contents

1 Review of ORM Basics 11.1 Introduction 11.2 ORM's Conceptual Schema Design Procedure 21.3 A Worked Example 31.4 Review Exercises 142 Documenting Models 212.1 Generating Model Reports 212.2 Vocabulary Glossaries 283 Relational Mapping 333.1 Overview of ORM's Relational Mapping Procedure 333.2 Downloading and Viewing a Sample NORMA Model 363.3 Controlling Table and Column Names in NORMA 383.4 Subtype Mapping Options 493.5 Annotating Relational Schemas 554 Modeling Exercises 594.1 Academic Conference 594.2 Course Prerequisites 604.3 Concert Bookings 604.4 British Monarchy 634.5 Malaysia Database 704.6 Nobel Prize Awards 784.7 Academy Awards 835 Transforming and Optimizing Schemas 895.1 Conceptual Schema Transformations 895.2 Conceptual Schema Optimization 985.3 Database Reengineering 1085.4 Solar System Exercise 1096 Some Data Model Patterns 1196.1 Temporal Aspects 1196.2 Collection Types 128Appendix A: ORM Symbol Glossary 133Appendix B: Further Resources 143Answers 145Index 183