10.1. Join Constraints

This chapter considers several advanced modeling topics and assumes familiarity with the basics of ORM, Barker ER, and UML class diagrams. While the main focus is on ORM, some attention is also given to the other approaches. Even where ER and UML fail to provide built-in support for the features discussed, many of the ideas could be applied, at least as extensions, to these approaches.

This section examines join constraints, first considering join constraints over a single join path, then set-comparison constraints involving joins. Although consideration of these constraints is really part of CSDP step 7, we have postponed a detailed discussion of them until now because of their advanced nature.

The notion of conceptual ...

Get Information Modeling and Relational Databases, 2nd 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.