O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

3    Relational Mapping

ORM includes a Relational mapping (Rmap) procedure for mapping an ORM schema to a relational database schema. Mainly to assist you with relational mapping aspects of later exercises, this chapter provides an overview of the basic steps in the Rmap procedure. It also discusses some relational mapping options supported by NORMA that were not covered in my previous book.

3.1    Overview of ORM’s Relational Mapping Procedure

The main steps in ORM’s Rmap procedure are summarized in Table 3.1. NORMA performs most of these steps automatically, generating a relational schema in fifth normal form by default. The most important ideas behind the way Rmap groups ORM fact types into relational table schemes are contained in steps ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required