I’m using TDM 22.214.171.124.
I tried to define an identifying relationship. The foreign key that it generates contains more than the primary key from the parent entity.
In the attached image, you can see that Entity6 has both columns a and x in the foreign key to Entitty4. I would expect the FK to Entity4 to contain only column a.
Here is the SQL generated for the FK:
ALTER TABLE Entity6 ADD CONSTRAINT Relationship11 FOREIGN KEY (a, x) REFERENCES Entity4 (a, x)
I couldn’t figure out how to remove x from this FK.