How to Build a Business Rules Engine

Lists of Relationships

A complete list of relationships should be provided. Several lists would probably be

more appropriate as follows:

䊏

A list of all relationships by table. This will show all relationships in which a

given table is involved, irrespective of whether this table is the parent or the

child in the relationship. For each relationship the definition of the

relationship should be provided and the parent and child tables should be

identified.

䊏

A list of relationships by parent table. For each table, only the relationships

where that table is a parent table are shown. For each relationship, the

definition of the relationship and the child table are shown.

䊏

A list of relationships by child table. For each table, only the relationships

where that ...