Considering the scenario depicted in the diagram below, as the title says, can a weak entity type take part in an "is-a" relationship?

enter image description here


When I've modeled databases, I would use a isType description where you have isA. You appear to have two types of Specs; labelSpecs and itemSpecs. Common data belongs in Specs entity, with type specific data in the appropriate subtype record. Normally subtypes are exclusive, so a Spec would be either a labelSpec or an itemSpec.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.