A Compound pattern helps us to define attributes that depend on a combination of two entities. This allows us to create additional flexibility when designing the application setup, creating values that connect through a many-to-many relationship.
When applying this pattern, the table has two fields of type code and a length of 10 characters. Both the values should allow blank values.
The following diagram explains how to implement the Compound pattern:
To use the compound table in the application, both the fields are members of the table that uses the attributes. Typically, the compound key values are inherited ...