I have such question.
When I create relations in ERWIN it sets foreign keys (FK), Witch are primary keys from the related table. I understand this. But, it also sets FK from primary keys of the table is related to table related to this table.
ERWIN does it automatically when I set identifying relationships.
Why doest it do so? And what is sense of setting this cross table FKs
Is it good for db??
If it is bad how to disable it in ERWIN. To set foreign keys only to directly related tables. Or it is better to set fk for all tables that have relation to current table?
If the relationship between table1 and table2 is identifying, then a row in table2 can't exist without a corresponding row in table1 This in turn implies that the PK from table1 is actually a part of the PK of table2.
Since the PK of table2 is actually the combination of tbl1_id and tbl2_id, those two columns need to be carried forward into table3 as FK attributes.
ErWin is software, and like any software it could have bugs. You are wise to challenge what ErWin does automatically, but ErWin is one of the very few software packages that I will assume it is correct until I can positively prove that it is in error and that happens very, very rarely!