You are creating a SQL Server Master Data Services (MDS) model. This model is used to store a master list of products. An attribute must be added to the Product entity to define the sales manager resp

A recursive hierarchy attribute defines parent-child relationships within the same entity and is not used to constrain values to members of a separate reference entity.

Explicit hierarchies in MDS are a way to organize entity members into a hierarchy structure and are not an attribute type that restricts value input on an entity.

A domain-based attribute links to another MDS entity and restricts input to only the members that exist within that entity, effectively creating a referential integrity constraint in the master data model. For the sales manager use case, a SalesManager entity would be created and the Product entity's attribute would reference it, so users can only select existing sales managers and cannot enter arbitrary invalid values.

User-defined attributes such as free-form text, numeric, or date allow users to enter any value of the specified data type and do not restrict input to a predefined list of valid members.

Derived hierarchies are calculated from domain-based attribute relationships and represent a hierarchy type, not a standalone attribute type that constrains values on a single entity attribute.

Parent is a concept related to consolidation members in explicit hierarchies, not a standalone attribute type used to constrain values on an entity attribute.