If you have table
x) which is 1 to many with table
y) which is 1 to many with table
z), it's pretty straight forward to define the foreign keys.
If for performance reasons, table
c was altered to be (columns
z) is there a way to specify that table c (columns
y) have a foreign key relationship to table
c contained 2 single column foreign keys
x --> table
y --> table
b. While this is correct, it creates erroneous results when trying to use commercial tools to create database diagrams.