When I go to a relationship and check “mandatory child”, I don’t see any difference in the generated script compared to when it is not checked.
How does this get enforced?
How would one enforce it anyway when not using the modeler?
The conceptual rule would make a difference on whether I do an outter join when querying the parent and child tables together. But I don’t see how to enforce the rule when inserting.
It might be solved on app layer…