This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I am using TDM (Toad Modeler) 188.8.131.52 for my design.
Exanple: I have 3 tables, say Table 1 ,Table2 and Table 3
Table 1 has Col1 as primary key and Table2 has Col2 which is a PK again. I draw a normal Relationship from Table1 to Table2 which created a PFK in Table which is correct and then I draw a realtionship from Table2 to Table 3 which created two PFKs however I was expecting only one PFK which is Col2 as PFK in Table3 but even col1 is also appearing in the Table3.