Is it possible to use a parent table Id instead of child table Id, when child table should put it's Id into another table <p>I have this Generalization relation ship between some classes in my class diagram. FirstClass as a base class that has Name attribute, SecondClass as a derived class that the FirstClass is it's base class and has some other attributes and finally ThirdClass that is a derived class from SecondClass and it has some other attributes too. ThirdClass as an association relation ship with Widget class, 1.*.</p> <p><img src="https://i.stack.imgur.com/8ytZp.png" alt="enter image description here"></p> <hr> <p>I used Joined strategy when I wanted to implement a Data Model from the class diagram. so the FirstTable has their Pk in the SecondTable and the SecondTable has its PK in the ThirdTable. As you see Third table should has it's PK in Widget class. And there are some costs whenever I want to Join widget table with third table because I need to fetch Name from First Table.</p> <p>Is it appropriate that I read Id from FirtTable (Actually it's base class) and put it into Widget table? </p> <hr>