Information Modeling and Relational Databases, 2nd Edition

6.1. Introduction to CSDP Step 6

So far you have learned how to verbalize examples in terms of elementary facts, draw the fact types, mark uniqueness constraints and mandatory roles, specify rules for derived fact types, and use simple and complex reference schemes to identify entities. The next step of the conceptual schema design procedure covers three kinds of constraints: value, set comparison, and subtype. Set-comparison constraints are themselves of three kinds: subset, equality, and exclusion.

CSDP step 6: Add value, subset, equality, exclusion, and subtype constraints

This chapter covers step 6 in detail. To clarify the formal concepts underlying the constraints, some basic set theory is first reviewed. Then we consider value constraints ...