Support optional/required dependents for all relationships

[ajcvickers]

See #24955 and #12100.

The idea here is to allow the model metadata to indicate that a principal cannot exist without the dependent also existing. We can't generally enforce this in EF Core, but assuming that the data in the database conforms to the model, we can generate more optimized SQL for queries.