sample_datamodel

[antonybi]

Help me to create Link table at this situation to resolve all syn keys.

This is my data model in my actual data so am attaching only dummy data(which contains only fields and has no data).

Here how do we follow to resolve syn keys without renaming field names??

PFB for your reference!!!

Kindly suggest.

Any help will be appreciated.

[antonybi]

  Kindly check below sample application and suggest.

Is this data model gives us accurate results???

please suggest if anything wrong. !

[MK9885]

With out sample data it would be hard to assume what join can be made.

Names of the field can be changed,  HC can be Master table sine it has all the fields from other tables.

ID can be Primary key to link HC<>NS and maybe Client can be a key to link to TC<>HC table.

But without data it can be tricky.

[vishsaggi]

This looks good to me. Whats the issue you are facing?

[antonybi]

Yes I agreed. But here I just wanted to know the logic whether it was correct or wrong.

I have created too many reports with the first data model.

Afterwards, I have to resolve these syn keys by linking with link table or etc.

Link table which I have created (shown in the 2nd snapshot) I wanted to now does it(link table) cause any incorrectness of the data.

Kindly suggest.

[vishsaggi]

It should work good. However, you can also concatenate tables if they hold similar field names and no. of fields or use forced concatenation where possible. So which ever approach should work fine and also check your Information density and Subset ration for your table fields between all the linked tables.

[MK9885]

To test if the data model is correct, do either counts or sum, depending on what you have with small data set?