Single Table Inheritance (Database Inheritance design options) pros and cons and in which case it us
- by Yosef
Hi,
I study about today about 2 database design inheritance approaches:
1. Single Table Inheritance
2. Class Table Inheritance
In my student opinion Single Table Inheritance make database more smaller vs other approaches because she use only 1 table.
But i read that the more favorite approach is Class Table Inheritance according Bill Karwin.
My Question is:
Single Table Inheritance pros and cons and in which case it used?
thanks,
Yosef