Entity-Relationship/EER Data Modeling

EvilManagedCare

Senior member
Nov 6, 2004
324
0
0
I haven't been able to find the answer to this in my text. In database conceptual design, if there is an entity that is the superclass of one or more subclasses, do the subclasses inherit the relationships of the superclass? I understand they inherit the attributes, but I wanted to verify if relationships were also. My thought is yes, but thought I'd leave it to the experts. I have found one other collection of notes saying this is true, but still I need reassurance.

Thanks in advance.
 

jvroig

Platinum Member
Nov 4, 2009
2,394
1
81
Yes, that's how it works in the EER model. You may define other relationships for the subclass/subtype, but it already inherits the relationships the superclass/supertype has.