In fact, relationships of this kind which are mandatory in both directions are perfectly common in data modelling and in business requirements - it is just that SQL Server is a poor tool for implementing such rules.For practical reasons it is usually necessary to compromise in some way.