SQL Database Design » 5. Properties of Relationships

5. Properties of Relationships

Table of Contents

To create relational models, there's not much as prerequisite that you need to know about how to model entity types (~tables). Relationships are way harder to model, why you need to know more about them.

All relationships share a common set of properties. These properties determine the way a relationship is translated to SQL. The following properties are important for database design:

  • Degree
  • Type
  • Cardinality
  • Optionality
  • Navigability

An in-depth explanation of how to translate these properties to the relational model using SQL is given in chapter 13. Design Heuristics.

Last updated: 2010-10-13