ch3+4 Flashcards
enhanced ER model
enhanced ER model
modifications to ER model from the 70s. more like object oriented. enables more complex data arrangement
subtype
subgrouping of the entities that is meaningful to organization. inherit attributes from supergroup AND have its own unique attributes
EER notation
subtype > circle > U shape
attribute inheritance
contain all attributes of supertypes up the chain
outpatient
patient in hospital for less than 24 hours
generalization
develop more general entity types from set of more specialized ones. bottom up process
specialization
top-down process to create subtypes
completeness constraint
addresses question of whether supertype can be a member of subtype. two types: total specialization and partial specialization
total specialization
rule that specifies EVERY entity instance of supertype is also a member of some subtype.indicated by double line to the circle
partial specialization
supertype does not have to fit into one of the subtypes
disjointness constraint
addresses whether supertype can be more than one subtype. two rules: disjoint or overlap
disjoint rule
supertype may cannot be more than one subtype. symbolized by “d” in circle
overlap rule
instance of supertype may be in more than one subtype, symbolized by “O” circle
subtype discriminator
attribute code of supertype that determines target subtype(s)
supertype/subtype hierarchy
hierarchical arrangement in which subtype only has one supertype
root
top of a hierarchy
entity cluster
put related entity types in a “folder”. good for macro view of data
packaged data model
buy a predefined datamodel so you dont have to make one from scratch. buying METADATA.
universal data model
generic template you can “copy and paste” then tailor to your needs
