Recommendations on when to use relationship model
from @hgregory during the review of the blended model.
We understand that the relationship model is optional. However it'll be good to get a set of recommendations on when to use relationship model - such as complexity in modelling, performance, readability etc. A guidance on a trade-off scale will be very useful for the data defn team to apply such practices.