Non-Root Tables

When using a non-root table, the preferred situation is having the identifier of the non-root table match the identifier of the root table. In that case there is a one-to-one aggregation relation between the tables. However, more complex situations are supported, as described in Modeling BIIs for Complex Cases.