Hi All,
I have an association table with 3 columns (primarykeyId, foreign key to Table1, foreign key to Table2). I am thinking to have a child table pointing to this association table. The association table will have additions and deletions for new associations. Now the new child table will also be affected. Please note this new child table will have parent-child relationship with itself.
Is it a good design or could there be a better design possible?
Thank you,
Hussain