4. Uniqueness Constraints

4.1Introduction to CSDP Step 4
  • Static and dynamic constraints

  • Uniqueness constraints and arity checks

4.2Constraining Unaries and Binaries
  • Uniqueness constraints on unary fact types

  • Uniqueness constraints on binary fact types

4.3Constraining Longer Fact Types
  • Uniqueness constraints on ternaries

  • Uniqueness constraints on quaternaries, etc.

4.4External Uniqueness Constraints
  • Conceptual joins

  • External uniqueness constraints

4.5Arity Checks
  • Keys and functional dependencies

  • The n - 1 rule

  • Rephrasing as conjunctions

  • Objectified associations

4.6Projections and Joins
  • The projection operation

  • The projection-join check

4.7Summary

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.