Checking relationships and identify missing items (from Bottom Up scan) or floating items (from Top Down scan) may result in a quite long activity, especially for big databases.
And should always be performed by developers.
It would be nice have a procedure action "check relationships" that perform the scan and generate a report (txt or csv file) with the list of errors, indicating which entities and, optionally, which items are involved.
Configuration may suggest following options
> bottom up only, top down only, both
> entities list only, entities + items.
Such action can be included in a scheduled procedure, and results may be analyzed by non-developer users also.