Re: Determining Subtype from Supertype

eKo1 wrote:
Doesn't my example constitute a good business example? I just don't
see how I can have super/sub-types without running into the
aformetioned problems.

Another problem: How can I enforce referential integrity between the
supertype and the subtype? I could easily have a tuple in the location
relation that isn't referenced by any of the subtype relations.

The relational model is really limited to these types of situations.

.