11 Relational Mapping

Abstract

This chapter discusses how to specify a relational database schema, and then details the procedure for mapping an object-role modeling conceptual schema to a relational database schema. Special attention is given to avoiding redundancy, mapping 1:1 associations; mapping external uniqueness constraints, mapping objectifications, and mapping subtypes.

Keywords

Relational database schema; ORM; Mapping an ORM schema to a relational schema; Constraint mapping; Subtype mapping

11.1 Implementing a Conceptual Schema

Most database modeling tools allow you to enter a ...

Get Information Modeling and Relational Databases, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.