How to do One Type 4 entity line items dependent on another type 4 entity line items

[Former Member]

Dear All ,

We have one type 1 entity and one type 4 entity ( type 1 is leading with type 4 ) . Now we need another type 4 entity whose values are dependent on the first type 4 entity  values. How can we do modelling in MDG for this case ?

Use case is : For one line item of a table we need mulitple line items in another table . How can we do data modelling in this case

First type 4 entity

ID	Text(DE)	Text(EN)
WWR01
WWR02

Second type 4 entity

ID	REGION
WWR01	EU
WWR01	MX
WWR01	AU
WWR02	EU
WWR02	MX
WWR02	AU

[former_member196830]

Hello Ramesh,

It looks to me like you have two relatively independent SU Type 4 (qualifying) entities.

If your SU Type 1 (main) entity is MAIN

you can have two different qualifying entities: ENT_TEXT and ENT_REGIO

If your qualifier is the ID that has the values WWR01, WWR02, etc... this is a separate entity ENT_ID of SU Type 3 that has referencing relationship to your MAIN (e.g. ENT_ID to MAIN relationship name ID_VAL)

Now your first of the two entities that deals with the Text will be

ENT_TEXT, where you have MAIN to ENT_TEXT leading relationship e.g. HAS_TEXT and also your qualifying relationship QLF_TEXT from ENT_ID to ENT_TEXT.

ENT_TEXT would have the attributes that cover the different language texts like TXT_EN, TXT_DE, etc.

You can do the same thing for your second entity ENT_REGIO that deals with the regions you create, but since your table is now qualifying the second table, in this case your qualifying field would be the REGION when you do the relationship configuration and it would be between ENT_TEXT and ENT_REGIO entities.

Hope that helps

Regards,

Boris