Skip to content
Astera Technology

Specify counts on both sides of a record relationship

State minimum and maximum links separately for each direction.

Compare the rule with concrete cases

Original fictional model: an asset may have zero or many observation records; each observation belongs to exactly one asset. An asset without observations is permitted. An observation linked to two assets is not.

Filled synthetic modelling cases
CaseAsset observationsAssets per observationResult
K10No observation existsValid asset
K231 eachValid relationship
K31 shared observation2Invalid observation link
Download editable CSV ↓

Work through the distinction

“One-to-many” shorthand leaves minimums unclear. Write both directions with zero, one or many so an empty but legitimate asset is not removed to satisfy an invented minimum.

Can an observation with no asset be saved under this model?

Show the worked answer

No. The observation side requires exactly one, so zero is invalid even though an asset may have zero observations.

Acceptance wording to adapt

Allow zero or more observations per asset. Require exactly one existing asset reference per observation. Reject missing or multiple asset links on an observation.

Related resources