In data modeling, what is the preference on discriminator in the generalization process? Is it necessary to have a "type" attribute in super-type entity?
Les Barbusinski's Answer: I've never seen a data modeling tool that doesn't require a TYPE attribute to discriminate entity "sub-types" within a "super-type" ... so that sort of dictates your answer. In the real world, entity sub-types can be distinguished in one of three ways:
However, as a practical matter, all of these discriminators need to be "distilled" down to a single TYPE attribute in a data model. Hope this helps.
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access