This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I am using TDM (Toad Modeler) 220.127.116.11 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.