Relationships Best Practices

Naming Conventions

Description

  • A description of what that relationship is used for can be extremely useful for audit purposes and peer review tracking.

Cardinality

  • Think about how the cardinality is structured. For example, the relationship between Department and Employees is a one to many relationship, and the name should reflect this. A good name would be Department - Employees. The "one" end of the relationship has a singular name and the "many" end has a plural name.